Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking to other worksheets
I have 12 worksheets (Jan - Dec) each containing data for each month. I also
have a summary sheet that i would like to link to the monthly data. On the summary sheet my months are listed vertically A5 (Jan) - A16 (Dec) with sales data to go in B5-B16. Formula for B5 is =Jan!$B$35, B6 is =Feb!$B$35 and so on. How can I set it up so i don't have to manually type in the worksheet reference every time? For example it won't allow to reference the worksheet name from a cell: =A5!$B$35 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking my worksheets | Excel Worksheet Functions | |||
Please help - Linking worksheets | Excel Worksheet Functions | |||
linking worksheets | Excel Worksheet Functions | |||
Linking between worksheets | Excel Discussion (Misc queries) | |||
Linking worksheets | Links and Linking in Excel |