notsoevilgenius
MIS
It's been a quite awhile since I had to do any VBA, but I have a new project.
There is a master.xlsx with all the data on it.
Each month the user downloads a new batch of data.
1. I need to compare the "Subscriber" columns (value is lastname, firstname) of the new.xls to the master.xlsx to determine new "Subscribers" and ADD them to the master.xlsx. (The original data did contain a unique id but that's been removed on the master list. I might have to go back in and have it re-entered by hand and then compare by that column)
4. I need to compare the "Subscriber" columns and "Amount" column and if the "Amount" has changed then change it on the master.xlsx.
If anyone can get me started I'd appreciate it. In the few things I've needed to do I've never had to compare stuff so that's new.
Thanks!
There is a master.xlsx with all the data on it.
Each month the user downloads a new batch of data.
1. I need to compare the "Subscriber" columns (value is lastname, firstname) of the new.xls to the master.xlsx to determine new "Subscribers" and ADD them to the master.xlsx. (The original data did contain a unique id but that's been removed on the master list. I might have to go back in and have it re-entered by hand and then compare by that column)
4. I need to compare the "Subscriber" columns and "Amount" column and if the "Amount" has changed then change it on the master.xlsx.
If anyone can get me started I'd appreciate it. In the few things I've needed to do I've never had to compare stuff so that's new.
Thanks!