Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining data from various Sheets
I have data in three seperate sheets and they have exactly the same headings.
for example I have 10 records in each sheet. I want to have all the 30 records appearing in a new sheet!! How do I get the result? I tried Import data but that doesn't work very effeciently!! Is tere any function taht can help me to do that?? Cheers Raja |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining data from various Sheets
This should do it for you:
http://www.rondebruin.nl/copy2.htm Regards, Ryan--- -- RyGuy "Raja" wrote: I have data in three seperate sheets and they have exactly the same headings. for example I have 10 records in each sheet. I want to have all the 30 records appearing in a new sheet!! How do I get the result? I tried Import data but that doesn't work very effeciently!! Is tere any function taht can help me to do that?? Cheers Raja |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining data from various Sheets
Raja,
Select one sheet, copy it, then one row beneath the bottom -left cell of the data table, type an = sign, and navigate to the top -left cell of the data set on the next sheet and select that cell. Make sure that the address in the resulting formula doesn't have any $s in it (use F4 to cycle the $s), then press enter. Copy that formula cell across and down until all the data is imported, then convert the formulas to values. Do the same for the next sheet, and then delete the three original sheets and promise to never use more than one sheet for data in the future. And if you need to, insert another column where you can enter the sheet name for each of the records, if that is important. Then you can apply data filters and look at just those subsets of data, just like having three sheets! HTH, Bernie MS Excel MVP "Raja" wrote in message ... I have data in three seperate sheets and they have exactly the same headings. for example I have 10 records in each sheet. I want to have all the 30 records appearing in a new sheet!! How do I get the result? I tried Import data but that doesn't work very effeciently!! Is tere any function taht can help me to do that?? Cheers Raja |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining data from cells from several excel sheets to a new sheet | Excel Discussion (Misc queries) | |||
Combining sheets on one | Excel Worksheet Functions | |||
Combining data from different sheets in one | New Users to Excel | |||
Combining data from multiple sheets | Excel Discussion (Misc queries) | |||
combining data from multiple sheets | Excel Worksheet Functions |