I'll try to be as descriptive as possible.
Current Status:
I have an excel file with two sheets: Cost Breakdown and Noise Reduction (Fassade).
The rows in the Cost Breakdown sheet which contain the word Noise in the column Ort need to be copied to the sheet Noise Reduction (Fassade).
The whole sheet Cost Breakdown needs to be scanned and the rows which contain the word Noise copied and pasted into the sheet Noise Reduction (Fassade).
If a value is changed in the a row containing the word Noise in the Cost Breakdown sheet, and this row already was copied to the sheet Noise Reduction (Fassade), this value has to be updated on the sheet Noise Reduction (Fassade) as well.
If a new row containing the word Noise in the Ort column in the Cost Breakdown sheet is added, this row has to automatically appear also in the sheet Noise Reduction (Fassade).
Attached I am putting an example of a workbook and how the desired output should look.
Thank you very much.
Bookmarks