| 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 |
| 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) | |||
Threaded Mode
