Hello, looking for help in macro
Book contains the columns A to AC
A- L arrival personnel
P- AC departing personnel
untitled.JPG
How to make copy cells A-L to different book but in proper order 1f then 2f if column N (split) contains the code 1f or 2f I cant sort it with A to Z as in that case departing personnel also changing the order.
1f stands for first flight, 2f stands for second flight.
tcver.xlsx