formula trouble, dependent cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have multiple worksheets and I want the first to have all of the first
cells of all the other worksheets, so I put in =worksheet2!A1 and so on for
every worksheet after 1 that I have. When I add a new row to worksheet2 it
changes the formula in worksheet1 to =worksheet2!B1. How do I stop this. I
want it to stay A1.
 
=INDIRECT("Sheet2!A1")
There are more ways of killing a pig than suffin' it wi' butter! (As my old
Irish Math teacher would say - daily!)
best wishes
 
Back
Top