Auto fill serial number with Macro (Situation question)

[Alexlin]

Hi guys, me again, a VBA beginner.

I have the information below:- Column B1:E1 are the description. Then we copy the data from other sources based on these description (FilexxNAME, Nature, Place, Tool). We dunno the total number of the series. It can be 6 series (like example below), or it can be thousands of series. Some cells under the descriptions might be blank, but we still take it into account if other columns have value.

..FilexxNAME Nature Place Tool
1 dsdfsdsfsdfs (Blank) sdfsfd sdfs
2 sdfsdfsdfdfd sdfsdfds sdfd (Blank)
3 dsfsdfsdfdsf (Blank) sddsf (Blank)
4 (Blank)...... asdasdd adfdf dsfsd
5 (Blank)...... afsdfssd dsfds (Blank)
6 (Blank)...... sdfdsffd sddfff (Blank)
My question is how to auto fill the serial number with Macro based on the above situation?

What if I dun wanna use 1,2,3,4,5...etc., but using a,b,c,d,e,f,g....etc.?

Thanks a lot!

 

[Rijnsent]

Hi Alexlin,
what's the serial number you talk about? Is that the numbers 1,2,3,4,5,6 etc? If so, you could e.g. use the =ROW()-1 function to get a unique number. If you want letters and don't have over 16k rows:
=LEFT(ADDRESS(1,ROW()-1,4),LEN(ADDRESS(1,ROW()-1,4))-1)
Hope that helps,
Koen