Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
data order in a chart | Charts and Charting in Excel | |||
Transfer data from sheet to sheet | Excel Discussion (Misc queries) | |||
Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions |