macros with functions
 

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

macros with functions
 

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

macros with functions
 

On Thu, 20 Mar 2008 16:35:02 -0700, 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.


Application.worksheetfunction.vlookup(args....)
--ron

macros with functions
 

Instead, I would recommend using FIND. Look in the vba help index.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Robert" wrote in message
...
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