Insert a new line

[just1joe]

I'm not sure how to do this in a macro. I have a sheet of data which contains columns for names, items and amounts. I would like to insert a row above the Row 2 and then insert rows each time the name changes. In the inserted row I would like a new column to increment a number for each inserted row, 1, 2, 3 etc. In this inserted row I also need the amount to be summed up for just the amounts listed below until the next inserted row.

- Joseph
excel 2000.

 

[LTunnicliffe]

Look into doing subtotals. Data-Subtotals.

This functionality is built into Excel.

Hope this helps!

 

[just1joe]

Thanks,

I was trying to use the data grouping and I wasn't working for me. I've never used the other thanks.