attaching serial numbers

  • Thread starter deepika :excel help
  • Start date
D

deepika :excel help

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top