I need VB code to do the following. Take active cell from sheet A and look
for it on sheet B. If found return a value if not found return, "not found"
and then add a row under the row it returned a value to. It would continue to
look for the active cell from sheet A and repeat the above until it got to
the bottom of sheet B. It would then go down an active cell on sheet A and
skip the lookup it the active cell is empty until it found an active cell on
sheet A that was not and then it would do it all over again for say a counter
of 100...

first active cell = Part A from sheet A


Sheet B Value to Return
Part G 1-Jul-07
Part A 2-Aug-07
Part E 30-Dec-06
Part A 25-Jul-07
Part F 15-Oct-06

before Sheet A Value returned here
Part A
Part B
Part C
Part D
Part E

Sheet A Value returned here
after Part A 2-Aug-07
25-Jul-07
Part B not found
Part C not found
Part D not found
Part E 30-Dec-06

--
Regards,
Michael