Hi Hans, Thank you for your help!
Hi Hans, I apologize I did not have the time last night. You are a blessing to me! You have solved it! I copied the code and put it in the document...
Hans, I am not able to see the information for the file sent. I am not able to look at it all. All I see is in the picture I attached.
Sub Changedate() ' ' Changedate Macro ' ' Range("E1").Select ActiveCell.FormulaR1C1 = "='The Data'!R[25]C" Range("E1").Select Sheets("Sept 30th").S...
Hans, I am not sure how to PM you on this. So is there not a macro that would just pull and show the data from "The Data" sheet? If I have to t...
I appreciate your responses Hans! I don't want to put the document on this, but I can share pictures. Essentially what I am trying to accomplis...
Hi Hans, So "Sept 9th" did not exist any more, so that is where that error came from but is there a way that I can have it update it no matter what...
Hi Hans, I get a runtime error when the script is being ran. I used the debugger and here are the results. There will always be something in that f...
Hi Hans Hallebeek, Thank you for your answer! I am currently using Microsoft 365 Enterprise Version 2407. I don't have a problem with using macros ...