merge certain columns from worksheets

  • Thread starter rhwong via OfficeKB.com
  • Start date
R

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?
 
V

vezerid

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

HTH
Kostis Vezerides
 
R

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.
 
Top