Excel Formula/Sort Help?

[Guest]

I am creating a sheet for records of Crew members flying data.. sheet contains
CREW NAME DATE FLT# ROUTE DUTY TIME ON OFF FLT TIME ON OFF ...

1- How can i make a separate sheet with all the fields and have a submit
button (or anyother way to populate the information in the actual record
sheet. Everytime a submit button is pressed the data appears in the new row
of record sheet. Is it possible? Like a program...?

2- From this generalized record sheet (this includes all the crew members).
I want to extract record of each Crew member on separate sheets. Is it
possible? I tried VLOOKUP options.... but this requires the sorting of Crew
name Column in ascending order, which is not possible... as it is by date....
also there will be multiple entries for each crew member, i doudt VLOOKUP is
the right tool.

Please help!
or email.... i can send the file...
Furkan
(e-mail address removed)

 

[Guest]

What you want to create is much easier to do in an Acess Database if you
have it available. Simply create a form with the data you wish. In acess
after it is filled out it will automatically complete a new record. You can
also do simple reports or queries to print out your reports.
There is a forms option under the Data Menu that will allow you to have a
Simple form in Excel. First create the titles for each piece of data on a
blank spreadsheet- name flt # ect. Then when you select the form option
under data you will get a simple form to complete all the data in. after
each entry enter new and it will be added to the list as you wish. To make
it simpler for a add a button and record a simple macro that will open the
form when clicked. For the output I if you simply need a seperate page
printed for each crewmber simply copy the data to a new tab to avoid damaging
your database and use Data Subtotals to sort the Data by crewmember. Have
the At each change set to crew member, use function count to get the number
of missions for each crewmember. and at the add subtotal box select Crew name
for where the count will appear so the count will be Jim - 10 etc. Last but
no least make sure the Page Break between groups check box is checked and
this will insure each crew member is on his own page(s). Hope this helps.