K
KarenS
Hi,
I have 2 worksheets, one is a pre-designed form and the other whic
pulls data from Ms Access then auto fills in the relevant cells in th
"form" worksheet. Problem is.. the form is designed to only handle 3
records. My data is close to 200+ records.
I need to find a way to retain the "static" info on the form and hav
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?
Than
I have 2 worksheets, one is a pre-designed form and the other whic
pulls data from Ms Access then auto fills in the relevant cells in th
"form" worksheet. Problem is.. the form is designed to only handle 3
records. My data is close to 200+ records.
I need to find a way to retain the "static" info on the form and hav
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?
Than