Hello,
I am needing to reference cell J2 on the “Data” worksheet for the file pathway in the below macro. How can I accomplish that? My goal is to have a concatenate in J2 on the “Data” sheet and reference this cell as the file pathway for the macro. That way I can easily change the 12.17 part each month within the spreadsheet and not have to go into VBA and change every month.
Thanks!![]()
Please Login or Register to view this content.
Bookmarks