Finding values / goal seek

Hi

Im having a problem with excel which i was hoping some one could help or give me ideas. Basically im trying to find the perfect mix of investment and depreciation. It is a bit hard to explain so I have done an example which you can download here

http://rapidshare.com/files/93784983...nvestment.xlsx or here calculation investment.xlsx

So in the field of "final profit" you can see that values are after some adjustment by hand (copy/paste) are getting closer to somewhere between 15 and 16.

So my question is now: how can you do that without having to copy/paste all those lines before? im thinking of goal seek or solver in libre office but cant get my head around how exactly i would have to arrange it.

Does any one have an idea?

Thank you ever so much, greetings from Germany!

Hi and welcome to the forum

Please upload your file here, not all members can access file-hosting sites like that (firewalls and stuff)

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

also you should post here as its not excel
http://www.excelforum.com/for-other-...mobile-os-etc/

cant see what you want essentially goal seek changes only on cell where solver can change a range subject to limit of around 200 or so