I have two sheets for a fantasy golf contest, a money sheet and a scoring sheet. One column from the money sheet references a cell from the scoring sheet, (='Score Sheet'!G3).
When I run a macro to sort the scoring sheet, I want the column from the money sheet to follow the sort. The cell remains (='Score Sheet'!G3) after the sort when I'd like it to be K3 or wherever the sort takes it.
Attached is my scoring sheet. If I sort by session 2 row (largest to smallest) then McBoing would be first, RatFarts second etc, but the formula from the other page does not follow the sort
Any ideas?? Thanks in advance
When I run a macro to sort the scoring sheet, I want the column from the money sheet to follow the sort. The cell remains (='Score Sheet'!G3) after the sort when I'd like it to be K3 or wherever the sort takes it.
Attached is my scoring sheet. If I sort by session 2 row (largest to smallest) then McBoing would be first, RatFarts second etc, but the formula from the other page does not follow the sort
Any ideas?? Thanks in advance