Inputting data to one worksheet for it effect another

Giganews Newsgroups
Subject: Inputting data to one worksheet for it effect another
Posted by:  daedalus1
Date: Sun, 25 Jun 2006

I have a spread sheet with two worksheets.  One is Input Data the other is
Data.  The first sheet inputs >mileage, >LPG gas in litres, >cost of gas in
pence, >comparison cost of petrol in pence, >Any miles done on petrol. Plus A
cell as a button to input the data to the data sheet.  I want to move the
data from these fixed cells and put it into the first free cell at the bottom
of the relevant column on the data sheet when I click on the input data
button.  The data sheet will then do all of the calculation and will send the
averaged fuel consumption for the input data and the averaged fuel
consumption for ALL input data back to the relevant cells on the input data
sheet.  I do not need to see the data sheet at all unless I click on the tab
at the bottom of the screen.

Thanks in advance

--
daedalus1

Replies