Identify and Paste New Rows in Old Sheet

[AnnaMc]

Hi,

I have two sheets in a workbook with identical columns. The combination of Column A and Column E is a unique identifier for each row. When a new row is added to Sheet 2, I need to automatically add the new unique identifier and all other information in the row to the bottom of Sheet 1 and it is very important that the rows do not change in Sheet 1.

I know this can be done using a button or a Change Event, but I don't know the logic behind either.

I have attached a spreadsheet similar to the one I am using.

Please help!

Thanks,

AnnaMc

[mrice]

When would you want the copy to be made? Is it when both columns A and E have values or is it when other cells in the row are filled as well? There is a danger of triggering a copy too early if data is being entered cell by cell.

[AnnaMc]

MRice,

Thanks for responding. That is a very good point. My end goal is for the copy to occur when columns A,B,E have been filled in and then the sumproduct formula in column F of Sheet 1 would fill in on the new row.

I have no idea if this is possible?

[mrice]

Try pasting the following into the Sheet2 tab in the VBA editor (Alt F11)

Please Login or Register  to view this content.

[AnnaMc]

mrice,

Thank you so much for your help!