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.

Hi
have a look at the INDIRECT function

--
Regards
Frank Kabel
Frankfurt, Germany

"Charlie Courier" <Charlie schrieb
im Newsbeitrag
...
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.