Thread: merge certain columns from worksheets
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 With QuoteReply With Quote