multiple worksheet formula help

[kcip]

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?

[Max]

> 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_sheets.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?

[kcip]

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_sheets.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?

[Max]

"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
---