Need to merge and delete records between two worksheets

J

jason.e.bliss

I have one worksheet that contains a list of records that shows how
many pictures are present for a work order. In another worksheet, I
have a list of work orders that were serviced on a given day. The
latter list has more records than the first. The first list is my
priority for billing. How can I merge the information from the larger
2nd list into the smaller 1st list, only using the information that is
relevant (identical work order numbers)?

Example

List 1
Order Address Photos
13179198 417 B STREET 5
13179655 55 Anywhere St 7 (Not needed to match List 2)
13179646 123 Main St 7

List 2
W/O # MAID SERV. GRASS CUT Completion Date COMMENTS
13179198 YES YES 4/9/2008
13179646 NO YES
4/9/2008 T/O NEEDED-BID TO FOLLOW
 
D

Don Guillett

Can be done but you should show us examples of the finished product. AND, do
you want list2 info imported to list1 and then list 2 data deleted, or kept?
 
S

Shane Devenshire

Hi,

Basic idea would be to use =VLOOKUP(Order,List2,SomeColumnNumber,False)

This would lookup the order number in List2, and return the entry in some
column number that you specify. The List2 range is the range in the second
sheet that includes the list, without titles starting in the Order number
column and extending as far to the right as your info. The SomeColumnNumber
is the numerical column number of the info you want to return, column
numbers are counted from left to right beginning with 1 for the Order
column.

Cheers,
Shane
 

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

Top