Please help..urgent !

D

debra2468

Hi,
I need help in constructing a macro which will insert values from tw
sheets present in the same workbook into another according to ite
number and transaction date.Can someone help me in this please ? I
yes,then i can mail you the workbook along with the requirement..i a
sure some of u'll may have a ready-made macro for this requirement...
 
D

Dave Peterson

How about a formula?

Say your lookup worksheet is named sheet2 with the item number in column A
and the date in B and value in column C.

And the same layout in sheet1 for column A and B:

=INDEX(Sheet2!$c$1:$c$999,
MATCH(1,(Sheet2!$A$1:$A$999=a1)*(Sheet2!$B$1:$B$999=b1),0))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)
 
Top