Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to generate a worksheet out of an Excel 2003 database?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to generate a worksheet out of an Excel 2003 database?
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? -- Hope this helps Martin Fishlock "Daptin" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to generate a worksheet out of an Excel 2003 database?
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 "Martin Fishlock" wrote: 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? -- Hope this helps Martin Fishlock "Daptin" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to generate a worksheet out of an Excel 2003 database?
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. -- Hope this helps Martin Fishlock "Daptin" wrote: 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 "Martin Fishlock" wrote: 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? -- Hope this helps Martin Fishlock "Daptin" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to generate a worksheet out of an Excel 2003 database?
You may also want to consider using pivot tables for each categorized
sheet. Regards, Steve Martin Fishlock schrieb: 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. -- Hope this helps Martin Fishlock "Daptin" wrote: 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 "Martin Fishlock" wrote: 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? -- Hope this helps Martin Fishlock "Daptin" wrote: 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to generate a worksheet out of an Excel 2003 database?
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 " wrote: You may also want to consider using pivot tables for each categorized sheet. Regards, Steve Martin Fishlock schrieb: 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. -- Hope this helps Martin Fishlock "Daptin" wrote: 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 "Martin Fishlock" wrote: 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? -- Hope this helps Martin Fishlock "Daptin" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Excel Worksheet Form / Database reporting | Excel Discussion (Misc queries) | |||
import .CSV file to XP EXcel 2003 worksheet, the seperator is com. | New Users to Excel |