Hello there.
I know next-to-nothing about programming VBA, and need some help with a problem. I've searched the forums and found several items similar to my issue, but I cannot seem to configure the code provided in those threads to work for my spreadsheet, hoping somebody might be able to assist.
I have a job summary page, and each row contains details about various jobs. If two criteria are met in each row, I'd like to be able to use a Macro to remove those rows from the main summary page and place them in another tab specifically for items containing these criteria.
Via the worksheet attached, the criteria would be Column B (Status) = Complete & Column E (Days Cleared) >=150. The moved rows would compound on the sheet 'Complete' so that using it in several instances, the moved rows would just stack and I could use Data>Sort to keep everything in-line.
Any help would be greatly appreciated.
Bookmarks