Sorting problems with hyper links

[born2dive00]

Ok so i am working on creating a data base, I have plugged in some 600+ hyper links to different sets of numbers. for example FEMA # 2047 has this hyper link attached. https://www.femaflavor.org/flavor-li...tract-aloe-spp,
while FEMA # 2088 has this hyper link attached https://www.femaflavor.org/flavor-li...archangelica-l.

When there were mutiple instances of for example 2047, I have 5 instances used, (my first attempt at solving this) i clicked and dragged the info down, (on my second attempt at solving this) I copied and pasted the cells in.

Now on the attached worksheet, all the numbers with the corrisponding hyperlinks in dark green are correct and matched up, HOWEVER when I attempt to sort it by any other column say the CAS column some of the hyper links get disconnected and do not matche the description.

If you sort the CAS column column D alphabetically and pay attention to cells G15 - G 17 you will see that it shows the aloe hyper link stays but the rest of the table has shifted. how do I fix this sorting issue??

This is only a small percentage of the data base, I estimate that there will be somewhere near 8000 hyperlinks to different sources once it is done IF i can get this to work correctly.

[Glenn Kennedy]

I'm not sure that I understand.

Sort by CAS. Row 2 = aloe capensis resin, CAS No and the rest is blank. But on the unsorted table down at row 700 and something, it was also capensis/CAS and the rest blank??

What am I missing?

[born2dive00]

Unsorted and with the hyper links in correct spots it should be (starting at column C row 15, 16, 17)
C D E F G H I J K
aloe perryi extract CAS: 90320-39-1 ALOE EXTRACT (ALOE SPP.) 2047 https://www.femaflavor.org/flavor-li...tract-aloe-spp EC: 291-065-6 flavor agents
aloe spicata extract CAS: 90320-40-4 ALOE EXTRACT (ALOE SPP.) 2047 https://www.femaflavor.org/flavor-li...tract-aloe-spp EC: 291-066-1 flavor agents
aquilaria agallocha stem extract CAS: 85507-69-3 ALOE EXTRACT (ALOE SPP.) 2047 https://www.femaflavor.org/flavor-li...tract-aloe-spp EC: 287-390-8 flavor agents


If you enable the Micros, and you sort Column D (Cas) alphabetically, and then look at G 15, G16, G17 you will see that the hyper links are not connected to the proper cells. It looks like this

C D E F G H I J K
CAS: 119-53-9 BENZOIN 2132 https://www.femaflavor.org/flavor-li...tract-aloe-spp
aronia melanocarpa skin extract CAS: 1197991-17-5 https://www.femaflavor.org/flavor-li...tract-aloe-spp EC: 310-127-6 flavor agents
cannola oil CAS: 120962-03-0 https://www.femaflavor.org/flavor-li...tract-aloe-spp edible fats and oils

Or please see attached photo.