I have a monthly data where I need to find a way to transfer easily and more automated.
the data basically are sales to our 2 main customers, it comes with same format except that it varies in rows depending on how many sales in the month ( rows for each customer may increase and decrease).
I have attached both data source and the sheet where I need to transfer in.
Basically I need to transfer Values & Volumes for each customer
the Sales sheet is the sheet I need to put data in, it begins with customer 1 sales value which should be column O from data source, then Customer 1 Sales Volume which should be Column N from data source, the same order for customer 2
I tried to use Vlookup but the problem is the product name is repeated many times,
Please share your thought if there is any better idea instead of sort, copy, paste.