View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Moon Moon is offline
external usenet poster
 
Posts: 22
Default merge two worksheets with different columns and data

Hi all,
I have two worksheets from different workbooks that I'd like to combine
to one worksheet. The two worksheets have different column names and
different data, meaning there aren't any common value that would link
them together.
So in sheet 1 I have columns:

Col1,Col2,Col3

and sheet 2:

Col4, Col5

I want them combined to Col1,Col2,Col3,Col4,Col5 with data from the
first sheet appended to the last row of Col3.
Any help is greatly appreciated!
Moon