formula trouble, dependent cell
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. |
formula trouble, dependent cell
=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 -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "IrishGiant" wrote in message ... 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. |
All times are GMT +1. The time now is 12:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com