Excel link

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:32 PM GMT

Question

i have anfile that computes the daily due for my clients and there were formulas that computes the due. I need to sort the names into alphabetical order without affecting their links were they are supposed to be linked ..hope you can help me ..

anne

Answer

What you need to do is add an absolute reference. This allows you to move the sorted cells to any location and the reference cells will track to actual data, not location (which may change) within document.

Before sorting put $ before cell info. =A5 will become =$A$5. For a full description of this function and how it works please type the phrase "absolute reference" in the help area of Excel. It will be a help drop down or a blue circle with a question mark depending on version.

Be sure to save a copy before making changes. Change the formula before sorting.

If you require additional instruction, feel free to use the follow up feature.

Microsoft|| 2010 ||||||||||

Advertisement

©2021 eLuminary LLC. All rights reserved.