| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MERGING DATA FROM SEVERAL WORKSHEETS
is there a way to take the data from sheet1,sheet2,sheet3 and merge them into
one worksheet? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MERGING DATA FROM SEVERAL WORKSHEETS
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 On Jul 30, 4:49*pm, tammy p <tammy wrote: is there a way to take the data from sheet1,sheet2,sheet3 and merge them into one worksheet? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MERGING DATA FROM SEVERAL WORKSHEETS
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. "Amish" wrote: 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 On Jul 30, 4:49 pm, tammy p <tammy wrote: is there a way to take the data from sheet1,sheet2,sheet3 and merge them into one worksheet? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MERGING DATA FROM SEVERAL WORKSHEETS
"Amish" wrote: 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 On Jul 30, 4:49 pm, tammy p <tammy wrote: is there a way to take the data from sheet1,sheet2,sheet3 and merge them into one worksheet? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MERGING DATA FROM SEVERAL WORKSHEETS
Hi,
Try the method mentioned on this link - http://datapigtechnologies.com/blog/...iles-method-1/ -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "tammy p" <tammy wrote in message ... is there a way to take the data from sheet1,sheet2,sheet3 and merge them into one worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merging data/worksheets | Excel Worksheet Functions | |||
| Data merging with 2 worksheets | Excel Worksheet Functions | |||
| Merging data from 2 worksheets | Excel Worksheet Functions | |||
| Merging data from different worksheets | Excel Discussion (Misc queries) | |||
| Merging data in Worksheets !!!! - Help Please!!! | Excel Discussion (Misc queries) | |||
Linear Mode
