View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rahul Gupta Rahul Gupta is offline
external usenet poster
 
Posts: 21
Default Sum up With Macro

Hello,

I have three (One Text and two numbers) coloumns and approx 8000 rows and
about every 30-50 rows contains a heading such that they are merged.

Now i want to Insert a new row at the heading and put a sum of all the
numbers in both coloumns there. The sum will be inserted at the end of the
previous heading. for a heading you will find its sum at start of new heading.

There may be more than one merged headings.

Please guide me, how can i do this.

Regards,
Rahul