Hi,
What I have is a workbook where I have to filter on a column called ‘Code’ in a worksheet called ‘Current’ and search for varies criteria and then copy these filerted rows and paste into a worksheet called ‘Past’ and then delete the orginal rows form the ‘Current’ tab.
e.g. filter on a column called ‘Code’ and filter on the criteria that match ‘Monday’, ‘123’ and ‘Customer Accepted’ and paste at the bottom of the ‘Past’ tab and then delete from the ‘Current’ tab. A message should then be displayed saying “Data Transfered OK” with the curser then highliting ‘A1’ on the ‘Current’ tab
The only cavat is that the code may find none, some or all of the required criteria, however, in the event of finding no matching data then a message should then be displayed saying “No Data Found” with the curser then highliting ‘A1’ on the ‘Current’ tab
As I have to repeat this to filter on various columns for varoius cretia I intend to modify the code accordingly, however, in once instance I will have to filter on a column called ‘Code’ and filter on the creteria 1,2 and 3 etc but then I have to do second filter on column called ‘Code Extra’ and then do a filter on the creteria 4, 5 and 6 so the additional code would also be appreciated
Any assistance would be gratfully appreciated
Many thanks
Rob
Bookmarks