Hi all,
Need some help if possible. I have found several options for a solution but not the perfect one.
Basically I have the attached spreadsheet as my master spreadsheet. I want to simply split that data based on the Captain ID Code. For example the rows containing Captain ID 7108 would be put onto a standalone sheet, the rows containing Captain ID 7042 would be put onto another standalone sheet and so on and so on.
This leading a to a larger project which I think I can manage myself, however if anyone has any ideas on how to use the data to auto populate a template. ie. All of Captain ID 7108's flight details would be placed into a template on a seperate sheet I would be grateful for the help.
Many thanks in advance,
Hayden
Need some help if possible. I have found several options for a solution but not the perfect one.
Basically I have the attached spreadsheet as my master spreadsheet. I want to simply split that data based on the Captain ID Code. For example the rows containing Captain ID 7108 would be put onto a standalone sheet, the rows containing Captain ID 7042 would be put onto another standalone sheet and so on and so on.
This leading a to a larger project which I think I can manage myself, however if anyone has any ideas on how to use the data to auto populate a template. ie. All of Captain ID 7108's flight details would be placed into a template on a seperate sheet I would be grateful for the help.
Many thanks in advance,
Hayden