Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-11-2014, 01:04 AM
veedee veedee is offline Need help in automating data from multiple sheets into a single sheet Mac OS X Need help in automating data from multiple sheets into a single sheet Office for Mac 2011
Novice
Need help in automating data from multiple sheets into a single sheet
 
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, 20 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help in automating data from multiple sheets into a single sheet Need help in automating data from multiple sheets into a single sheet veedee Excel 1 06-11-2014 04:01 AM
Combine Data From 2 Sheets into a new sheet bremen22 Excel 1 09-11-2013 12:59 PM
If two geographical data match in two sheets, copy unique id/code found in one sheet alliage Excel 1 09-01-2011 05:23 AM
Need help in automating data from multiple sheets into a single sheet moving data from single to multiple columns? mzimmers Excel 3 08-23-2010 08:20 AM
Need help in automating data from multiple sheets into a single sheet How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft