data from one sheet to several in sequential order!
 

I am having a problem transferring data from one sheet to several in
sequential order!

I am building an overtime equalization form for 50 employees, sheet 1
is week 1, sheet 2 is week 2 and so on for each week of the year..
Column A is the employees names, column B is the hours from the last
week’s total, column C is the overtime hours from the last week, column
D is total across columns B and C on each sheet respectively. Columns E
– K represent Monday through Friday.

I have no problem getting the data to add on sheet 1 and 2, for
example:

I have the data coming from columns E – K sheet 1 to column C on sheet
2! I used the formula =Sum(Sheet1!E1,F1,G1,H1,K1), but on sheet 3 I
can’t get the data to column C by using =Sum(Sheet2E1,F1,G1,H1,K1) and
so forth.

Same for transferring the data from Column B sheet 2to column B sheet
3. I can get from 1 to 2 but not to sheet 3, 4 ,5 and so forth!

Is there an easy way? I have searched for days and still can’t figure
how to do it.

Am I way off base?


--
firecord
------------------------------------------------------------------------
firecord's Profile: http://www.excelforum.com/member.php...o&userid=24490
View this thread: http://www.excelforum.com/showthread...hreadid=380884

Couple ways:

1) do the SUM on each sheet (e.g. in Sheet1!L1: =SUM(E1:K1) then on
Sheet2, column C enter =Sheet1!L1

2) Make sure your sheet references are in the proper syntax: Sheet2!
(don't miss the exclamation point) so "=Sum(Sheet2E1,F1,G1,H1,K1)"
really needs to be: =Sum(Sheet2!E1,F1,G1,H1,K1). note: you can shorten
this to: =Sum(Sheet2!E1:K1)

Hope this helps.

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=380884

don't miss the exclamation point

OOPs! I checked and I only missed it in my post!

I try again as soon as I get back from Lunch!
Thanks


--
firecord
------------------------------------------------------------------------
firecord's Profile: http://www.excelforum.com/member.php...o&userid=24490
View this thread: http://www.excelforum.com/showthread...hreadid=380884

I must be tupid!

When I go to sheet 3 and put =Sum(Sheet2!E1:K1) a pop up comes up and
ask me to update the values for sheet 2. When I click OK it goes to
my folder work book is saved in! If I choose the wook sheet it shows
all the pages, I click on page 2 and it changes the value I just
entered in page 3 to "=SUM([Sheet2]Sheet1!E1:K1)"


What gives


--
firecord
------------------------------------------------------------------------
firecord's Profile: http://www.excelforum.com/member.php...o&userid=24490
View this thread: http://www.excelforum.com/showthread...hreadid=380884

I don't think you 'tupid'...but maybe your Excel is haunted. I cannot
replicate your system's behavior.

Try doing the SUM on Sheet2 in L1 (or some other empty cell)
=SUM(E1:K1) and just reference that cell on Sheet3 (=Sheet2!L1) and see
what happens. Make sure you don't have multiple sheets selected.

What happens?

b


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=380884

Man I must be STUPID!

I figured it out! When I made my sheets, 52 in all, I coppied from
page 1! So the name was not sheet 2 it was sheet1(2). When I figured
this out and changed the sheet names to Week 1 through Week 52, it
worked like a charm!

Great forum Thanks!


--
firecord
------------------------------------------------------------------------
firecord's Profile: http://www.excelforum.com/member.php...o&userid=24490
View this thread: http://www.excelforum.com/showthread...hreadid=380884

I'm glad you got it worked out. Rather than 'stupid', I like to think I
was just -preoccupied- at the time I screw up royally.

Good Luck.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=380884