Need help writing basic macros in EXCEL..

M

Macro Help

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
[email protected]
 
N

Niek Otten

Write the item names in Row 1, per column.
Then use Data>Form to add new rows or find and update existing rows.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top