I want to make a pilot logbook in excel, and I have almost completed
the work, but I can't figure out how to do one function:
So, all your data is stored in sheet2, all other sheets are "reports"
on that data? Then you could try to create a pivot table on your data
in sheet2. You could list your planes with the sum of flight time etc.
etc.
Under Extras/Pivot tables you can start an assistant to create such a
table step by step, have a try.
Hmm, It might be me that did something "wrong", but I could not get it work.
A sample spredsheet which has the idea of what I want to do is on
http://home.online.no~tb10/slett/logbooktest.xls
The first page is just a summary page, the second page is the actual logbook
where I'm putting in the flight data, and the third page is the "summary"
page where all the lines that has "B737" as the "aircraft make / model /
variant" should be copied to (for this example just disregard all lines /
rows that don't have B737 as the aircraft type).
If anyone could have a look and tell me what you did to get it work like I
want it to do, that would be nice.
Tarjei Lundarvollen, norway