View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Insert Two Lines After Change in Project Number in Column A

If you can live with one row, you can do it with Data=Subtotals.

--
Regards,
Tom Ogilvy


"Nick C" wrote:

I have a list of project numbers starting at A11. I would like to insert two
rows everytime the project number changes, and put a sub-total for that list
of values in column N please.

Thanks,

Nick