Macro for a beginner making a mileage tracker

**Mickeal** · 07-18-2008, 10:43 PM

I have a simple spreadsheet made for a mileage tracker

Date Reason kilometers
today() a pull down list here enter a number

what I would like is to have a macro button that will fill in the information into another page with the same headings as above (chart). Then every time I enter information and push the macro button - it would put the information on the next line down in the chart. The end result is that every time I enter the values and press the button, it would enter the information on the chart on the next line down until it fills up.

I hope that I explained this well enough, and look forward to any help possible Thank-you

**protonLeah** · 07-19-2008, 01:49 AM

The code below will copy from one sheet to another.
You would use Data Validation, List for your dropdown list of reasons

Please Login or Register  to view this content.

Insert the macro:
Right click any sheet tab > View Code
On VB Editor Menubar, select Insert, Module
Paste the code copied from the window above
Modify the values assigned to InputCells, OutputSheetName, FirstOutputColumn to reflect your actual workbook values/names
Close the VBE
Insert a button from the FORMS Menubar and assign the macro, SaveData to it.
Suggestion for your list of reasons:
Put the list on a separate sheet. Select the entire list and type a name, say "REASONS", for it into the Name Box. Finally, select the cell you want the list to appear in, select Data > Validation, Allow List. In the Source box type: "=Reasons"

**royUK** · 07-19-2008, 05:39 AM

You can adapt the contacts form here

http://www.excel-it.com/vba_examples.htm

Macro for a beginner making a mileage tracker

LinkBack

Thread Tools

Rate This Thread

Display

Macro for a beginner making a mileage tracker

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions