This might be a silly question, but I haven't been able to find the
answer. I have one cell that will always have the the following
format: ABCD1111111111111111 (4 letters and 16 numbers). That will be
my first cell, I want to be able to create that number plus 1 on the
cell below, and repeat (scroll down) as many rows as there is
information on the left column. I t can be either using a formula or a
macro:
A B
1 Apples ABCD0000000000000005
2 Oranges ABCD0000000000000006
3 Pears ABCD0000000000000007
4 Coconut ABCD0000000000000008
I tried Autofill but it doesn't work, and neither does =previous column
+1.
Help!
Thanks!
Bookmarks