Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I custom autofiller with VBA
Hi I am John.
I am using 2003 and would like to be able to locate last number in column "A" copy it and add 1 to it. Example.. 010970 current in lastrow cell A24. I would like cell A25 to autofill with 010971 when worksheet is opened. I know this is something simple but being new to excel I am having troubles. Thanks for all your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I custom autofiller with VBA
Is there any data in column B?
If there is, then you could use a worksheet function to automatically add the next number into column A. In cell A2 put [=if(B1="","",A1+1)] do not include the square brackets[ ]. Then copy and paste cell A2 to many locations under A2(as many as you think you will need, as many lines of data you are expecting). This formula looks at the data in the B column in the line above, if it is blank then nothing will show(in the example cell A2 would be blank if cell B1 is blank). If there is data in B1, then A2 will show an incremented value(A1+1). Hope it helps. Dennis "John" wrote in message ... Hi I am John. I am using 2003 and would like to be able to locate last number in column "A" copy it and add 1 to it. Example.. 010970 current in lastrow cell A24. I would like cell A25 to autofill with 010971 when worksheet is opened. I know this is something simple but being new to excel I am having troubles. Thanks for all your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Cell as custom type but data doesn't display like I custom. | Excel Discussion (Misc queries) | |||
2003 - 2007 custom macro and custom button restore. | Excel Discussion (Misc queries) | |||
Adding custom list and text boxes to the custom tool bar from Excel C API | Excel Discussion (Misc queries) | |||
custom lists and custom formulas? | Excel Discussion (Misc queries) | |||
Can you link a custom property to an Excel custom header text? | Setting up and Configuration of Excel |