Repeat Section and Auto Fill
 

Hi,

I have 2 worksheets, one is a pre-designed form and the other which
pulls data from Ms Access then auto fills in the relevant cells in the
"form" worksheet. Problem is.. the form is designed to only handle 32
records. My data is close to 200+ records.

I need to find a way to retain the "static" info on the form and have
excel auto fill in gaps of 32 records until all records are loaded.
Then I want to have a grand total at the end of all records.

It's similar to the "repeat section" in Ms Access.

Can anyone tell me how to do this? if it's possible at all?

Thanx


--
KarenS
------------------------------------------------------------------------
KarenS's Profile: http://www.excelforum.com/member.php...o&userid=31557
View this thread: http://www.excelforum.com/showthread...hreadid=512514