| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
updating data lists using macros
I have a big list of data that must be added to daily. Severa
different columns must be entered and then sorted by date. I want t create a way to enter the required data on a "cover page" using custom entry form. So I want to know how to make a macro do th following: user enters data into form, then clicks "Update" button with assigne macro Macro then: takes the data from my form enters it in the data base (which is located on a seperate sheet in th file) clears form for next entry I can make it enter one row of data, but I don't know how to incremen it to have it enter data on the last available row each time -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating a workbook and macros | Excel Discussion (Misc queries) | |||
| Linking and updating mulitple lists | Excel Worksheet Functions | |||
| Updating Data in Validation Lists | Excel Worksheet Functions | |||
| macros not updating | Excel Worksheet Functions | |||
| Updating lists | Excel Discussion (Misc queries) | |||
Threaded Mode
