Hi,

I'm trying to set up a spreadsheet of contacts' information with name, country, e-mail address columns and then have the data linked and sorted alphanumerically, by different parameters, on separate work sheet pages. ie Sheet 1 would display the contacts alphabetically by name; Sheet 2 would display the contacts alphabetically by country etc. The tricky bit is that I would like the data linked on each sheet, so that if I change or add data in any cell it would be reflected on all the sheets. Ideally, I would like the data on all the sheets to re-sort automatically, if necessary, with any change.

I thought that this would be a fairly common requirement but I cannot find instructions anywhere. Can anyone please help?

Thanks.

Mike