I am working on a formular which pulls information from one workbook to another. How can I make the SHEETS to automatically change when the formular is dragged through the cells of workbook where the formula is set?
The formular is as stated below:
='[Yearlyexpenses.xls]Sheet1'!$B$4.
So, how can I make Sheet1 to autmatically change to subsequent Sheets?