Forum Discussion
Cannot select content of some cells from one worksheet to another with = formula
When I have the problem worksheet visible, I can select the problem cell (C3) and type into. However, the problem is when I try to insert the equal = sign formula in an adjacent cell (KS Debits) then switch back to select the problem cell C3, I cannot select C3. I have to select an adjacent cell, then scroll up to C3.
I have attached a png file below.
Can you make a copy of the workbook and delete other information that are sensitive and send the sheets having the issue across, so we can go through.
Cheers
Can try. There are 113 worksheets; one for each month and the template which I copy. I can delete all months except for the last 2 , and include the template (that's where the problem might originate). will do soon. O.K...in attached worksheet, June, July and Aug work o.k. But if you try to use =G4 on template sheet, to O21 on August sheet, you cannot select O21.
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
- NOT 113...meant to say 13...THIRTEEN..... mY WHOOPS