Subject:
Excel VB code for deleting & updating multiple rows of data with different criteria
Message: Every Month I have to run 20 different reports and take the same five steps to get to data that I need.
Step 1-------Filter Unique Records only
Step 2-------Search for User Name with Feedback as criteria---then delete
Step 3-------Search for Reason Text with Feedback as criteria---then delete
Step 4------Search for Reason Text with Reprocess as criteria---then change data in the row to (0)
Step 5--------Search for data with blank in a Status Column as Criteria ---then delete
As you can see this is very time consumming any help with atomating these steps would be very helpful!
Excel VB code for deleting & updating multiple rows of data with different criteria
Message: Every Month I have to run 20 different reports and take the same five steps to get to data that I need.
Step 1-------Filter Unique Records only
Step 2-------Search for User Name with Feedback as criteria---then delete
Step 3-------Search for Reason Text with Feedback as criteria---then delete
Step 4------Search for Reason Text with Reprocess as criteria---then change data in the row to (0)
Step 5--------Search for data with blank in a Status Column as Criteria ---then delete
As you can see this is very time consumming any help with atomating these steps would be very helpful!
Last edited:
