Home |
Search |
Today's Posts |
#1
|
|||
|
|||
updating invoice number on excel spreadsheet
I have made a spreadsheet to do service orders for my business. I have the
invoice number in one cell and will be typing the customers name in a different cell. I want the invoice number to change everytime I type in a name for the new service order. Can this be done. Thanks |
#2
|
|||
|
|||
Hi
not with formulas alone. For a starting point see: http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Regards Frank Kabel Frankfurt, Germany "beave" schrieb im Newsbeitrag lkaboutsoftware.com... I have made a spreadsheet to do service orders for my business. I have the invoice number in one cell and will be typing the customers name in a different cell. I want the invoice number to change everytime I type in a name for the new service order. Can this be done. Thanks |
#3
|
|||
|
|||
Do you type all the words that are shown as is. Does all tis get typed in
the formula box? |
#4
|
|||
|
|||
You may want to read David McRitchie's intro to macros at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm (no, it doesn't go into the formula bar.) beave wrote: Do you type all the words that are shown as is. Does all tis get typed in the formula box? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I automatically pull a new invoice number into an excel te. | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Updating 1 spreadsheet from another | Excel Worksheet Functions | |||
Increment an Invoice number | Excel Worksheet Functions |