Perhaps you could accomplish this with a VLOOKUP function instead of a macro.

VLOOKUP looks down the first column for a matching value and returns a value
from a column to its right. You could place all the part numbers down column
A and their corresponding price in column B and lookup values with a function.
--
Kevin Backmann


"Tangohammerli" wrote:

I am working on a sheet for an employer who wants to be able to run a macro
and find duplicate entries and in put the correct price based on the search
criteria.
He wants only one sheet and the sheet must be dynamic as updates will be
occurring weekly.
The data is in the form of a parts descriptions and prices . so for
instance...
If there is an 8 In Flange any where in the parts list it should be linked
to the cost on an 8 in flange. And when ever an 8 in flange is entered the
cost should populate. There are about 29 individual parts so the macro should
be able to search for duplications of all 30 parts..
Is this possible???


Thanks in advance
--
Jim