I need to link 2 cells, one will have text, the other numbers.
They are an index and part of a cross referencing system.
For example it will say
Chapter 12 Lemons... next to that will be 8.4 lemon curd, 5.2 lemon meringue pie, 22.1 lemonade.
How do I link the number and text so they move together? Otherwise the cross referencing will go to pot because there are 1000's of these.
It's a manual (not about lemons though) and the references are the other sections that the person should look at.
If you can help, I'd be grateful.