Hello,

I am new to excel and trying to figure out the best way to put this together. I have mockup data (file attached) from two tabs - sales and inventory. I would have to combine sales and inventory data and put it together in Summary tab. Mockup data is small but real data runs into thousands of rows. Hence planning to automate this.

Any help of this would be highly appreciated.

Thanks in advance,
Veed

Attached Files

Test Data.xlsx (40.0 KB, 10 views)

Please don't post the same question in multiple locations. Closing this thread.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]