Job description
I need a macro that will automatically perform functions to search the result for the data contained in each row separately, for rows that meet a given condition.
I am sending a sample file as an attachment.
The macro is to work as follows:
0. The formulas in column D should paste in the value format to column D to get rid of the formulas
1. for all rows where the value in the cells in columns AN or AP or AR is different from zero.
2. the macro is to perform the goal seek function according to the following rules.
3 Set the cell - cell in column AH
4. to the value that is in column M (the value is calculated using a formula, so here you need to copy the value into the goal seek formula)
5. changing the gross amount in column D
6. for recalculated rows, insert a "YES" marker in column AV indicating that a recalculation has been done (there will be a recalculation not for all rows.
