Help with links in one worksheet please

  • Thread starter Thread starter Derek Peters
  • Start date Start date
D

Derek Peters

Hi I have made up a worksheet that will work out all my takings & expenses
for the week.
I have then made a totals sheet which I would like to add up all the Weekly
totals for the year.

I have done all the links from the Weekly sheet to the totals sheet and they
all work fine.

As I will have 52 weeks how do I copy the links I have made for week one
(with the relevant changes for that weekly sheet) in the totals sheet?

I hope you can understand this

Any web sites that may help?

Thanks for looking

Derek
 
One way is to make a list of your sheet names in col A and use or a
modification this in col B
=INDIRECT(A20&"!f1")
or
=SUM(INDIRECT(A21&"!f1:f10"))
 
Derek

To start with, I think you may be better off having all weeks on one worksheet
then you can use Data>SubTotal or Autofilter or Pivot Table to look at weekly
items.

But, if you want to use 52 sheets.....

Make sure the weekly total is in the same cell on each sheet. Say G25.

On totals sheets enter =SUM(Week1:Week52!G25)

If sheets are not named Week1 through Week2, you can insert a dummy sheet to
the right of Totals sheet. Name it Start.

Add another dummy sheet after last sheet. Name it End.

Formula in Totals =Sum(Start:End!G25)

Second method allows you to insert new sheets between Start and End sheets as
your weeks progress.

Gord Dibben Excel MVP
 
Back
Top