Re: Help with links in one worksheet please

Giganews Newsgroups
Subject: Re: Help with links in one worksheet please
Posted by:  Don Guillett (donal…@281.com)
Date: Mon, 3 May 2004

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"))

--
Don Guillett
SalesAid Software
donal…@281.com
"Derek Peters" <derek.pete…@btinternet.com> wrote in message
news:eSf6YYTMEHA.30…@tk2msftngp13.phx.gbl...
>
> 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

Replies

None

In response to

Help with links in one worksheet please posted by Derek Peters on Mon, 3 May 2004