I need to consolidate budgets for every state in the USA.
Each State budget is in a central server under one directory “S:\\Budgets\22-FL.xlsx
The two letters following the “22-##“ in the name file are for the State Abbreviation.
Florida = FL , Montana =MO and so on.
In the consolidation sheet, I would like to put a formula that looks for the Two letters in a column and then extract the information from that single state budget in the consolidation sheet column.
For example, C:5 has FL
So all formulas in column C: reference to “FL” budget “='S:\Budgets\[22-FL.xlsx]Sheet1'!$I$12
Thank you!!
Mauro
***Rather not use VB or have to open each budget sheet to accomplish this.
Bookmarks