Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making one cell change with each spreadsheet use?
I use a simple spreadsheet for invoicing. Each time I create a new invoice,
I save it as the customer name and date, leaving my invoice template unchanged. The template has my company name, logo, some basic info, some formatted lines, boxes, etc. I want all that to stay the same every time, and I want all my cells for part number, price, customer name, etc to be blank when I open the invoice template. However, is there a way I can get the template to reflect the next or previous invoice number? I'd like to have that number to "keep up with itself," for lack of a better way of putting it, so I don't have to look elsewhere to figure out what my last invoice number was and what my next invoice number should be. I feel like I didn't explain that very well. Please tell me what I left out. thank you, jm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamicly change spreadsheet tab names depending on cell value | Excel Discussion (Misc queries) | |||
How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
How to change the value of a cell when a condition is satisfied, but not otherwise? | Excel Discussion (Misc queries) | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) |