Combine data

's Computer Specifications

i have data in Sheet 1 under cell A1, B10, C5,D7
Sheet 2 under cell A1,B10,C5,D7
Sheet 3 under cell A1,B10,C5,D7
i want to combine the the data in the above 3 sheet in Sheet 4
Sheet A B C D
Sheet1 A1 B10 C5 D7
Sheet2 A1 B10 C5 D7 ..ect

's Computer Specifications

You could put the sheetnames in A2:Axxx
and the addresses in B1:E1

Then put this in B:
=INDIRECT("'"&$A2&"'!"&B$1)
And drag across and down.

osaka78 wrote:
>
> i have data in Sheet 1 under cell A1, B10, C5,D7
> Sheet 2 under cell A1,B10,C5,D7
> Sheet 3 under cell A1,B10,C5,D7
> i want to combine the the data in the above 3 sheet in Sheet 4
> Sheet A B C D
> Sheet1 A1 B10 C5 D7
> Sheet2 A1 B10 C5 D7 ..ect

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combine Data	osaka78	Microsoft Excel Misc	1	23rd Apr 2009 05:16 AM
combine data	scott	Microsoft Excel Misc	3	28th Aug 2008 09:31 PM
How do you combine subform data with mainform data?	John	Microsoft Access	2	1st Dec 2007 09:24 PM
Combine Data	=?Utf-8?B?Sm9obg==?=	Microsoft Excel Worksheet Functions	1	4th Sep 2006 09:57 AM
Need to combine and add data	smoked1	Microsoft Excel Misc	2	12th Jan 2006 07:56 PM