Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto Numbering Each Cell In A Column
I have a large series of images to enter into an excel worksheet. One page is
over 400 another is 1100. Is there a way to enter in the base name of the images and write a formula, or macro that will automatically add a four digit numbering system on the end. Starting with 0001 and ending with the last image? -- Thank you, UFWPresident |
#2
|
|||
|
|||
One way:
Put something like this in the first cell, MyPic_0001 then drag the fill handle (lower right corner of the cell) down as far as needed. In article , UFWPresident wrote: I have a large series of images to enter into an excel worksheet. One page is over 400 another is 1100. Is there a way to enter in the base name of the images and write a formula, or macro that will automatically add a four digit numbering system on the end. Starting with 0001 and ending with the last image? |
#3
|
|||
|
|||
You could put this in row 1 and fill down:
="imagename"&TEXT(ROW(),"0000") HTH Jason Atlanta, GA "UFWPresident" wrote: I have a large series of images to enter into an excel worksheet. One page is over 400 another is 1100. Is there a way to enter in the base name of the images and write a formula, or macro that will automatically add a four digit numbering system on the end. Starting with 0001 and ending with the last image? -- Thank you, UFWPresident |
#4
|
|||
|
|||
enter
=basename&text(num+row(),"0000") in A1 where basename is the what you want to call the beginning of the title and num is the correction that needs to be added to the row number to give the number you want "UFWPresident" wrote: I have a large series of images to enter into an excel worksheet. One page is over 400 another is 1100. Is there a way to enter in the base name of the images and write a formula, or macro that will automatically add a four digit numbering system on the end. Starting with 0001 and ending with the last image? -- Thank you, UFWPresident |
#5
|
|||
|
|||
try
=basename&text(num+row(),"0000") where basename is the initial part of the image identifier and num is the correction factor to the row number to make it say what you want. copy this and paste special value over the topof it. "UFWPresident" wrote: I have a large series of images to enter into an excel worksheet. One page is over 400 another is 1100. Is there a way to enter in the base name of the images and write a formula, or macro that will automatically add a four digit numbering system on the end. Starting with 0001 and ending with the last image? -- Thank you, UFWPresident |
#6
|
|||
|
|||
And if I wanted to start it on say row 3, but have the auto numbering start
at 0001, how would that be input. So far this is a great idea! Thanks. -- Thank you, UFWPresident "Jason Morin" wrote: You could put this in row 1 and fill down: ="imagename"&TEXT(ROW(),"0000") HTH Jason Atlanta, GA "UFWPresident" wrote: I have a large series of images to enter into an excel worksheet. One page is over 400 another is 1100. Is there a way to enter in the base name of the images and write a formula, or macro that will automatically add a four digit numbering system on the end. Starting with 0001 and ending with the last image? -- Thank you, UFWPresident |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions |