Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link Worksheets to a Master Sheet
Hello all, I am trying to link multiple worksheets to a master sheet to summarise certain details of each sheet. Lets say that: Sheet1 A1=Mark B1=Pritchard Sheet2 A1=David B1=Howard I would like the Master to show: A1=Mark A2=David B1=Pritchard B2=Howard I know this can be done with =Sheet1!$A$1, Sheet2!$A$1 etc but there is quite a bit of data that I need to summarise and worksheets are constantly being added. So I was wondering if it is possible to make Excel automatically increment the Sheet1!, Sheet2! etc part of the formula as manually having to do this everytime a worksheet is added does not appeal. Tony -- Reefaman ------------------------------------------------------------------------ Reefaman's Profile: http://www.excelforum.com/member.php...o&userid=31968 View this thread: http://www.excelforum.com/showthread...hreadid=517951 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update consolidated sheet when data is added to worksheets | Excel Discussion (Misc queries) | |||
link between sheets get messed when master sheet is sorted | Excel Worksheet Functions | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Create a master worksheet based on 2 different worksheets | Excel Worksheet Functions | |||
how do i link a number of worksheets to one master worksheet? | Excel Worksheet Functions |