Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy from B worksheet to A worksheet with NO repeated data | Excel Discussion (Misc queries) | |||
copy data in a cell from worksheet A to worksheet B | Excel Discussion (Misc queries) | |||
Copy data from one worksheet to another | Excel Programming | |||
Copy Modified Worksheet 1 Data to Worksheet 2 | Excel Programming | |||
copy all worksheet data into a new worksheet | Excel Programming |