I have a workbook with 5 worksheets. The first worksheet is a master of the
other 4 worksheets. I want to have any data that is entered into any of the 4
worksheets automatically be copied into the Main worksheet onto the next
available row.
Can this be done??

Any help would be appreciated

Dale

It's not so much that it's hard to do - code attached to the 4 worksheet's
_Change() event processor could do the work. What makes it hard is coming up
with a workable set of rules that says when a row of data is ready to be
copied. You don't want to end up in the situation of entering data into Row
14 of one of the sheets and having the data staggered down the worksheet in
the master sheet because you copied each new cell entry to the master sheet
(onto a new row) with each entry. Even putting 'checks' in to, say count #
of cells filled and don't copy until a required number of them have been
filled on a row may go awry if you go back later and change the contents of
one cell on a row - you could end up with duplicate entries on the master
sheet.

Probably best way would be to have a macro set up that would copy the
current or last row on any one of the 4 sheets back to the master sheet 'on
demand' - either via a button on the sheets or a handy shortcut keystroke
combination.

"Dale Schwer" wrote:

> I have a workbook with 5 worksheets. The first worksheet is a master of the
> other 4 worksheets. I want to have any data that is entered into any of the 4
> worksheets automatically be copied into the Main worksheet onto the next
> available row.
> Can this be done??
>
> Any help would be appreciated
>
> Dale
>

Thanks for the response!!! I can set up the macro to select the last row of
data in the current worksheet but how do I tell it to paste to the first open
row in the master sheet.

Dale

"JLatham" wrote:

> It's not so much that it's hard to do - code attached to the 4 worksheet's
> _Change() event processor could do the work. What makes it hard is coming up
> with a workable set of rules that says when a row of data is ready to be
> copied. You don't want to end up in the situation of entering data into Row
> 14 of one of the sheets and having the data staggered down the worksheet in
> the master sheet because you copied each new cell entry to the master sheet
> (onto a new row) with each entry. Even putting 'checks' in to, say count #
> of cells filled and don't copy until a required number of them have been
> filled on a row may go awry if you go back later and change the contents of
> one cell on a row - you could end up with duplicate entries on the master
> sheet.
>
> Probably best way would be to have a macro set up that would copy the
> current or last row on any one of the 4 sheets back to the master sheet 'on
> demand' - either via a button on the sheets or a handy shortcut keystroke
> combination.
>
> "Dale Schwer" wrote:
>
> > I have a workbook with 5 worksheets. The first worksheet is a master of the
> > other 4 worksheets. I want to have any data that is entered into any of the 4
> > worksheets automatically be copied into the Main worksheet onto the next
> > available row.
> > Can this be done??
> >
> > Any help would be appreciated
> >
> > Dale
> >