Referencing worksheets

Greetings,

I have 52 worksheets, (week 1 - week 52), each is basically a timesheet
for multiple and variable staff members.
There are various calculation with regard to hours worked, tax, one each
of the worksheets.

I have another worksheet on which I wish to reference each of these
worksheet to extract a total for each week.

Q1: How do I reference each worksheet (week 1 etc) without having to
enter week 1!A35+ week 2!A35 etc?

Q2: How do I get a cell value from a worksheet into a Word document.
specifically Cell c25 and j42?

I have another worksheet which I want to add some more calculations on.
These are based on a Thursday to Wednesday payment.

Q3: Is there a simple way to use a formulae which I just type in a week
number (based on the Thursday pay date) which in
turn goes to the two week 1 & week 2 (or week 2 and week 3)etc then
puts the data in the new worksheet?

Ref Q2, I have named the cells, but I can never see them in Word.

Using Office 2000

Thanks in advance

Kevin
--
Kevin

try this where first is the first worksheet and last is the last worksheet
name
=sum(first:last!a1)
to get the total of all worksheets for cell a1

--
Don Guillett
SalesAid Software
[email protected]
<[email protected]> wrote in message
news:[email protected]...
> Greetings,
>
> I have 52 worksheets, (week 1 - week 52), each is basically a timesheet
> for multiple and variable staff members.
> There are various calculation with regard to hours worked, tax, one each
> of the worksheets.
>
> I have another worksheet on which I wish to reference each of these
> worksheet to extract a total for each week.
>
> Q1: How do I reference each worksheet (week 1 etc) without having to enter
> week 1!A35+ week 2!A35 etc?
>
> Q2: How do I get a cell value from a worksheet into a Word document.
> specifically Cell c25 and j42?
>
> I have another worksheet which I want to add some more calculations on.
> These are based on a Thursday to Wednesday payment.
>
> Q3: Is there a simple way to use a formulae which I just type in a week
> number (based on the Thursday pay date) which in
> turn goes to the two week 1 & week 2 (or week 2 and week 3)etc then puts
> the data in the new worksheet?
>
> Ref Q2, I have named the cells, but I can never see them in Word.
>
> Using Office 2000
>
> Thanks in advance
>
> Kevin
> --
> Kevin

Thanks Don ,

That worked a treat.

Regards Kevin

In message <#[email protected]>, Don Guillett
<[email protected]> writes
>try this where first is the first worksheet and last is the last worksheet
>name
>=sum(first:last!a1)
>to get the total of all worksheets for cell a1
>

--
Kevin J Prince

Please keep all questions in the ng unless invited to send to a personal
address. This way all may benefit from the questions/answers.

name a worksheet first and name a worksheet as last>put all others you want
to sum in between these>use the formula given.

You can create a template worksheet and whenever you want to add another
just right click on the sheet tab>copy>rename. Or, you may create a macro to
do 4 or 52 at once.

However, why not just use ONE worksheet and then use
data>filter>autofilter or advanced filter to select dates desired.

Don,
Thanks for the answer it worked a treat.

Can I be cheeky and ask one more thing of you....

How do I make it conditional, for example how do I wrap it up in an if
statement for the week 23 week 24 etc when they do not already exist.

I am currently creating the worksheets as required (month at a time,
create worksheet and copy last months basic form over to it (x 4
).)..... Is there a way of creating 52 identical worksheets with
formulae's and formatting etc all in one swoop?

Totally new to excel, trying to help my son get his business accounts
working a little better than they have been. He keep losing track of
stuff.

Regards

Kevin


--
Don Guillett
SalesAid Software
[email protected]
<[email protected]> wrote in message
news:[email protected]...
> Thanks Don ,
>
> That worked a treat.
>
> Regards Kevin
>
> In message <#[email protected]>, Don Guillett
> <[email protected]> writes
>>try this where first is the first worksheet and last is the last worksheet
>>name
>>=sum(first:last!a1)
>>to get the total of all worksheets for cell a1
>>
>
> --
> Kevin J Prince