I am trying to figure out how to link information from a master/summary workbook to several individual workbooks.
I have looked around the forum but couldn't find anything that totally answered my question.
Here is a brief summary:
I have a master workbook that has info on 100's of companies including name, address, phone, fax etc.
It is in a table with headers:
Example:
Firm Type Address City State Zip Sector
Company ABC, 123 A street, San Francisco, CA 94233, manufacturing
Company BBB, 525 B Street, Chicago, IL 50551, sales
Company CCC, 585 C Street, New York, NY 10551, sales
Company DDD, 645 D Street, Los Angeles. CA 90032, transport
Of course, the sheet is in rows and columns with each company its own row, and each heading its own column.
I also have a separate worksheet for each state with the exact same info as the master list, but only for firms in that state. I.E. Alabama Company List, Alaska Company List, Arkansas Company List etc.
The variable in the example above is the State. So how do I get the California Company List to autopopulate all the info from the master worksheet for any firms with CA as their State? I might also do the same thing for the Sector, but it seems the same principal would apply.
How do I create these state -by-state lists and have them update whenever I update the master list? I will be changing the master including adding new companies and deleting old ones.
So while only updating the master list, I would like the workbooks from each state to automatically fill in all the information for companies in that state.
Do I need to create a macro and run it each time? Or is there a way to format my state workbooks so that they will automatically reflect the data from the master each time it is edited or saved? I also want to keep the same formatting as the master list.
Any help would be greatly appreciated!
Thanks
Bookmarks