data from one sheet to several in sequential order!

  • Thread starter Thread starter firecord
  • Start date Start date
F

firecord

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?
 
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
 
I must be tupid!

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


What give
 
I don't think you 'tupid'...but maybe your Excel is haunted. I canno
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 se
what happens. Make sure you don't have multiple sheets selected.

What happens?
 
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!
 
I'm glad you got it worked out. Rather than 'stupid', I like to think
was just -preoccupied- at the time I screw up royally.

Good Luck
 
Back
Top