Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
multiple worksheet formula help
I have a 7 page workbook. Page 1 is the "master" sheet containing formulated
data from the other 6 sheets in the workbook. Each of the 6 other sheets are set-up with the exact same rows and columns - they are simply assigned to a different sales representative. I have the representatives "complete" a ROW on their sheet and "copy/paste" that row to the "master" sheet which then formulates the data via "sumproduct" formulas into charts. My problem is that I have 6 representatives who can't even copy/paste without making errors! What I need to do is find a formula that does the following: When a representative goes to one of the 6 worksheets, any ROW they complete will AUTOMATICALLY be COPIED over to the "master" sheet into an empty row. Does such an animal exist? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
multiple worksheet formula help
Does such an animal exist?
Think this creature from my archives might just fit the cage here <g: http://savefile.com/files/6862951 Auto_summarize_n_stack_lines_from_12_primary_sheet s.zip (Full details inside) As-is, it accommodates auto-copy from up to 12 "input" sheets (input range catered for is within A6:E130, viz: 125 rows x 5 cols per sheet) into a summary sheet, so you'd have a 100% buffer here (great provision for your future business expansion). Flexibility is provided to determine the desired stacking sequence from the 12 input sheets. And the creature will only stir and respond whenever F9 key is pressed - so you hold the control (Press F9 only when recalc's needed to summarize from the 12 input sheets). -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "kcip" wrote: I have a 7 page workbook. Page 1 is the "master" sheet containing formulated data from the other 6 sheets in the workbook. Each of the 6 other sheets are set-up with the exact same rows and columns - they are simply assigned to a different sales representative. I have the representatives "complete" a ROW on their sheet and "copy/paste" that row to the "master" sheet which then formulates the data via "sumproduct" formulas into charts. My problem is that I have 6 representatives who can't even copy/paste without making errors! What I need to do is find a formula that does the following: When a representative goes to one of the 6 worksheets, any ROW they complete will AUTOMATICALLY be COPIED over to the "master" sheet into an empty row. Does such an animal exist? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
multiple worksheet formula help
Thanks Max. Somewhat overwhelming initially, but I will try to understand
and apply. "Max" wrote: Does such an animal exist? Think this creature from my archives might just fit the cage here <g: http://savefile.com/files/6862951 Auto_summarize_n_stack_lines_from_12_primary_sheet s.zip (Full details inside) As-is, it accommodates auto-copy from up to 12 "input" sheets (input range catered for is within A6:E130, viz: 125 rows x 5 cols per sheet) into a summary sheet, so you'd have a 100% buffer here (great provision for your future business expansion). Flexibility is provided to determine the desired stacking sequence from the 12 input sheets. And the creature will only stir and respond whenever F9 key is pressed - so you hold the control (Press F9 only when recalc's needed to summarize from the 12 input sheets). -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "kcip" wrote: I have a 7 page workbook. Page 1 is the "master" sheet containing formulated data from the other 6 sheets in the workbook. Each of the 6 other sheets are set-up with the exact same rows and columns - they are simply assigned to a different sales representative. I have the representatives "complete" a ROW on their sheet and "copy/paste" that row to the "master" sheet which then formulates the data via "sumproduct" formulas into charts. My problem is that I have 6 representatives who can't even copy/paste without making errors! What I need to do is find a formula that does the following: When a representative goes to one of the 6 worksheets, any ROW they complete will AUTOMATICALLY be COPIED over to the "master" sheet into an empty row. Does such an animal exist? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
multiple worksheet formula help
"kcip" wrote:
Thanks Max. Somewhat overwhelming initially, but I will try to understand and apply. You're welcome ! -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mutilpe sheet , multiple formula help please. | Excel Worksheet Functions | |||
Recurring Excel Formula error - multiple users affected! | Excel Discussion (Misc queries) | |||
Excel should let me format worksheet tabs in multiple rows. | Excel Worksheet Functions | |||
how do i maintain one worksheet from data from multiple worksheet | Excel Worksheet Functions | |||
Multiple Condition Sumif Formula | Excel Worksheet Functions |