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.
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.