I don't understand enough of your question to fully answer it but if you
record a macro while entering a VLOOK function then it should put you on the
right track.

--
Regards,

OssieMac


"Robert" wrote:

I am using excel 2000. I have created a macro that will clear my "Invoice"
and post pertinent information to the first row of an "Invoice Log" that I
have created in the same workbook, but on another tab. I would like to have
the macro do a "VLOOKUP"? or some other function to post the next invoice
number into the invoice sheet and post the pertinent data to the appropriate
invoice# line on the Log sheet when I activate the macro and clear the
invoice sheet. I hope this makes sense. I don't know how to incorporate an
excel function like "LOOKUP" into a macro.
--
excelguy