LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge data from different worksheets Merlin Excel Discussion (Misc queries) 3 June 4th 09 06:56 PM
merge certain columns from worksheets rhwong via OfficeKB.com Excel Worksheet Functions 4 January 24th 07 07:37 PM
Is it possible to merge data from two worksheets? Valerian Excel Worksheet Functions 2 May 12th 06 06:19 PM
matching data to merge two worksheets Gabrielle Excel Discussion (Misc queries) 1 February 23rd 06 05:28 AM
Merge Data From Multiple Worksheets Corby Excel Worksheet Functions 1 December 22nd 04 03:25 PM


All times are GMT +1. The time now is 04:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"