Run macro until row is empty

Hi.

Need a macro that will run until next row is empty.
two inputs are needed...if the two inputs are present in the databse, then it will show the other details

my idea is using VLOOKUP

Please Login or Register  to view this content.

Please see attachment

TIA

You will have to make sure the entries are the same as the items in the data Sheet.
I used an example of DataValidation to Make sure the Items to find were the same as the items in the Data sheet.

Originally Posted by smalltime

davesexcel

thanks..it works perfectly

about data validation..my file already has one.


thanks

I did a double check, your example had "Pencil" instead of "pencil",
I checked for data Validation the worksheet did not have one.

i suppose this code would work, when running it XL will assume it is for the active worksheet.

Please Login or Register  to view this content.