Hi

I have a spreadsheet which has the following columns:

Street Name, Number, Area, Collection and Calendar No.

All values are text / numerical.

The column 'Calendar no' value depends on the street name, the values are 1, 2, 3, or 4 which are hyperlinked to a corresponding PDF.

To link them in the first place I sorted them by their values 1, 2, 3 and 4. I was then able to copy the hyperlinks across 1000+ rows which saved me time.

My problem is when I then sort Street Name by A-Z the hyperlinks appear incorrect – the value is correct, but the underlying hyperlink is wrong. Those with a value 2 don’t go to e.g. www.domain.com/2.pdf they may go to 1.pdf,2.pdf or 3.pdf

Excel is sorting all other columns as expected but the URLs remain mixed up. I am expanding the selection when sorting.
Please help!