I would like to "recreate" another Worksheet from another Workbook on My Worksheet, so I can do things with it. The title of the other worksheet changes everyday to include today's date. I would like to place the following in My Worksheets cell A1, and it always automatically update the date. I think I am missing something. Excel usually updates the filepath, file name, Worksheet, and cell automatically when I close the other file. Any help would be appreciated.
A1 --> = "filepath" & today() & "filepath".xlsx
or
A1 --> = "filepath" & A2 & "filepath".xlsx
What am I missing here in trying to make this work?
A1 --> = "filepath" & today() & "filepath".xlsx
or
A1 --> = "filepath" & A2 & "filepath".xlsx
What am I missing here in trying to make this work?