Hi,

I have an idea to make use of the subtotal table to insert an empty row
below a change of certain reference in column C as ilustrated below:

A B C D
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

At pressent the Sub Total function is use for summing, averaging and getting
some other statistical derivations. It would be helpful to add one more
function of addindg empty rows only. With this function, the user can use it
to edit table with long listing of item whiout having to learn the Macro code
which is quite complicated.

For the next generation of Excel, I am really looking for more useful
functionality previously done by Macro could be simplify into desktop
function such as the one under Pivot Table and Sub total Table.

I hope my suggestion helps.

Thanks

--
A36B58K641

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions