merge certain columns from worksheets

[rhwong via OfficeKB.com]

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?

 

[vezerid]

By "merge", do you by any chance mean "concatenate"? I.e. "good"&"dog"
--> "gooddog"?

HTH
Kostis Vezerides

 

[rhwong via OfficeKB.com]

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.

 

[Gord Dibben]

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