Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference the same cell based on tab name
I have a worksheet listing all of our locations. On a summary tab, I want to pull a certain cell number based on the tab name but I can't figure out how to change the reference so that I can fill based on tab name. Column A has all of our branch numbers that correlate with the tabs. I want to pull out cell B17 from each of those tabs. Any ideas? Thanks!
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference the same cell based on tab name
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamically reference a cell based on cell content | Excel Discussion (Misc queries) | |||
Change color of characters in a cell based of a cell reference | Excel Programming | |||
Cell reference based on calculation | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |