Thread: [Solved] Need help in automating data from multiple sheets into a single sheet
View Single Post
 
Old 06-11-2014, 01:03 AM
veedee veedee is offline Mac OS X Office for Mac 2011
Novice
  
Join Date: Jun 2014
Posts: 3
veedee is on a distinguished road
Default Need help in automating data from multiple sheets into a single sheet
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
File Type: xlsx Test Data.xlsx (40.0 KB, 12 views)