View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tiger1022 tiger1022 is offline
external usenet poster
 
Posts: 1
Default 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!!