lemonap618
New Member
- Joined
- Oct 26, 2012
- Messages
- 33
Dear Mr. Excel,
I am currently working on comparing data between two tabs in my spreadsheet - "Merged Original" and "Merged SRO." My objective is to determine if customers from the "Merged Original" tab renewed their product ID subscriptions with my business by examining the renewals listed in the "Merged SRO" tab, specifically at the Opportunity ID (SO Line) level.
To categorize a renewal, I'm considering whether the customer bought the same products or more, based on the measure of ACV. Initially, I thought of concatenating necessary fields and comparing the tabs this way. However, I'm curious if there might be a more efficient or better approach for this analysis.
I've highlighted the pertinent fields in red for your reference if you'd like to take a closer look.
Thanks for the help!
I am currently working on comparing data between two tabs in my spreadsheet - "Merged Original" and "Merged SRO." My objective is to determine if customers from the "Merged Original" tab renewed their product ID subscriptions with my business by examining the renewals listed in the "Merged SRO" tab, specifically at the Opportunity ID (SO Line) level.
To categorize a renewal, I'm considering whether the customer bought the same products or more, based on the measure of ACV. Initially, I thought of concatenating necessary fields and comparing the tabs this way. However, I'm curious if there might be a more efficient or better approach for this analysis.
I've highlighted the pertinent fields in red for your reference if you'd like to take a closer look.
VBA Code: