Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Need help in automating data from multiple sheets into a single sheet
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 06-12-2014, 05:57 AM
carynsmith carynsmith is offline Need help in automating data from multiple sheets into a single sheet Windows Vista Need help in automating data from multiple sheets into a single sheet Office XP
Novice
  
Join Date: Jun 2014
Posts: 2
carynsmith is on a distinguished road
Default
The Consolidate tool allows you to combine worksheets where data is defined .
Reply With Quote
  #2  
Old 06-12-2014, 10:04 PM
macropod's Avatar
macropod macropod is offline Need help in automating data from multiple sheets into a single sheet Windows 7 32bit Need help in automating data from multiple sheets into a single sheet Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Quote:
Originally Posted by carynsmith View Post
The Consolidate tool allows you to combine worksheets where data is defined .
Perhaps, then, you'd care to explain to the OP how to get the desired output using the Consolidate tool?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

« Previous Thread | Next Thread »


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 04:03 AM.

Contact Us - Privacy Statement - Top

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