MERGING DATA FROM SEVERAL WORKSHEETS

T

tammy p

is there a way to take the data from sheet1,sheet2,sheet3 and merge them into
one worksheet?
 
A

Amish

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
 
T

tammy p

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Does the order of worksheets matter ? 1
Check for two sheets. Add or subtract as necessary. 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Cell Reference 1
Help with linked formulas & multiple worksheets 8
Using SUM & VLOOKUP together?? 1
link to the pervious sheet 1
Excel Moving data to sheet2 from sheet1 0

Top