Hello,
I need to create a macro that would look on the network drive for the latest year folder (folder name is YYYY, ex: 2016), open, then look for latest period subfolder (folder name P ##, ex: P07), then look for latest week in file name (file name: YYYY Wk ##, ex: 2016 Wk29), then go to cell I5 in "Current Pricing 07-12-16, =VLOOKUP(A5,'[2016 Wk29.xlsx]Wk29'!$1:$1048576,12,0), do this lookup for range A5:A400, and input in I5:I400.
can you help please.
Can someone please respond to the above. I'm still hoping for a solution.
Bookmarks