Multiple actions/ macro

[EKG]

I have a spreadsheet which is being used to track projects and I need it to move things from sheet to sheet as the projects develop/finishes so I know at which point each project is.

They starts on either POH studies (sheet 1) or All other studies (sheet 2), the projects will be labelled in column A as ‘in set up’ to start.

They will then be changed to ‘open’ and then eventually changed to ‘Closed’, ‘Abandoned’ or ‘Awaiting Close Out’; when this happens I need the row copied and moved to the top row of Closed Studies Awaiting Archive (sheet 3). *note there is a macro in place that does this written by maras_mak *

Once other information is added to this page and the project is at a point column A with be changed to ‘Archived’. I would then like the row to be copied and moved to the top row of Archived Files (sheet 4) and deleted from Closed Studies Awaiting Archive (sheet 3).

Finally when a date is entered into column AI I would like the row to be copied and moved to the top row of Completed File Destruction (sheet 5) and deleted from Archived Files (sheet 4).

Is this possible?

Thanks in advance for the help.