Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge data from different worksheets | Excel Discussion (Misc queries) | |||
merge certain columns from worksheets | Excel Worksheet Functions | |||
Is it possible to merge data from two worksheets? | Excel Worksheet Functions | |||
matching data to merge two worksheets | Excel Discussion (Misc queries) | |||
Merge Data From Multiple Worksheets | Excel Worksheet Functions |