I need to copy the data only in cells from one worksheet to cells in a second worksheet.
The formula “=$ScoreSheet.A6” worked for the first instance, but “=$ScoreSheet.U7” did not for the second instance (it just resulted in “=$ScoreSheet.U7” being displayed in the cell). The only difference I can see is that the data in cell A6 is hard and the data in U7 is from a formula. How can I retrieve the data only from U7?
It’s a strange situation, to solve it, copy the formula that is correct and paste it where it is in text, and set it to U7.
Thanks for the quick response. The formula for that cell in worksheet “ScoreSheet” references cells and data that are not present in the worksheet (“Results”) to which I am trying to copy the data.
Again, thank you very much for your response. I found my problem - there was a barely visible single quote at the beginning of “=$ScoreSheet.A6”. My apologies for wasting your time, and again, a big thank you for the work you do. I will try to make sure a silly error on my part does not prompt me to ask for help here again.