I understand this could be an advanced question so
potentially i might be willing to pay a small amount of
money if i get help.

I have a worksheet on the following form. A number of
fields contain, while the last column denotes a type
stretching accross several data rows. Something like:

dataA1 dataB1 dataC1 mark1
dataA2 dataB2 dataC2 mark1
dataA3 dataB3 dataC3 mark1
dataA4 dataB4 dataC4 mark2
dataA5 dataB5 dataC5 mark2
dataA6 dataB6 dataC6 mark3
dataA7 dataB7 dataC7 mark3
dataA8 dataB8 dataC8 mark3

Now, i can easily detect where a new type starts by
checking if the mark of the next row differs from the
current one.

The problem is that, after a change of mark, i would
like to perform the following.
1. Skip the contents of the second (and possibly the
third if it exists) row.
2. Merge the two first rows in the C-column
3. Make the contents of the first row centered (both
horizontally and vetically) and enlarge the font.

The result should be something like this:

dataA1 dataB1 dataC1 mark1
dataA2 dataB2 mark1
dataA3 dataB3 mark1
dataA4 dataB4 dataC4 mark2
dataA5 dataB5 mark2
dataA6 dataB6 dataC6 mark3
dataA7 dataB7 mark3
dataA8 dataB8 mark3

How do i do this?

--
Vänligen
Konrad
---------------------------------------------------

Sleep - thing used by ineffective people
as a substitute for coffee

Ambition - a poor excuse for not having
enough sence to be lazy
---------------------------------------------------