Copying Rows

**marnett14** · 04-28-2012, 04:55 PM

I am very green when it comes to excel, but I am learning. I would like to know if it is possible and how to make this happen.

I want every row I create in a book to copy to the first book. So every row I make in book 2, book 3 and book 4 automatically copies the information into a new row in book 1. Is this possible and how do I do it?

**TMS** · 04-28-2012, 06:06 PM

In principle, yes, it is possible. You would require a Workbook_Sheetchange event or individual Worksheet_Change events in each sheet. If the format of every sheet is the same, you could use the Workbook_Sheetchange event. Then again, it depends on whether or not you need to identify the source of the copied sheets. You could monitor a specific column where you put a marker/flag to say the row is complete.

Did you mean Book1, Book2, Book3, etc., or should that be Sheets?

I suggest that you post sample workbooks and more detail about what you want to achieve.

Regards, TMS

**zxchan** · 04-29-2012, 06:30 AM

I think you are referring a new worksheet within a book?

If so, see attached.
Basically, you can duplicate another worksheet by ticking the "Create a copy box"
hope this helps

1.jpg

**marnett14** · 04-30-2012, 08:20 AM

I am sorry, I did mean sheets, not books. How do I create a Workbook_Sheetchange?

Originally Posted by TMShucks

In principle, yes, it is possible. You would require a Workbook_Sheetchange event or individual Worksheet_Change events in each sheet. If the format of every sheet is the same, you could use the Workbook_Sheetchange event. Then again, it depends on whether or not you need to identify the source of the copied sheets. You could monitor a specific column where you put a marker/flag to say the row is complete.

Did you mean Book1, Book2, Book3, etc., or should that be Sheets?

I suggest that you post sample workbooks and more detail about what you want to achieve.

Regards, TMS

**TMS** · 04-30-2012, 12:39 PM

Press Alt-F11 to open the VBE.
Double Click on the ThisWorkbook item in the VBAProject on the left of the Editor to open it.
Click on the down arrow on the left hand selection box and choose Workbook.
In the right hand selection box, choose SheetChange.

This will create the framework/skeleton for the event.

You then need code to monitor the sheet(s) and copy rows when they are changed. Ideally, you'd need to monitor a specific column for a specific flag. When that column has the correct value entered, you'd copy the row to the other sheet.

Again, I would suggest you post a sample workbook and more detail about what you want to achieve.

Regards, TMS