We have a weekly excel file that records all our sales, inventory etc.
I would like to be able to pull some of the information from last week’s file when I start this weeks, using ‘C:\Weekly\[week2]inventory’!$A$1 works, but to reset all the different cells defeats the purpose.
What I would like is some way I could type in the name of the file (week2) in 1 place ($A$2), and then each formula would work using that 1 place. e.g. ‘C:\Weekly\[ $A$2 ]inventory’!$A$1
I would like to be able to pull some of the information from last week’s file when I start this weeks, using ‘C:\Weekly\[week2]inventory’!$A$1 works, but to reset all the different cells defeats the purpose.
What I would like is some way I could type in the name of the file (week2) in 1 place ($A$2), and then each formula would work using that 1 place. e.g. ‘C:\Weekly\[ $A$2 ]inventory’!$A$1
