Consolidate

S

Steph

Hello. I have a workbook that has 50+ sheets, all the same format. Is
there a way I can consolidate the data on all sheets into 1? Basically if I
were to do it manually, I would simply copy the data form one sheet, and
paste it under the others. No math or summing, etc.

Thanks!
 

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

Displaying data Horizontally 3
Consolidating Values 5
Copy contents from all sheets into 1 1
Consolidating Data to one worksheet 4
Sub-total using Advanced Filter? 4
Save specific sheets to new workbooks adding tomorrow's date to na 1
Consolidate (sum) last sheet (32) of all workbooks in a folder 15
Summing using column Heading 5

Top