Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to submit data from one sheet to another with a macro and butt
I am doing a UI mockup and want to have a worksheet where data gets inputed
and then when the user is ready submits the data by clicking a button. At this point the macro checks that all required fields have data (will constrain the type using built in excel data type constraints) and enters it into table on another sheet. When it enters the data in the table it enters a new record and it creates a unique ID number in the table based on the previous entries int value incrementing by 1. I am looking for a short and sweet solution to this, if you have samples or can point me at good ones I would be very grateful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear a set of combo boxes after a Submit of data to a new sheet. | Excel Worksheet Functions | |||
Macro to automatically fill and submit (in batch) an online form fromdata in a excel sheet??? | Excel Discussion (Misc queries) | |||
Excel Multisheets, submit button to update database sheet | Excel Discussion (Misc queries) | |||
submit button in macro | Excel Programming | |||
Submit new data | Excel Programming |