i have three rows in a sheet s2
they are
Total Planned Hours
Total Available Hours
Difference


now i want to bring in the three columns after each name which is sorted and
merged(if there are more tahn one entry for a name). I want this to happen
dynamically// how do i proceed to bring in the three rows every time a macro
is run and at the end of every name.
for eg, i now have
colA colB...............
row1 X sit
row2 stand
row3 Total Planned Hours
row4 Total Available Hours
row5 Difference
row6 Y come
row7 Total Planned Hours
row8 Total Available Hours
row9 Difference


here since the name X gets over at row 2(actualy before inserting 3 rows
after that) i shud insert 3 rows from row 3 and for name Y i should insert
from 7. But the thing is that i wont know manually where the sit and stand
ends. Th emacro should find out.
Thanks for any help in advance