Do you know a way to get rid of absolutes when linking?
B Bernard Liengme Feb 13, 2004 #2 If I type =; open other Sheet (or workbook) and click on a cell (say C4) I get something like =Sheet1!$C$4 in the formula bar. If I tap F4 the right number of times this becomes =Sheet1!C4 (not absolute) Best wishes
If I type =; open other Sheet (or workbook) and click on a cell (say C4) I get something like =Sheet1!$C$4 in the formula bar. If I tap F4 the right number of times this becomes =Sheet1!C4 (not absolute) Best wishes
