Hi,
I work in a construction project where we have an estimation software, but it is not linked to any cost control reconciliation software. I am trying to solve this through Excel but not managing to fix it.
I attach a file with an example with less lines than in original file which also included more descriptive comments whatīs need to be done
I need help with this:
1. Copy lines from sheet 1 to sheet 2 if certain criteria are met
2. If certain criteria in step 1 not is met all these lines should be copied to Sheet 2 but grouped into 1 line in sheet 2 (summing them together if two criterias are met)
3. Actual installed quantites are filled into Sheet 2 each month, so each month when the macro is used these numbers must remain
The macro will then be used once a month through a button
Very thankful if anyone could help me with this. I have managed to solve step 1 myself but not the rest.
TestingProductionbudget.xlsx
Bookmarks