Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine all the data's from different sheet to one sheet.
I am having data which is entered by different person's say a,b,c,d & e in
different sheets (a,b,c,d & e). I want to combine all this data into one sheet called Combine. Whereas the columns are same in the five person's sheet say (x,y,z). Do you have any formula for this. Thanks & regards, D.V.Sreenivas |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine all the data's from different sheet to one sheet.
could use the & symbol
i.e combine sheet cell a1 =sheet a&" "&sheetb&" "&sheetc ect "cheenu" wrote: I am having data which is entered by different person's say a,b,c,d & e in different sheets (a,b,c,d & e). I want to combine all this data into one sheet called Combine. Whereas the columns are same in the five person's sheet say (x,y,z). Do you have any formula for this. Thanks & regards, D.V.Sreenivas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link Sheet to sheet | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Important information on 2 sheets, combine? | Excel Discussion (Misc queries) | |||
In Excel combine tables from multiple worksheets in to one sheet? | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |