how do i use import to consolidate data from multiple sheets

G

Guest

i have a a Workbook that contains multiple sheets with Diff data, but having
the same Column & Rows. How do i consolidate all the data from these diff
sheets to make one report.

i hope my question is clear

Naveen
 
O

Otto Moehrbach

Not knowing anymore about what you have than what you say, I would say copy
and paste if it's your intent to have all the data from all the sheets on
one sheet. If not, what do you mean by "consolidate"? HTH Otto
 

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

How to consolidate data from different files? 2
how do i select all cells in a worksheet 3
Consolidate Multiple Workbooks - Excel 2007 1
Consolidate Auto to 1 sheet from many 3
Problem consolidating data. 1
Consolidate Lists from Multiple Sheets on another Sheet 9
Consolidate Excel Data from multiple sheets into one 1
Consolidate sheets 2

Top