Thread: Filtering ?
View Single Post
  #7   Report Post  
Tarjei Lundarvollen
 
Posts: n/a
Default

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


Sorry, forgot a slash. The correct link is:
http://home.online.no/~tb10/slett/logbooktest.xls

I have found a "work around" now, but it's not optimal, the file is 7MB
before I have started to input data (and is not even finish with the setup).

This "workaround" is to have three pages in the spreadsheet. The first is
only a summary page. The second is the actual logbook (just like in the
"demo" I have linked to above), and the third is a "aircraft specified type"
sheet with a LOTS of IF in it. Every line looks for the aircraft type in the
logbook page, and if its a small single engine piston it is copied into the
"single engine" coloumn, if its a multi engine piston it is copied into th
coloumn "MEP" and so on.

It works, but the file size is getting HUGE :)

Tarjei Lundarvollen, norway