eye_in_the_sky
New Member
- Joined
- Jan 7, 2014
- Messages
- 10
It seems like this should be possible, just not sure how to pull it off...
I have a workbook that is linked to multiple other workbooks but only one at a time. I have formulas all over the place pulling data from a file called bravo01.xlsx. I want to be able to change all of the formulas at once to pull info from the from the same cells but in bravo02.xlsx, or bravo03, or bravo04, etc...
Is there a way to do this with a data validation list where the user selects a file from the drop down which in turn changes all of the formulas to link to the new file chosen? I'm open to anything.
Thanks!
I have a workbook that is linked to multiple other workbooks but only one at a time. I have formulas all over the place pulling data from a file called bravo01.xlsx. I want to be able to change all of the formulas at once to pull info from the from the same cells but in bravo02.xlsx, or bravo03, or bravo04, etc...
Is there a way to do this with a data validation list where the user selects a file from the drop down which in turn changes all of the formulas to link to the new file chosen? I'm open to anything.
Thanks!