Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a cell from a diferent tab when the tab name is in a cell
I have the name of a tab within a cell. How do I use this cell to look up
data on the tab. Tab 1 has the following entry:- Road 1 I wish to use this entry to go to the Road 1 tab and look up data held in cell M6 Road 1 could then be updated to Road 2 and I then wish it to go to the Road 2 tab and display information from the same cell i.e. cell M6 Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a cell from a diferent tab when the tab name is in a cell
Try =INDIRECT("'"&A1&"'!M6")
Where A1 has the sheet tab name. -- Regards Dave Hawley www.ozgrid.com "Ann" wrote in message ... I have the name of a tab within a cell. How do I use this cell to look up data on the tab. Tab 1 has the following entry:- Road 1 I wish to use this entry to go to the Road 1 tab and look up data held in cell M6 Road 1 could then be updated to Road 2 and I then wish it to go to the Road 2 tab and display information from the same cell i.e. cell M6 Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a cell from a diferent tab when the tab name is in a cell
If your tab name is in A1 then use
=INDIRECT("'"&A1&"'!M6") "Ann" wrote: I have the name of a tab within a cell. How do I use this cell to look up data on the tab. Tab 1 has the following entry:- Road 1 I wish to use this entry to go to the Road 1 tab and look up data held in cell M6 Road 1 could then be updated to Road 2 and I then wish it to go to the Road 2 tab and display information from the same cell i.e. cell M6 Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to copy the first word or two words from a cell containing a complete sentence to another cell | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
Compare two Worksheet and copy the diferent rows to other | Excel Discussion (Misc queries) | |||
How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions |