Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search for latest date | Excel Worksheet Functions | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
Date Overdue function, Macro, or VBS | Excel Discussion (Misc queries) | |||
how to alter the date within a macro | Excel Discussion (Misc queries) | |||
How do I write a macro for... | Excel Discussion (Misc queries) |