Caculate fuel consumption in datasheet with mutiple vehicles.

Hi Louis en welkom ann die dorum

Im sure we can work something out that will suite your needs, but it will help if we could see what you are working with

I would suggest that you upload a sample workbook, showing what data you are working with (remove any sensitive info), show a few samples of what your expected outcome would be, and how you arrived at that.

(I grew up in SA, worked on the gold mines near Klerksdorp)

This is an easy task in Access. I have an Access template that I developed to do this for a friend a while back that I would share with you if this is a direction you would be willing to go. If you don't have Access installed, then you can get you a copy of Access Runtime (free from Microsoft) that will allow you to use the program without Access installed.

If alan's suggestion doesnt work for you, I say again, please upload a sample workbook for me to look at

Download Access Runtime fro this site: http://www.microsoft.com/en-us/downl...s.aspx?id=4438

Here is a copy of the db with some data in it. Play with it and if you decide to use it, then make sure you delete the sample data, run a compact and repair and then begin loading your data.

Read this about the installation and use of runtime: http://www.hitechcoach.com/

And finally, the file is attached in a zip file.

When I opened your file, I found no headers and did not know what each column represented. In addition, I received a circular error and some broken links in columns R, S and T which resulted in #REF in the formulae.

Alan

Hi Louis, I think you left off the headings and some sheets or something?

and the circular error mentioned by alan seems to confirm this. in S1, you have...=IF(I1=S$1,IF(G1="TtB",#REF!+N1,#REF!-N1),#REF!). The other #REF's may not matter, but if this is 11 of many other sheets, and you deleted the other sheets before sending, maybe copy/paste values on those referencing columns before you delete the other sheets?