Copy a cell from a diferent tab when the tab name is in a cell

A

Ann

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

attempting to format a color pattern in tab 3, based tab 2 and tab 5
tab in a cell 3
Locating cell using Hyperlink 10
Use "Tab" within a cell comment 1
Move part of cell only - help please 5
Name a worksheet tab based on the value in a cell. 1
Tab name = what's in a cell 10
Cell = Tab Name 2

Top