Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change tab a fomula references
Hello,
I was wondering if anyone could help me with figuring out how to change the wording in a formula just by changing the value in a cell on a completely different sheet. For example: I'm working with multiple sheets, named Warehouse 1, Warehouse 2, Warehouse 3, etc. I then have a sheet that gets data from the Warehouse 1 sheet ("Results" sheet). All necessary formulas have been entered to make the Warehouse 1 data populate correctly on the "Results" sheet. What I would like to do is pick a cell, say A10, in the "Results" sheet and enter (via drop-down or manually), for example, "Warehouse 15", so that the sheet will now update all formulas containing references to "Warehouse 1" to "Warehouse 15", pulling data from the "Warehouse 15 tab". Is this possible? Thanks in advance for any help you can provide. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change tab a fomula references
If the data is layed out like a table you could consolidate all the warehouse
data in a master summary sheet. Then you could use a pivot table to provide a variety of summarization, and you could use the warehouse number as a page field so you could drill down by location. Hope this helps... -- Kevin Backmann "Shoney" wrote: Hello, I was wondering if anyone could help me with figuring out how to change the wording in a formula just by changing the value in a cell on a completely different sheet. For example: I'm working with multiple sheets, named Warehouse 1, Warehouse 2, Warehouse 3, etc. I then have a sheet that gets data from the Warehouse 1 sheet ("Results" sheet). All necessary formulas have been entered to make the Warehouse 1 data populate correctly on the "Results" sheet. What I would like to do is pick a cell, say A10, in the "Results" sheet and enter (via drop-down or manually), for example, "Warehouse 15", so that the sheet will now update all formulas containing references to "Warehouse 1" to "Warehouse 15", pulling data from the "Warehouse 15 tab". Is this possible? Thanks in advance for any help you can provide. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change tab a fomula references
You'll need to use the INDIRECT function.
-- David Biddulph "Shoney" wrote in message ... Hello, I was wondering if anyone could help me with figuring out how to change the wording in a formula just by changing the value in a cell on a completely different sheet. For example: I'm working with multiple sheets, named Warehouse 1, Warehouse 2, Warehouse 3, etc. I then have a sheet that gets data from the Warehouse 1 sheet ("Results" sheet). All necessary formulas have been entered to make the Warehouse 1 data populate correctly on the "Results" sheet. What I would like to do is pick a cell, say A10, in the "Results" sheet and enter (via drop-down or manually), for example, "Warehouse 15", so that the sheet will now update all formulas containing references to "Warehouse 1" to "Warehouse 15", pulling data from the "Warehouse 15 tab". Is this possible? Thanks in advance for any help you can provide. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
easily change external references | Excel Worksheet Functions | |||
In charts, is it possible to change data references to relevant? | Charts and Charting in Excel | |||
how do I change cell references in a column | Excel Worksheet Functions | |||
Excel references change when importing data | Excel Discussion (Misc queries) | |||
How to change lookup references | Excel Worksheet Functions |