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

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

Can you use Vlookup in a Macro to search for duplicates of all 30 parts? Or
would you run the VL 30 times, once for each part??
Told ya I was new at this...
--
Jim


"Kevin B" wrote:

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