software

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
quot;formquot; 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 quot;staticquot; 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 quot;repeat sectionquot; in Ms Access.

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

Thanx--
KarenS
------------------------------------------------------------------------
KarenS's Profile: www.excelforum.com/member.php...oamp;userid=31557
View this thread: www.excelforum.com/showthread...hreadid=512514