How do I link an identical cell address across multiple worksheet.

C

Charlie Courier

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.
 

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

How do I link a cell in a workbook? 1
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
External cell reference between two excel worksheets both in One Drive 0
Counting multiple criteria across columns and rows??? 2
How to update a value from a linked worksheet back to the master worksheet? 0
Styles Across Multiple Documents 1
Splitting Text from single cell in column across multiple Columns 3
How to update data from linked worksheet back to a master worksheet? 0

Top