Challengingn task

[harish kumar]

Dear all

For one of my project ,I would be required to have a sheet with data say 600 rows

Now what I have to do is first group this data in the block of say 98 .

so leaving first row for heading than subsequent 98 rows will be in one block and the next row after 98 i.e 99 row should be a sum total of number column.which will be inserted.than the procedure will be repeated till all rows are ehasuted.


.Now if i will do this manually it will take a lot of time,.

Can anybody suggest me new idea

[olasa]

I would do something like this:

1. include a helper column
=MOD(COUNTIF($A$2:A2,"<>0"),98) this will help me know when 98 number are included in a block.

2. make the subtotal based on the helper column
Menu: Data>Subtotals...

3. make the page breakes
Menu: View>Page Break Preview

4. include same headlines
Menu: File>Page setup>Sheet Tab>Rows to Include at top


Ola Sandström


Note:
A Pivottable can also be used.
="Page "&ROUNDDOWN((COUNTIF($A$2:A2,"<>0")/98,0)
...