Tharabai
07-09-2015, 10:51 AM
Hi
Am new to macros and hope some one will help me with my requirement.
Below are the details of my requirement.
1. Two columns start date and end date (column H and I)
2. column with Type (column M)
Criteria 1 :
Same start date and end date in different rows with different type
eg. 12.13.2015 to 12.16.2015 with type "Credit1"
12.13.2015 to 12.16.2015 with type "Credit2"
12.13.2015 to 12.16.2015 with type "Credit3"
12.13.2015 to 12.16.2015 with type "Credit4"
For all these the criteria should be "same date with different type" in Column P
Criteria 2 :
Different dates with same type, then the criteria should be "Different date with same type" in column Q
Can this be done using VBA.
Immediate response for this is highly appreciated.
Thanks,
Tharabai
Am new to macros and hope some one will help me with my requirement.
Below are the details of my requirement.
1. Two columns start date and end date (column H and I)
2. column with Type (column M)
Criteria 1 :
Same start date and end date in different rows with different type
eg. 12.13.2015 to 12.16.2015 with type "Credit1"
12.13.2015 to 12.16.2015 with type "Credit2"
12.13.2015 to 12.16.2015 with type "Credit3"
12.13.2015 to 12.16.2015 with type "Credit4"
For all these the criteria should be "same date with different type" in Column P
Criteria 2 :
Different dates with same type, then the criteria should be "Different date with same type" in column Q
Can this be done using VBA.
Immediate response for this is highly appreciated.
Thanks,
Tharabai