Variable in text field

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I have a spreadsheet where I place some information at the
top in a cell like 'See Row 16 for more detail'.
When I insert a row before row 16 it is now farther down
in the spreadsheet and I need to correct the text
information. Is there a way to reference the row such that
it will update the text to reference the correct row
automatically? Thanks. Michael
 
="See row " & ROW(A16) & " for more detail"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Typed text appears in wrong cell 0
Help with merged cells 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Setting rows to autofit wrapping text in a cell 1
Auto Row Height with Wrapped Text in Merged Cells Problem 3
Duplicating Cell to another cell if it contains data 4
text is getting cut off when printed due to row ht. 1
Countif wrong in last row or two 3

Back
Top