G
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)
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)