Hello Forum,
I need a macro that would look at spreadsheet called Tool Test Tab Review column J7 to J infinity and if column P7 to P infinity is < column J7 to J infinity the macro would copy the row starting a A7:B7:C7:D7:E7:F7:G7:J7 Overpayment Tab cell H7: I7: and L7 and paste it to Data Tab starting at row A18 and move to next row. I also need the boarders added for each row pasted to the Data tab. Important note after a row is pasted the yellow row must remain being pushed down each time a new row is added when the condition is met.
Please see attachment of the spread sheet named Tool Test. Thank you for your help in advance.
Bookmarks