Auto Numbering a Column

**suttercain** · 01-14-2007, 05:41 PM

Hi Everyone,

I am trying to have an auto numbering system. I got this part down, when I enter Green Lantern #1 then I grab the corner and drag down it numbers them for me and creates Green Lantern #2, Green Lantern #3, Green Lantern #4, etc.

My problem is I want to be able to do this for two other columns but it's not working. Example I have a column where I enter "images/gl20001.jpg" then I try the grab and drag method. But it only copies that text and replicates it. Now, if I remove the .jpg it works and numbers them sequentilly. But for my database I need the .jpg there.

Second column I am having the same issue is one where I want to enter "2000-01-01". It works when I do the drag and drop BUT it does it in this format "2000-01-01," "2000-01-02," "2000-01-03," etc. I need it to change the month so it would do it this way "2000-01-01," "2000-02-01." 2000-03-01." etc.

Can anyone please help me find the easiest way in doing this so I no longer have to hand type in the numerical values one by one. Thanks so much!

Shannon

**VBA Noob** · 01-14-2007, 05:55 PM

Hi,

How about some helper columns.

For Pic try

="images/gl"&2000&ROW(B1)&".jpg"

For 2nd Column try

=LEFT(A1,5)&TEXT(ROW(),"dd")&RIGHT(A1,3)

Two different ways. Play with every one best fits your needs

VBA Noob