Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Consecutive numbers in 1 cell
Hello!!
I´m trying to find a formula that changes the number in one cell, in a consecutive way, using a macro button or every time the file is opened. Example: The way a number of an invoice changes and doesn´t repeat itself everytime you open the file or once you click on an assigned macro button! Thank you in advance for your help. Luis Miller. |
#2
|
|||
|
|||
Luis, have a look here for ways to do it
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "LMiller" wrote in message ... Hello!! I´m trying to find a formula that changes the number in one cell, in a consecutive way, using a macro button or every time the file is opened. Example: The way a number of an invoice changes and doesn´t repeat itself everytime you open the file or once you click on an assigned macro button! Thank you in advance for your help. Luis Miller. |
#3
|
|||
|
|||
Create a button and rightmouse, View Code insert Range("J19").Value = Range("J19").Value + 1 to add one to a number in cell J19 To create a button, in Excel, View, Toolbars and ensure Control Toolbox is selected. On that toolbar, click to enter Design Mode (that icon now becomes 'Exit Design Mode') select Command Button and click in the required cell (say J20) Add the code as in my first line, then Exit design mode. You can later modify the buttons properties, usually the BackColour, dropdown and select the left (colour) tab, and Caption. LMiller Wrote: Hello!! I´m trying to find a formula that changes the number in one cell, in a consecutive way, using a macro button or every time the file is opened. Example: The way a number of an invoice changes and doesn´t repeat itself everytime you open the file or once you click on an assigned macro button! Thank you in advance for your help. Luis Miller. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=395477 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
up to 7 functions? | Excel Worksheet Functions | |||
Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
create a cell that accumulates, numbers from another cell... | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |