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.
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.