Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help writing basic macros in EXCEL..
I am having problems writing macros in EXCEL. I guess I need some specific
examples. For instance, in A1, I want to put in the date, in B1 I want to put in the day of the week, in C1 I want to put in the gallons of gasoline I buy, in D1 I want to put in the cost per gallon, in E1 I want to put in the total. Then I wan to be able to go to make another entry, and have the macro drop down to the row below A1. I am having problems, very bad problems. Maybe because I am too old [75] and cannot understand the complicated directions. Bob Gilmore |
#2
|
|||
|
|||
Write the item names in Row 1, per column.
Then use DataForm to add new rows or find and update existing rows. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Macro Help" <Macro wrote in message ... I am having problems writing macros in EXCEL. I guess I need some specific examples. For instance, in A1, I want to put in the date, in B1 I want to put in the day of the week, in C1 I want to put in the gallons of gasoline I buy, in D1 I want to put in the cost per gallon, in E1 I want to put in the total. Then I wan to be able to go to make another entry, and have the macro drop down to the row below A1. I am having problems, very bad problems. Maybe because I am too old [75] and cannot understand the complicated directions. Bob Gilmore |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
I Visual Basic Error "File Not Found" when Excel opens | Excel Discussion (Misc queries) | |||
Excel Macros | Excel Worksheet Functions | |||
where is the default directory of excel macros ? | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) |