benjaminyaon
10-09-2010, 02:59 AM
hello VBA Expert,
i would like to write a VBA code to sort a data and then create a sequence.
Please see the screen short,
I would like to sort the department first then sort the name. after sorting this two column, I would like to create a sequence number for each name in the same department, reset the sequence number for different.
how can i do this?Help and please advise, : pray2: : pray2: : pray2: : pray2:
4658
i would like to write a VBA code to sort a data and then create a sequence.
Please see the screen short,
I would like to sort the department first then sort the name. after sorting this two column, I would like to create a sequence number for each name in the same department, reset the sequence number for different.
how can i do this?Help and please advise, : pray2: : pray2: : pray2: : pray2:
4658