This is a 2 part project..
first..
I have 2 excel files
file 1 has active subscription information (first name, last name, order #, amt, subscription information, date of next billing, billing cycle)
file 2 has a master file of customers:
(order #, customer data (address, email address, etc.)
i need to create a new file that will have the active subscriptions with the rest of the customer data pulled from the master file.
------------------
2nd part
i have 2 excel files,
1 is data with order #'s i have tracked for sales
1 is data with order #'s my partner has tracked for sales
i need a way to isolate the data on each file that is not in the other file.