Copying and pasting list information that is not fixed (using dynamic ranges)

[NB]

I have a database with 43 fields (mainly text) in which users will be
entering information via a data form. I would like to add another worksheet
that provides a summary of all the records, except with less fields (only
17) and different formatting.



I've encountered problems trying to copy this information to another
worksheet mainly because I'm not sure how many rows will have to be copied
over at any given time. I've found references on the web informing how to
create dynamic ranges (for both test and numeric information), so I've named
each of the 17 fields and used the offset and match functions to reference
only the cells that contain information.



Now,does anyone know a simple way that I can get thi information to display
on another worksheet, using the named range and hopefully without coding
anything. I can only get it to display a single cell and then I have to
drag and drop to view the remaining information in the named range. I need
the summary to appear without the user having to format anything.



Thanks,

Nancy

 

[Paul]

I have a database with 43 fields (mainly text) in which users will be
entering information via a data form. I would like to add another worksheet
that provides a summary of all the records, except with less fields (only
17) and different formatting.



I've encountered problems trying to copy this information to another
worksheet mainly because I'm not sure how many rows will have to be copied
over at any given time. I've found references on the web informing how to
create dynamic ranges (for both test and numeric information), so I've named
each of the 17 fields and used the offset and match functions to reference
only the cells that contain information.



Now,does anyone know a simple way that I can get thi information to display
on another worksheet, using the named range and hopefully without coding
anything. I can only get it to display a single cell and then I have to
drag and drop to view the remaining information in the named range. I need
the summary to appear without the user having to format anything.



Thanks,

Nancy

It would probably be much better to stick with a single worksheet and simply
define two different custom views.