G
Guest
Would be extremely grateful if anyone could help.
I have to insert the filtered data for specific runway stored in
airport/runway list from Excel Workbook2 into a Workbook1 which contains
aircraft performance data for just one airport/runway.The The first out of
two columns in the list (Workbook2) contains airport/runway code (LHR08);
second column contains engine-out procedures (text) stored in 3 rows for each
runway. Once filtered, these three rows have to be automatically linked
(copied) in Workbook1 for matching airport/runway.
This is the example of the list in Workbook2:
List
Column1 Column2
Airport/runway Engine Out
Procedure
LHR09L Climb
straight
ahead
AMS36L Turn
right
Workbook1 contains performance data for only one airport/runway, with the
same space for engine out procedures as shown in column 2
I have to insert the filtered data for specific runway stored in
airport/runway list from Excel Workbook2 into a Workbook1 which contains
aircraft performance data for just one airport/runway.The The first out of
two columns in the list (Workbook2) contains airport/runway code (LHR08);
second column contains engine-out procedures (text) stored in 3 rows for each
runway. Once filtered, these three rows have to be automatically linked
(copied) in Workbook1 for matching airport/runway.
This is the example of the list in Workbook2:
List
Column1 Column2
Airport/runway Engine Out
Procedure
LHR09L Climb
straight
ahead
AMS36L Turn
right
Workbook1 contains performance data for only one airport/runway, with the
same space for engine out procedures as shown in column 2