crobinson661
New Member
- Joined
- Nov 15, 2019
- Messages
- 11
I am trying to write a macro to compare two product listings (labeled fruit) for a unique ID between two workbooks; current days output and previous days output.
The products (fruit) are combined in one cell, comma delimited.
Essentially, I want to subtract the previous day's string from the current day's data, leaving only the current day's data for delimiting and association with pricing figures.
I may be overthinking this, but I did a VLOOKUP from the previous day's data in a column and tried using SUBSTITUTE, where I substituted the string from the previous day with (""). This worked ok, except in the case above of "uniqueID1@email.com", where it doesn't isolate the middle value ("grapes")
Afterwards I needed to use SUBSTITUTE for removal of commas as well.
I know I can delimit the previous and current days data and then subtract the range, but it's a daily process and roughly 15K entries a day, so I'm trying to see if there are other options for streamlining that I just don't know about (This is VERY likely)
Any better suggestions?
The products (fruit) are combined in one cell, comma delimited.
Essentially, I want to subtract the previous day's string from the current day's data, leaving only the current day's data for delimiting and association with pricing figures.
I may be overthinking this, but I did a VLOOKUP from the previous day's data in a column and tried using SUBSTITUTE, where I substituted the string from the previous day with (""). This worked ok, except in the case above of "uniqueID1@email.com", where it doesn't isolate the middle value ("grapes")
Afterwards I needed to use SUBSTITUTE for removal of commas as well.
I know I can delimit the previous and current days data and then subtract the range, but it's a daily process and roughly 15K entries a day, so I'm trying to see if there are other options for streamlining that I just don't know about (This is VERY likely)
Any better suggestions?