VBA for copy and delete from one worksheet to another.

Status
Not open for further replies.

Thom78

New Member
Joined
Mar 30, 2021
Messages
5
Office Version
  1. 2010
Platform
  1. Windows
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.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,885
Office Version
  1. 365
Platform
  1. Windows
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.
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,130,182
Messages
5,640,665
Members
417,160
Latest member
Timon82

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top