Hi everyone:
I am a novice trying to write a macro for autonumber creation for the following format. Excel Gurus plz share your ideas in this thread. Thanks for your time.
chakravar
ID IP
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
131.128.197.79
131.128.197.79
131.128.197.79
131.128.197.79
131.128.197.79
131.128.197.79
131.128.197.79
131.128.197.79
I am a novice trying to write a macro for autonumber creation for the following format. Excel Gurus plz share your ideas in this thread. Thanks for your time.
chakravar
ID IP
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
1 128.119.169.245
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
2 128.172.1.115
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
128.172.115.93
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
129.63.184.5
131.128.197.79
131.128.197.79
131.128.197.79
131.128.197.79
131.128.197.79
131.128.197.79
131.128.197.79
131.128.197.79