Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Update Info from Different Sheets?
I have a workbook that has 9 worksheets in it. The first 8 sheets are named May 2006, June 2006, etc etc etc. The 9th sheet is named Monthly Totals. I'm tracking commission bonus points with this workbook. I know that I've seen a formula for doing this, but the reference site I saw it on has been blocked and the boss won't be in until later today and I want to get this done before then (if possible). On the Monthly Totals sheet, I have the listing of all the sales guys in column A, and each month is listed in columns B - H. I would like to have the Monthly Totals sheet pull all the commission totals for George Smith in May, and enter that total amount on his corresponding cell, and then do the same thing for all the other sales guys, in all the other months. Thank you so much for any help you may be able to give me! I appreciate it! Samantha -- silencebreaking ------------------------------------------------------------------------ silencebreaking's Profile: http://www.excelforum.com/member.php...o&userid=35328 View this thread: http://www.excelforum.com/showthread...hreadid=550998 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Update Info from Different Sheets?
On worksheet 9 in the cell where you want the answer
1. Type =sum( 2. click on May 2006 hilight relevant cells 3. Press , 3.Click on next sheet 4.hilight relevant cells 5.Continue until all relevant cells are selected for all months 6.Press Enter on the keyboard Hope this is what you are looking for Sarah xx "silencebreaking" wrote: I have a workbook that has 9 worksheets in it. The first 8 sheets are named May 2006, June 2006, etc etc etc. The 9th sheet is named Monthly Totals. I'm tracking commission bonus points with this workbook. I know that I've seen a formula for doing this, but the reference site I saw it on has been blocked and the boss won't be in until later today and I want to get this done before then (if possible). On the Monthly Totals sheet, I have the listing of all the sales guys in column A, and each month is listed in columns B - H. I would like to have the Monthly Totals sheet pull all the commission totals for George Smith in May, and enter that total amount on his corresponding cell, and then do the same thing for all the other sales guys, in all the other months. Thank you so much for any help you may be able to give me! I appreciate it! Samantha -- silencebreaking ------------------------------------------------------------------------ silencebreaking's Profile: http://www.excelforum.com/member.php...o&userid=35328 View this thread: http://www.excelforum.com/showthread...hreadid=550998 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Update Info from Different Sheets?
I'm not sure if it is or not. There are 10 sales reps listed in each month. I want their individual amounts to show up next to their name, not everyones total amount. Or do you mean that I should go through each month, and select each sale that is made by George, John, Linda, Jim, etc, etc, etc individually to get the points to show up in their area on the total page? I'd like for it to automatically update the totals page when a new sale is entered, without the person entering the sale having to tell it to add the new sale each time. Thanks! Samantha Sarah_Lecturer Wrote: On worksheet 9 in the cell where you want the answer 1. Type =sum( 2. click on May 2006 hilight relevant cells 3. Press , 3.Click on next sheet 4.hilight relevant cells 5.Continue until all relevant cells are selected for all months 6.Press Enter on the keyboard Hope this is what you are looking for Sarah xx QUOTE] -- silencebreaking ------------------------------------------------------------------------ silencebreaking's Profile: http://www.excelforum.com/member.php...o&userid=35328 View this thread: http://www.excelforum.com/showthread...hreadid=550998 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Update Info from Different Sheets?
Try this
Type in cell a1 the number 3 click in cell b3 type = click on cell a1 press enter change the number in cell a1 Is this similar to what you want? "silencebreaking" wrote: I'm not sure if it is or not. There are 10 sales reps listed in each month. I want their individual amounts to show up next to their name, not everyones total amount. Or do you mean that I should go through each month, and select each sale that is made by George, John, Linda, Jim, etc, etc, etc individually to get the points to show up in their area on the total page? I'd like for it to automatically update the totals page when a new sale is entered, without the person entering the sale having to tell it to add the new sale each time. Thanks! Samantha Sarah_Lecturer Wrote: On worksheet 9 in the cell where you want the answer 1. Type =sum( 2. click on May 2006 hilight relevant cells 3. Press , 3.Click on next sheet 4.hilight relevant cells 5.Continue until all relevant cells are selected for all months 6.Press Enter on the keyboard Hope this is what you are looking for Sarah xx QUOTE] -- silencebreaking ------------------------------------------------------------------------ silencebreaking's Profile: http://www.excelforum.com/member.php...o&userid=35328 View this thread: http://www.excelforum.com/showthread...hreadid=550998 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Template update database, auto move down 1 row | Excel Worksheet Functions | |||
how 2 spreadsheets in diff locations with auto update | Excel Discussion (Misc queries) | |||
Auto update till...... | Excel Discussion (Misc queries) | |||
update info on 2 sheets @ same time | Excel Worksheet Functions | |||
How can I auto update a graph? | Charts and Charting in Excel |