Need help in automating data from multiple sheets into a single sheet

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Need help in automating data from multiple sheets into a single sheet

06-12-2014, 10:04 PM

macropod

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,521

Quote:

Originally Posted by carynsmith

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]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
moving data from single to multiple columns?	mzimmers	Excel	3	08-23-2010 08:20 AM
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 03:04 PM.