View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Moon Moon is offline
external usenet poster
 
Posts: 22
Default append two worksheets with excel macro

Hi all,
I have two worksheets from separate workbooks that I'd like to combine.
They contain different columns and different data. So for example in
sheet 1 I have:

Col1, Col2, Col3

and sheet 2:

Col4, Col5,

I want to put them in one worksheet like Col1, Col2, Col3, Col4, Col5
with data from sheet 2 appended to the last row of Col4.
Is this possible? Any help is greatly appreciated!
Moon