Linking rows

[timohnani]

Hi,

I was wondering if somebody could help me.
I have an excel workbook full of members' data. In the columns I have
things like name, address, telephone, email etc
On each row I have a different member.

In addition to the main sheet I have added worksheets for each country.
So besides having the main sheet which has all the members, I also have
several sheets for each country represented containing only the members
that are from that country.

I was wondering whether I could somehow link the main sheet with the
worksheets for each country. The idea is that if I make changes in the
mainsheet they would automatically change in the country sheets too or
vice versa.

Is this possible?

Thanks

Timo

 

[Dave Peterson]

How about just refreshing those sheets when you're done with your data entry?
Not quite as automatic, but much easier to do.

I'd steal some code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

or maybe Ron de Bruin's easyfilter.
http://www.rondebruin.nl/easyfilter.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm