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