ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i use import to consolidate data from multiple sheets (https://www.excelbanter.com/excel-worksheet-functions/83254-how-do-i-use-import-consolidate-data-multiple-sheets.html)

Naveen

how do i use import to consolidate data from multiple sheets
 
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

Otto Moehrbach

how do i use import to consolidate data from multiple sheets
 
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
"Naveen" wrote in message
...
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





All times are GMT +1. The time now is 09:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com