Filtermultiple data and copy them in another worksheet
 

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

Filtermultiple data and copy them in another worksheet
 

If the cells are gonna be copied, I'd just fill up those 2 empty cells below
each airport/runway code with the code above it.

Debra Dalgleish shows how you can do it quickly:
http://contextures.com/xlDataEntry02.html

She even shows how you can use conditional formatting to hide those repeated
values so the cells still look empty.

http://contextures.com/xlCondFormat03.html#Duplicate

=========
Another option may be to adjust your table. Put all the information on one row
(instead of 3). It really makes things like this easier.



Yasna wrote:

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

--

Dave Peterson