sorry, what i meant is that you can tell excel to hold a cell for a formula e.g. d$5$ - is it possible to tell excel that you want the next cell down!
Thanks for your help!!
I am trying to link a mastersheet to 20 worksheets within the workbook; the mastersheet will feed the worksheets. I know this can be done manually by typing = in the cell in the worksheet and linking it to the mastersheet. However, I want excel to do this automatically. The data in the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.