can i set excel to automatically copy and edit data?

chiidzzz

New member
Joined
Aug 28, 2012
Messages
11
Reaction score
0
Points
0
Hello there,
I am trying to make this logbook
I have in column A flight date, column B aircraft number
Column C defines whether the pilot (whose name is the title of the sheet) was the pilot in command or the second in command
And column D defines the other crewmember (which can be pilot in command or the second in command)
Here is what I want to do:
When I enter information in JOHN sheet for example, and I set him in column C as Pilot in command, and I assign in column D his copilot STEVE A, is there a way to make excel copy these information to STEVE sheet automatically and set column C as Second in command, and set JOHN as crewmember ?
I hope someone would be able to help.
Thanks in advance
 

Attachments

  • Book2.xlsx
    26.4 KB · Views: 16
Top