VBA to copy and paste row to next available based on value

[DaveNUFC]

Hey Guys

I have the attached sheet as an example and what I am trying to do is, if the category = 'Regular' and as soon as the progress is selected at 100% (meaning the task is complete), I want columns A:D to be copied and pasted to the next available row, with column F indicated as todays date (to prompt the user to amend this to the next one).

E.g. if Reference3 task- you change progress from null to 100%, immediately that row is copied and pasted to row 5, with a date due of today and blank progress.

Cheers

[tsamuels]

Do you have example code of what you have tried so far? What your asking for is not difficult but I personally would be more prone to help if you showed you were atleast trying and not just making request.

[Mumps1]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet.

Please Login or Register  to view this content.

[DaveNUFC]

Thanks Mumps1 that works great ;-)

[Mumps1]

My pleasure.