Can I do a cell link with an absolute?
How can I cell link but have the information stay in the exact cell I pull from when the data gets upadated? For ex
the bottom sheet is the information i want to pull from. Column RDC, row 1 is the value I want in that cell to return to the top sheet every time the bottom sheet gets updated no mater the information in that cell.
Help Article Resources
Check out the Formula Handbook template!