My Lords, and Ladies,
I have in my company a workbook of many sheets and many columns. There is a sheet liqrSCH which contains a list of all the sites we have scheduled for the year. In Column K [Implementation Status] we track the status of the visit (e.g. scheduled, postponed, removed). Whenever a user changes the implementation status to either of Completed, Postponed, or Removed I would like the whole row (columns A:AM) to be transferred to the respective spreadsheet. To give you some examples below...
Site ID 0001 implementation status changed to = "Removed" -> transfer to liqrRMVD worksheet
Site ID 0002 implementationstatus changed to = "Postponed" -> transfer to liqrPPND worksheet
Site ID 0003 implementation status changed to = "Completed" -> transfer to liqrCPTD worksheet
Any help would be sincerely appreciated by the people of my kingdom.
With Thanks,
Mr. B
Bookmarks