write macro col A date Col B gas col C dollars
 

I am trying to write a macro where I put the date in col A, go to col B and
put in the amount of gas, go to col C and put in price of gas, go to col D
put in mileage go to next col E an have it calculate miles per gallon then
ask if another entry is to be made. Then have it go to the next blank line
when the macro is run again. I am having problems as I do not understand all
of the terms in Excel, Lotus was much easier. If anyone can help I would
appreciate it.

Bob

write macro col A date Col B gas col C dollars
 

Forgive the silly question, but why do you need a macro?

If you want today's date, enter CTRL ;
The other entries are just entries.

To calculate the Miles per gallon (using Miles in E1 and Gallons in C1)
enter =E1/C1

I've been tracking my mileage and have also included the name of the gas
station. I'm seeing that I get better mileage from some stations than
others (although haven't done a full statistical analysis of it). Who
knows if it's because of the fuel or if the tank is more full at some than
at others. My MPG also appears be more stable if I fill the tank with
approximately the same amount of gas each time. I've had very low MPG when
I fill the tank and it's still half full.

"Macro Help" wrote in message
...
I am trying to write a macro where I put the date in col A, go to col B and
put in the amount of gas, go to col C and put in price of gas, go to col D
put in mileage go to next col E an have it calculate miles per gallon then
ask if another entry is to be made. Then have it go to the next blank
line
when the macro is run again. I am having problems as I do not understand
all
of the terms in Excel, Lotus was much easier. If anyone can help I would
appreciate it.

Bob

write macro col A date Col B gas col C dollars
 

I know you said you're looking for a Macro but I'm a fan of formulas and
would like to offer the following

Column E=Miles/Gal
version 1 =((D2-D1)/B2)
version 2 =(G2/B2)

Column F= Cost/Gal
=((C2/B2))

Column G=Distance Traveled
=D2-D1

I know it's probably too simple minded. But I like things that just work
and this works.

Hope this helps




"Macro Help" wrote:

I am trying to write a macro where I put the date in col A, go to col B and
put in the amount of gas, go to col C and put in price of gas, go to col D
put in mileage go to next col E an have it calculate miles per gallon then
ask if another entry is to be made. Then have it go to the next blank line
when the macro is run again. I am having problems as I do not understand all
of the terms in Excel, Lotus was much easier. If anyone can help I would
appreciate it.

Bob