| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
merge certain columns from worksheets
I have numerous worksheets in the workbook that I want to merge. I only want
to merge columns A thru F in each worksheet. They have the same headings. Is there a macro that I can run to merge them? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200701/1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
merge certain columns from worksheets
When you merge cells, only the values in the left most cells are retained.
Better to use concatenation: =CONCATENATE(A1,B1,C1,D1,E1,F1) etc. Dave -- Brevity is the soul of wit. "rhwong via OfficeKB.com" wrote: I have numerous worksheets in the workbook that I want to merge. I only want to merge columns A thru F in each worksheet. They have the same headings. Is there a macro that I can run to merge them? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200701/1 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
merge certain columns from worksheets
By "merge", do you by any chance mean "concatenate"? I.e. "good"&"dog"
-- "gooddog"? HTH Kostis Vezerides On Jan 24, 9:43 pm, "rhwong via OfficeKB.com" <u26788@uwe wrote: I have numerous worksheets in the workbook that I want to merge. I only want to merge columns A thru F in each worksheet. They have the same headings. Is there a macro that I can run to merge them? -- Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200701/1 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
merge certain columns from worksheets
Basically what I want is to have a master sheet with the information from
Columns A thru F of all hte worksheets in the workbook. I know that I can copy and paste but that would take time. vezerid wrote: By "merge", do you by any chance mean "concatenate"? I.e. "good"&"dog" -- "gooddog"? HTH Kostis Vezerides I have numerous worksheets in the workbook that I want to merge. I only want to merge columns A thru F in each worksheet. They have the same headings. Is there a macro that I can run to merge them? -- Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200701/1 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200701/1 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
merge certain columns from worksheets
Ron de Bruin has what you need.
Merge cells from all or some worksheets into one Master sheet. http://www.rondebruin.nl/copy2.htm Gord Dibben MS Excel MVP On Wed, 24 Jan 2007 19:08:16 GMT, "rhwong via OfficeKB.com" <u26788@uwe wrote: Basically what I want is to have a master sheet with the information from Columns A thru F of all hte worksheets in the workbook. I know that I can copy and paste but that would take time. vezerid wrote: By "merge", do you by any chance mean "concatenate"? I.e. "good"&"dog" -- "gooddog"? HTH Kostis Vezerides I have numerous worksheets in the workbook that I want to merge. I only want to merge columns A thru F in each worksheet. They have the same headings. Is there a macro that I can run to merge them? -- Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200701/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merge - columns | Excel Discussion (Misc queries) | |||
| merge worksheets | Excel Worksheet Functions | |||
| Merge cells in two columns | Excel Discussion (Misc queries) | |||
| how to merge worksheets in the same workbook | Excel Worksheet Functions | |||
| Multiple Worksheets and Print Merge function | Excel Discussion (Misc queries) | |||
Linear Mode
