Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate outputting filtered data from main worksheet to another s
Hello! There surely must be a way to do this - help please!
I have a 200-line worksheet that contains company names in column A. Subsequent (info only) columns a contact first name, last name, email addy, fax #, member #, website info. Then there are approx 52 additional columns representing various groups that these companies belong to (no companies belong to every goup and all companies belong to at least one group, but commonly belong to between 6-10 groups). These 52 addtional columns are either blank or contain an "x". I have the worksheet set to autofilter, so that I can then choose "non-blanks" under a column to view all the companies that belong to a certain group. The resulting information I use, for example, as a contact list for that specific group. Goal: To have additional worksheets, within this workbook, that automatically update the information based on any changes that are made in the main worksheet. The additional worksheets are driven from the 52 additional columns containing a blank or "x". Question is: Is it possible to have additional sheets within this workbook that automatically generate/update based on info I key into the main worksheet? How would I go about this? Thanks!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate outputting filtered data from main worksheet to another s
With code you can do this but it will not update automatic
http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "tiger1022" wrote in message ... Hello! There surely must be a way to do this - help please! I have a 200-line worksheet that contains company names in column A. Subsequent (info only) columns a contact first name, last name, email addy, fax #, member #, website info. Then there are approx 52 additional columns representing various groups that these companies belong to (no companies belong to every goup and all companies belong to at least one group, but commonly belong to between 6-10 groups). These 52 addtional columns are either blank or contain an "x". I have the worksheet set to autofilter, so that I can then choose "non-blanks" under a column to view all the companies that belong to a certain group. The resulting information I use, for example, as a contact list for that specific group. Goal: To have additional worksheets, within this workbook, that automatically update the information based on any changes that are made in the main worksheet. The additional worksheets are driven from the 52 additional columns containing a blank or "x". Question is: Is it possible to have additional sheets within this workbook that automatically generate/update based on info I key into the main worksheet? How would I go about this? Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question for T. Mama - Copying filtered data to another worksheet | Excel Worksheet Functions | |||
Copying filtered data to another worksheet | Excel Worksheet Functions | |||
adding several worksheet cells onto a main worksheet | Excel Worksheet Functions | |||
Deleting filtered out data from a worksheet | Excel Worksheet Functions | |||
How do I copy a filtered subset of data to another worksheet? | Excel Discussion (Misc queries) |