Hi all,
I have a excel file delivered weekly that contains various columns. O
Column A, for example, I would have an ID type and on Column B I woul
have the ID's descriptive text. Since the Column A and B are actua
troubleshooting errors for a company, I then have an action that fixe
each error and and the relevant average fix rate.

An example of which is 'here
(http://www.heaphydesigns.com/example.xls) :)

Anyways, how can I make a macro that will prompt the user for the ID
it will then scan ID column for the ID entered, and return the averag
fix rate of all the steps in one go

--
BravoGol

-----------------------------------------------------------------------
BravoGolf's Profile: http://www.excelforum.com/member.php...fo&userid=1475
View this thread: http://www.excelforum.com/showthread.php?threadid=27211

Hi
why do you want to use a macro. You can for example enter the ID in
cell C1 and use an array formula for calculating the AVERAGE. Where is
your data of interest stored?

--
Regards
Frank Kabel
Frankfurt, Germany


BravoGolf wrote:
Hi all,
I have a excel file delivered weekly that contains various columns.
On
Column A, for example, I would have an ID type and on Column B I
would
have the ID's descriptive text. Since the Column A and B are actual
troubleshooting errors for a company, I then have an action that
fixed
each error and and the relevant average fix rate.

An example of which is 'here'
(http://www.heaphydesigns.com/example.xls) :)

Anyways, how can I make a macro that will prompt the user for the ID,
it will then scan ID column for the ID entered, and return the
average
fix rate of all the steps in one go?