Hi
I am trying to create a VBA script.
I have Customer Number on Column A, Date on Column B and Seq on Column C.
I start with Seq 1 for the first customer and date. If the next row has the same customer and the same date, I put seq 1 on column 1.
On change of any date for the same customer, increment seq by 1.
If the customer changes, reset seq to 1 and now loop through the on change of date increment the seq for that customer number
Repeat this until the end of the worksheet.
Visual
Customer - Date - Seq
10 Apr-4-2016 1
10 Apr-4-2016 1
10 Apr-5-2016 2
10 Apr-6-2016 3
10 Apr-6-2016 3
10 Apr-6-2016 3
10 Apr-6-2016 3
10 Apr-7-2016 4
15 Jan-1-2017 1
15 Feb-8-2017 2
So on and so forth.
I have 225000 records and am trying to automate this to get it done.
Can you please provide me a VBA script that will do this.
I am trying to create a VBA script.
I have Customer Number on Column A, Date on Column B and Seq on Column C.
I start with Seq 1 for the first customer and date. If the next row has the same customer and the same date, I put seq 1 on column 1.
On change of any date for the same customer, increment seq by 1.
If the customer changes, reset seq to 1 and now loop through the on change of date increment the seq for that customer number
Repeat this until the end of the worksheet.
Visual
Customer - Date - Seq
10 Apr-4-2016 1
10 Apr-4-2016 1
10 Apr-5-2016 2
10 Apr-6-2016 3
10 Apr-6-2016 3
10 Apr-6-2016 3
10 Apr-6-2016 3
10 Apr-7-2016 4
15 Jan-1-2017 1
15 Feb-8-2017 2
So on and so forth.
I have 225000 records and am trying to automate this to get it done.
Can you please provide me a VBA script that will do this.