Hi,

I have the folowing table:

A B C D
E
Flight Fare Type
1 M21 2,250 1
2 H32 2,530 1
3 T30 850 2
4 Q41 750 2
5 C47 650 2
6 Q21 3,650 8
7 Q72 3,820 8
5000

Column C is sorted in ascending order.

May I know the marco code that I need to run in order to insert an empty row
when the type changes ?

If column C is now moved to column E, how you code should be modified ?


Thanks


Low


--
A36B58K641