| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference to a different spreadsheet
Hi. I have multiple spreadsheets and a "consolidated" sheet that ties them
all together. Right now, I have a formula in each cell that refers back to a different spreadsheet to get the data(=+'L:\Budget\2008\Susan\[Susan2008Budget.xls]Consolidated'!C10) That is working fine, but what I would like to do is have the name "Susan" in a cell and have the formula refer to the cell that the name "Susan" is in to create the formula. So, if I change where I want the data to come from, I only have to change the name in the cell that "Susan" is in. So if I changed Susan to Mike, the formula would read: =+'L:\Budget\2008\Mike\[Mike2008Budget.xls]Consolidated'!C10 Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference another spreadsheet on a share drive | New Users to Excel | |||
| How do I create a unique spreadsheet reference? | Excel Worksheet Functions | |||
| how can I cross reference 1 excel spreadsheet against another | Excel Discussion (Misc queries) | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| how do I reference a spreadsheet in a cell | Excel Worksheet Functions | |||
Threaded Mode
