I have data in a4:k27.
In Col B I have a flag set (called Active) to track active deliveries.
Not all rows have this flag but 11 rows always have this flag.
How to I extract only those rows with the 'active' flag and show in
cols B:G on Sheet1 only. The end result is that sheet 1 will show 11
active deliveries and various details.
Can it be done with a vlookup statement?

Thanks
Tony