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...

--
Message posted from http://www.ExcelForum.com

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$99 9=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.)


"debra2468 <" wrote:

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

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson