I don't know if this is possible, but I will ask.

I have 10 people and each person uses 3 columns: the range consist of
D1:F32, G1:I32, J1:L32 and so on.

I have the totals at the end in the ranges AH1:AJ32

In A34=10, which is for the # of people

My question is: If I want to add 4 people and change A34=14, that it
will automatically insert 4 people more people, in the range AH1:AS32,
while moving the totals to the range AT1:AV32.

Is this at all possible?

Thanks


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=540065