Forum Discussion
Solved
Cannot select content of some cells from one worksheet to another with = formula
I have a accounting workbook for our household expenses with a worksheet for each month. In the NEXT month, I use the = formula to select a cell from the previous month; i.e. In the opening debits c...
Hi ksmith
The issue was because of the comment on cell P21 that passed through the cell as highlighted below.
if you drag the comment away for example as shown below or hide the comment, you will be able to access the cell without any issue.
To hide the comment, select the comment and click on "review tab", then choose "show/hide comment"
I have attached the updated workbook for your perusal.
Cheers
