Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button to increase cell value and print document
This is probably very easy but i dont know to much about macros yet.
Example I have a invoice ref # 001 (existing document) I want to press a button labeled "print" (user action) The macro adds +1 to existing invoice ref# cell. Copy the value of cell "X" , "Y" and "Z" and invoice ref# cell to spread sheet #2 (creating a database) Prints active worksheet. Saves the document Now I have a new invoice ref #002 and the 3 cell values are stored together in the database on spread sheet #2. This way, next time i'm invoicing, my database gets updated and i'll have a refrence number to all my invoices for history puposes. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Create Macro to Increase Cell Value to one and Print Worksheet | Excel Worksheet Functions | |||
In excel how do I increase a number in a cell by 1 after I print? | New Users to Excel | |||
excel how to put a print button in the document | Excel Worksheet Functions | |||
print out a document directly from a cell in the same raw | Excel Programming | |||
Macro to increase cell value by 1 each time button clicked | Excel Programming |