Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I copy a graph and use the data in the new worksheet? | Charts and Charting in Excel | |||
Ignoring Rows When Extracting Data From One Worksheet To Another | Excel Worksheet Functions | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Data From One Worksheet To Be Used In A Cell In A Different Worksheet | Excel Worksheet Functions | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions |