Reading a list of names to update their records

[Tom]

Hi,

I have a file named Inventory.xls which carries the records of all my stock
items. List.xls is a short column list of item names whose identical data in
Inventory.xls has to be updated by calling on a procedure Update07 which I
already have. Starting at the first item in List, how do you write the codes
to read this item, find its name in Inventory, call on Update07 then return
to the next item in List, repeat the process and stop when the item name is
a blank.

I'm open to other suggestions to do the same task. Thanks for any help or
suggestions.

TIA
Tom

 

[Pete_UK]

Check out VLOOKUP in XL Help - it will enable you to retrieve the
name.

I'm not sure what your Update07 procedure is.

Hope this helps.

Pete