How to generate a worksheet out of an Excel 2003 database?

[Guest]

Hello Friends, I have a simple database of 324 names and their
characteristics are detailed on each column (for example: address, male,
female, English, Spanish, etc...). I use this database for a Word mail merge.
What I am trying to do is that each time I add a name to the database, that
name gets copied to a specific worksheet (for example: male + English). Is
that possible, and what type of formula should I use? I am not an expert and
I am at my wit's end. Can you help? Thank you and Happy Thanksgiving! Chris
in Miami

 

[Guest]

Hi Chris,

There is no easy way to trigger a copy when you enter data in one sheet to
copy it to another sheet.

You also have to remember about deleting names and editing names for example
the person was entereed as a male but this should have been a female.

There are a number of ways around it you can user a form and write some code
or you can create a on_change event that will pick up the change.

But it really depends upon the value of the database.

One way to solve the copy problem is may be using auto filter?

 

[Guest]

Thank you, Martin! One of my ideas was to apply auto filter AFTER the data
had been automatically copied to a second sheet... I wonder if it's possible
to write data in the main sheet and it is copied automatically to a secondary
sheet. How would I do that? Best, Chris

 

[Guest]

I would personally use a userform to add data,
this then inserts the data into the last row of the table and then adds it
to the other rows where necessary.

Your form would have all the cells for entering data and pressing ok you
would copy it to the last row.

 

[wisccal]

You may also want to consider using pivot tables for each categorized
sheet.

Regards,
Steve

 

[Guest]

Thank you Martin and Steve, I am going to explore both of your suggestions.
I'll have to learn about pivot tables. Have a great day! Chris