Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I link an identical cell address across multiple worksheet.
I am linking data from multiple cities into a master workbook. Each city
workbook contains a page for the day of the week. I want to link the subtotals from the city into a master book that also runs by day. I am finding it tedious to link each cell one by one - i.e. [City]Mon!$C$30 to [Master]Mon!$C$5; [City]Tue!$C$30 to [Master]Tue!$C$5....etc. Since the linked cell addresses are the same across each page, there's gotta be a better way. I tried grouping the pages but that and linking but that only recognized one source cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why am I unable to link a cell in one worksheet to a cell in anot. | Excel Discussion (Misc queries) | |||
Can I link a cell to reflect a worksheet name? | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
GET.CELL | Excel Worksheet Functions |