Merging Worksheets

R

ROB

Is there a way to merge two worksheets so that rows with
the same value in a common field (such as "ID number")
are combined (i.e., the matching row from worksheet #2 is
placed in cells to the right of the cells used in
worksheet #1)! Thanks for any advice.

ROB
 
V

Vasant Nanavati

Hi ROB:

Look at the VLOOKUP function and then post back with specifics if you need
more help.

Regards,

Vasant.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
VBA Coding Help for Beginner 0
Page numbering with Merged Document and IF statements 1
Syncing between source worksheet and dependent worksheets 0
Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column 2
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Excel 2013 Merge Data 2

Top