Hi.

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:

The first page of the logbook is a "summary" page where some of the most
used flight times is shown. The second page is a electronic version of my
paper logbook (and on this page there is summary for each page in the paper
logbook) and on the next pages I want to have specified aircraft time
logged.

The problem is:

I want to log the time according to my paper logbook on page 2 in the sheet.
And then I want some kind of "filtering / copying" of this time so that the
logged time also transfer to the specified aircraft. Lets say that I logged
a flight with a Boeing 737 on page 2. I have then typed B737 in the "type of
aircraft" field, and I want the filter to look at the "type of aircraft"
column, and it this field says "B737", then I want that row to also be
copied to another page in the sheet (and I have named that sheet B737). The
reason for this is because I want to have a electronic copy of my logbook on
page 2, but I also want the spreadsheet to summary flight time on all the
aircraft I'm flying (and also new aircraft types in the future), and this is
done on by copying the logged flight time to subsequent pages in the same
spreadsheet. The "filter" needs to be able to look for many aircraft types
in the same column (e.g. B737, A320, C172, TB10 ...) and copy each row
(line) to the correct subseqent page in the spreadsheet.

Any hints, help or examples is highly appreciated.

Tarjei Lundarvollen, norway