You may want to sort your data by the code and then use Data|Subtotals.

You'll get that extra line inserted along with totals/averages/counts (whatever
you choose).

Mr. Low wrote:

Hello,

I have the folowing table:


1 Code Date Amount
2 L21 XXX XXXXX
3 L21
4 U54 <--- insert a row above when the code
chanes
5 Y63
6 Y63
7 Y63
8
1499 B16
1500 P58

Is there a way for me to insert a row automatically above it code changes ?

Thanks

Low
--
A36B58K641

--

Dave Peterson