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

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

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

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

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