Get values on sheet2 from sheet1 data

[fanoftu]

I am having problems... stuck... I don't know what to do next...I don't know how to command... I just hoped it would work but.. no...please help me...
I am trying to calculate two ways of traveling distance flying and driving. I am subtracting distancest that is not acquire for an actual distance. If I traveled twice, by air and by car. I want to have a table (like on sheet2). Can anyone please help me or fix my macro that doesn't make sense but only to me?

[XLGibbs]

Hi fanoftu,

had a quick peek at your file here, and to be honest, I am unclear as to the desired output. Do you intend to both have a table which stores values you wish to enter, and a method to view that information....?

Your sample is not exactly clear as to what you want out of it..but yes, there are ways to make it work depending on what it is you are after...