| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Worksheets
Hello all. I am trying to link multiple worksheets to one worksheet and show certain details on this worksheet. Lets say that cell A1 on sheet1 contains someones name and cell A1 on sheet2 contains a different name. I would like to show these names in cells A1 and A2 on sheet3(Master) respectivley. I know I can do this by using =Sheet1!A1 in cell A1 on Master and continue this down the column , but what i will be doing is adding a lot of worksheets so i was wondering if it possible for excel to account for new worksheets being added and automatically input the names entered in Cell A1 on the new "sheets" down Column A on Master. Hope you can understand this. Tony -- Reefaman ------------------------------------------------------------------------ Reefaman's Profile: http://www.excelforum.com/member.php...o&userid=31968 View this thread: http://www.excelforum.com/showthread...hreadid=517454 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I am getting #VALUE! when linking worksheets - what am i doing wro | Excel Discussion (Misc queries) | |||
| Linking Excel Worksheets | New Users to Excel | |||
| Linking between multiple worksheets, workbooks and columns | Excel Discussion (Misc queries) | |||
| Linking Several Worksheets to One Worksheet | Excel Discussion (Misc queries) | |||
| Linking across worksheets not working as desired | Excel Worksheet Functions | |||
Linear Mode
