LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
daedalus1
 
Posts: n/a
Default Inputting data to one worksheet for it effect another

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I copy a graph and use the data in the new worksheet? Brendanluc Charts and Charting in Excel 9 February 9th 08 06:49 AM
Ignoring Rows When Extracting Data From One Worksheet To Another Jim J. Excel Worksheet Functions 2 May 8th 06 04:55 PM
Saving data in a worksheet within a workbook Homeuser Excel Discussion (Misc queries) 2 August 21st 05 10:49 PM
Data From One Worksheet To Be Used In A Cell In A Different Worksheet ratt Excel Worksheet Functions 5 August 16th 05 03:13 AM
Macro to search for and display data in another worksheet Mark H Excel Worksheet Functions 0 June 14th 05 12:40 PM


All times are GMT +1. The time now is 09:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"