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