Forum Discussion

ksmith's avatar
ksmith
Brass Contributor
Jun 14, 2020
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...
Formulas and Functions
  • wumolad's avatar
    wumolad
    Jun 24, 2020
    ksmith

    Good to hear the comment was helpful.

    Please mark as the solution to close the discussion.

    Cheers,
ksmith's avatar
ksmith
Brass Contributor
Jun 23, 2020

wumolad

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.  

wumolad's avatar
wumolad
Iron Contributor
Jun 24, 2020

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

 

 

Resources