Separate an existing macro in two and add conditioning

[dreddster]

Hello Guys,

The password to unlock the file is test.

The current macro on button New Row in Sheet Source adds a new row in that sheet (by copy/paste of hidden row 8), and in Sheet Data creates "an analysis table" (copy/paste of hidden Columns I:L), and sets the formulas inside.

I would like to separate this macro in two - "New Row" macro to only add the new rows in sheet Source.
And the second part to work with a conditioning: If column 16 has YES, to create an analysis table for that row in sheet Data.

So If I have row 9, 10, 11 on sheet Source and only Row 10 and 11 have YES in column 16, to create two analysis tables in sheet Data (and the formulas to relate to these specific rows). Each time the macro is run, it will clearcontents and recreate the analysis boxes.

Any help would be greatly appreciated! Thank you in advance!

[dreddster]

Just a small update. The macro that deletes rows - I will adjust it myself to delete only rows on the first sheet.