M
Miles Reed
I am creating a worksheet for work. Does anyone know how
to do the following, or maybe it is not even possible.
Example:
WE are pilots, so we are trying to log who flew a
particular leg.
I have a name in cell A1 and A2 (both pilots)
In cell A3, is the place that we enter the time it took
to fly the particular leg
In cell A4, I have the question "who flew this leg?", and
it has a dropdown menu with the names of both pilots from
Cells A1 and A2 and U must select only 1 name
In cell B1 and B2 (cells next to each pilots name) is
another place for the flight time (contents of A3) to be
entered.
Here is the Question, Depending on whos name is selected
in A4, how can I tell Excel that I want the info in A3 to
be copied automatically into the respective cell next to
the pilot's name (B1 or B2)?
I repeat that with 4 columns (for example if the trip had
4 legs). Now, after all that is done, how can I add each
pilots individual times, and put them in Cells A8 and A9?
(A1 pilot's total flight time goes in A8 and A2 pilot's
total flight time will go in A9).
I hope this is not too complicated and i want to say
thank you in advance for your help.
to do the following, or maybe it is not even possible.
Example:
WE are pilots, so we are trying to log who flew a
particular leg.
I have a name in cell A1 and A2 (both pilots)
In cell A3, is the place that we enter the time it took
to fly the particular leg
In cell A4, I have the question "who flew this leg?", and
it has a dropdown menu with the names of both pilots from
Cells A1 and A2 and U must select only 1 name
In cell B1 and B2 (cells next to each pilots name) is
another place for the flight time (contents of A3) to be
entered.
Here is the Question, Depending on whos name is selected
in A4, how can I tell Excel that I want the info in A3 to
be copied automatically into the respective cell next to
the pilot's name (B1 or B2)?
I repeat that with 4 columns (for example if the trip had
4 legs). Now, after all that is done, how can I add each
pilots individual times, and put them in Cells A8 and A9?
(A1 pilot's total flight time goes in A8 and A2 pilot's
total flight time will go in A9).
I hope this is not too complicated and i want to say
thank you in advance for your help.