Brian, assuming there is no line breaks you can double click on the black square on the bottom right of the highlighted cell in B2 and it will correctly carry the formula down the entire row.
Brian, assuming there is no line breaks you can double click on the black square on the bottom right of the highlighted cell in B2 and it will correctly carry the formula down the entire row.
OK, so I tried adding some rows, using Gregg's idea of expanding the link to the entire column, (start with =HYPERLINK("http://www.google.com/search?hl=en&q=")&A2 and double click the black box. The links below (that change row numbers, automatically updated to the new cells, keeping their relative positions and working as I thought they should.
I think this will work, unless someone has an other idea?
Brian
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks