Hi I am a newbie to Excel VBA Coding so take it easy on me i this is a stupid question.
So, I will try to explain what I need as best I can:
So, I have a spreadsheet (we'll call it S1) that has over 3000 rows of data. Each row corresponds to a customer that has various customer related columns of data. I go through each customer row and use the data in various systems for work. Based on the outcome of my query, each customer row has a "Completed" or "Needs Follow-Up" at the end of each row.
After about 2 weeks, I get a newer updated spreadsheet (we'll call it S2) based on the activity of the previous weeks. Sometimes, some of the customers that I worked on in S1 also show up in S2.
What I need is a VBA code that will search the customers in S2 and if they also appear in S1, I want it to check to see if there is a "Completed" at the end of the row for the customer (in the S1 sheet, of course). If it does, I want that row to be deleted from S2. This is so I don't spend time looking up customer info that I have already worked on.
I need this to be a code that I can use on every new sheet that I get. So basically, I want the new sheet to be used to reference/compare customers on the previous or most recent sheet. So, think S2 to compare to S1. Then S3 to compare to S2, then S4 to compare to S3 and so on and so forth.
I hope that this hasn't already been explained. I was unable to find it if so. Thanks in advance for your help.
So, I will try to explain what I need as best I can:
So, I have a spreadsheet (we'll call it S1) that has over 3000 rows of data. Each row corresponds to a customer that has various customer related columns of data. I go through each customer row and use the data in various systems for work. Based on the outcome of my query, each customer row has a "Completed" or "Needs Follow-Up" at the end of each row.
After about 2 weeks, I get a newer updated spreadsheet (we'll call it S2) based on the activity of the previous weeks. Sometimes, some of the customers that I worked on in S1 also show up in S2.
What I need is a VBA code that will search the customers in S2 and if they also appear in S1, I want it to check to see if there is a "Completed" at the end of the row for the customer (in the S1 sheet, of course). If it does, I want that row to be deleted from S2. This is so I don't spend time looking up customer info that I have already worked on.
I need this to be a code that I can use on every new sheet that I get. So basically, I want the new sheet to be used to reference/compare customers on the previous or most recent sheet. So, think S2 to compare to S1. Then S3 to compare to S2, then S4 to compare to S3 and so on and so forth.
I hope that this hasn't already been explained. I was unable to find it if so. Thanks in advance for your help.
