Hi
I am trying to find the correct macro to allow rows in my worksheet to be moved to another worksheet based on the value in column K which is 'status'. I would like the row to be completely removed from Worksheet 1 and entered into the next available line in the required worksheet.
I have three worksheets and initially all data is entered into Worksheet 1 "Open". Once the row 'STATUS' (column K) is changed to 'closed' or 'tender' i would like to have the entire row removed to the appropriate worksheet (Worksheet 2 "Closed" or Worksheet 3 "Tender").
Also (though not important) I would like to be able to have the rows moved back to the "OPEN" worksheet if the status is changed from closed/tender to 'open'.
I have played around with a few different marco options but cant seem to find the right formula.
Example worksheet attached.
Any help is appreciated!
thanks
Bookmarks