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
Bookmarks