My office has a weekly rollup, where we have an excel that we manually populate for each day of the week.
I want to use a cell value as a filepath.
So, if A1 says 13Dec, B1 will become ''\Folder\Week\ [13Dec.xlsx]'
Concatenating gets the cell to have the string like I want, but how do I use it as a relative filepath that I can pull from?
I saw this post, but it doesn't work for me, and I'm new and can't comment on it.
https://stackoverflow.com/a/21072823/17636721
My ideal solution is picking a starting date from a drop down that makes 5 days worth of filepaths, and then people making their dated file each morning and it automatically being pulled in without each days workbook being open, like how linked workbooks functions.
Asked
Active
Viewed 26 times
0
-
Honestly, there's no good way to do this, IMO, but you can try some of the approaches in the linked threads. – BigBen Dec 09 '21 at 15:03