Hi,
I am running a report which ends up with 2 columns A- customer and B- sales -
These need to be pasted into a worksheet each qtr, which has already has a pre-existing column A with the customer names.
The report does not return customers with zero sales so the column A from the 2 sheets do not always match. If possible I would like a formula or to run a macro that would match the sales with the correct customer while leaving the remaining customers in the spreadsheet with zero sales. Or insert the missing names into the downloaded report with zero sales.
Thanks for any help,
LB
I am running a report which ends up with 2 columns A- customer and B- sales -
These need to be pasted into a worksheet each qtr, which has already has a pre-existing column A with the customer names.
The report does not return customers with zero sales so the column A from the 2 sheets do not always match. If possible I would like a formula or to run a macro that would match the sales with the correct customer while leaving the remaining customers in the spreadsheet with zero sales. Or insert the missing names into the downloaded report with zero sales.
Thanks for any help,
LB
