Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
'Consolidate' data from multiple worksheets | Excel Discussion (Misc queries) | |||
Lookup data from multiple sheets | Excel Worksheet Functions | |||
Combining data from multiple sheets | Excel Discussion (Misc queries) | |||
sumif to add data in multiple sheets | Excel Worksheet Functions |