Thread: Filtering ?
View Single Post
  #6   Report Post  
DS NTE
 
Posts: n/a
Default

Your link does not work !
Linken din virker ikke !
Linken din verke itj!(som vi sei i Trøndelag)


"Tarjei Lundarvollen" skrev i melding
...
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