Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
MERGING DATA FROM SEVERAL WORKSHEETS
0 views
Skip to first unread message
p@discussions.microsoft.com tammy p
Jul 30, 2009, 4:49:01 PM7/30/09
to
is there a way to take the data from sheet1,sheet2,sheet3 and merge them into
one worksheet?
one worksheet?
Amish
Jul 30, 2009, 5:33:11 PM7/30/09
to
There are several ways to do this:
The Consolidate feature will allow you to build a set of rules that
can Sum, Average, etc. (Note that checkbox that says Create Links if
your original data may change or you will to run consolidate again)
You could write a formula like =Sheet1!A5+Sheet2!A5+Sheet3!A5 (maybe
in A5 of Sheet4) and then copy that to other cells
The Consolidate feature will allow you to build a set of rules that
can Sum, Average, etc. (Note that checkbox that says Create Links if
your original data may change or you will to run consolidate again)
You could write a formula like =Sheet1!A5+Sheet2!A5+Sheet3!A5 (maybe
in A5 of Sheet4) and then copy that to other cells
On Jul 30, 4:49 pm, tammy p <tammy p...@discussions.microsoft.com>
wrote:
tammy p
Jul 30, 2009, 6:53:31 PM7/30/09
to
maybe i am not explaining it correctly, i want to physically move data from
sheet1,sheet2,sheet3 and combine them all in one. instead of having to copy
and paste them into a new sheet.
sheet1,sheet2,sheet3 and combine them all in one. instead of having to copy
and paste them into a new sheet.
tammy p
Jul 30, 2009, 7:16:01 PM7/30/09
to
Ashish Mathur
Jul 31, 2009, 11:29:07 AM7/31/09
to
Hi,
Try the method mentioned on this link -
http://datapigtechnologies.com/blog/index.php/using-access-to-combine-multiple-excel-files-method-1/
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"tammy p" <tammy p...@discussions.microsoft.com> wrote in message
news:80C16C78-1166-4CBF...@microsoft.com...
0 new messages