VBA for copy and delete from one worksheet to another.

[Thom78]

Hi All,

I'm new to the site. I wonder if anyone can help, as I have had a look through the posts but can't find a solution for this one. I have a spreadsheet with multiple worksheets. I would like it to automatically copy information from one sheet to another based on a criteria. The main tab is called "In Flight Updates". I have active columns A-AR. I set up a column "M" to use as my identifier. If the data entered info Column "M" = On Hold or Completed, then I want it to copy the entire row into an existing worksheet named "On Hold" and “Completed”. This row should be placed into the next available lines. I would be looking to delete these lines from “In Flight Updates” once they are copied over to the other worksheets I just can't seem to get the coding to work correctly. Can you help! Thank you in advance.

 

[Fluff]

Duplicate to: Copy row from one sheet to another based on one cell value

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.