Transferring data - Excel VBA Help

  • Hello,

    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.

    Many Thanks

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!