View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Randy L Randy L is offline
external usenet poster
 
Posts: 27
Default Would "lookup" work for this?

I have 2 sheets with similar data. Both are for orders placed by the
customer. But both sheets have different part numbers as well as the same
part numbers. What I am trying to do is pull from sheet 2 all the part number
orders and place on sheet 1.

For example Sheet 1:

Part No. 6/17 6/24 6/30
12334 2 4 3
12335 3 4 2
12337 2 2 0
18494 1 1 1

Sheet 2

Part No. 6/17 6/24 6/30
12331 1 1 1
12334 7 2 2
12337 2 8 4
17854 1 2 4


Would like to have the number of orders needed from sheet 2 sent to sheet 1,
appending them at the end of the columns with dates.

Part No. 6/17 6/24 6/30 6/17 6/24 6/30
12334 2 4 3 7 2
2
12335 3 4 2
12337 2 2 0 2 8
4
18494 1 1 1

Any help is most appreciated.