formula trouble, dependent cell

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.
 
B

Bernard Liengme

=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
 

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

How do I make worksheet2 = to worksheet1? 2
SumIf with multiple Criteria 6
Index 4
Conditional Format with Name Range? 1
how to compare/sort values in two columns of two worksheets? 4
I need a Formula for a Database 3
Reference to another worksheet cell in a sumproduct formula 1
Skipping a cell and moving on to the next, with no blanks in betwe 8

Top