Find and paste in first empty row when input in any other sheet

[Sofie1005]

Hello everybody.

I have an excel file with 4 sheets: 1 called "Summary" and 3 identical called "Review 1, 2 and 3".

In the "Review" sheets, is have 7 columns whereas 3 are also represented in the sheet "Summary".

My wish is for the excel file to automatically copy the input from those 3 columns, regardless of which of the 3 "Review" sheets I am using, to the first empty row in the "Summary" sheet.

The trigger could be either just an input in any cell in the row or input in a specific cell - doesn't matter.

As a side note: The "Summary" sheet does also contain other columns, these however will be used manually.

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach screenshots (not pictures) of your Summary sheet and one of your Review sheets. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

 

[Sofie1005]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach screenshots (not pictures) of your Summary sheet and one of your Review sheets. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

Okay, I will look in to that and get back. Thanks!