attaching serial numbers
 

i want to store serial numbers assigned to names somewhere in the excel and
when clicking on a macro which takes input from another sheet (which doesnt
contain Sr,No) automatically recognises teh name and assigns a Sr no to the
columnopn its left.
for eg.,

Col A Col B Col C
1 Jog Analysis
review

2 Mary Coding
Audit
Testing

Here the number of rows taht come from sheet1 are dynamic so whenever Jog is
seen it shud assign in col A the number 1 and so on... teh col C has dynamic
rows..so how many ever rowsi have in colC, i should have only the first row
of a particular name to display the number in Col A
.. how can i achieve this