Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying multiple worksheets to main worksheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying multiple worksheets to main worksheet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying from one worksheet to multiple worksheets | Excel Discussion (Misc queries) | |||
take all data from several worksheets to one main worksheet? | Excel Discussion (Misc queries) | |||
Copying Cell from Multiple Worksheets to a Summary Worksheet | Excel Worksheet Functions | |||
Transfering info from main worksheet to multiple worksheets | Excel Worksheet Functions | |||
how do i format from the main worksheet to the other worksheets s. | New Users to Excel |