Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Speedy line item entry with Macros
I'm trying to make a quick way to enter a line of data that is NOT repetitive
for time tracking. I want to click into the first column, then Tab through the rest and have it either autopopulate the data in the cell, or let me type a couple of letters to bring up the appropriate menu item from a list: DATE(auto enter today or allow to type) HOURS(default to 0.25 but allow free entry) Select(combo box choice of a few text items) Select2(another quick-choice list) Text field(free entry only) Reference(automatically add one to the field above it) Select3(another quick-choice list) Not a complex spreadsheet, but some macros might save me hours per year of typing considering I have to enter everything I do in the sheet during the day. Any help is appreciated as I have no idea where to start other than to fire up the VB editor. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
speedy way to do array-frequency? | Excel Discussion (Misc queries) | |||
Line Item | Excel Worksheet Functions | |||
Break one line item into many... | Excel Worksheet Functions | |||
Speedy way to create IF Function | Excel Worksheet Functions | |||
speedy way to set values in a range | Excel Programming |