Hi all,
I am trying to fill a series for an INDRECT formula that links to another worksheet.
For example I have 2 Worksheets: 'Overview' and 'Staff Member'.
The formula I'm using is: =INDIRECT("'"&$B$2&"'!a1") where B2 contains 'Staff Member' and a1 the information in the cell on the Staff Member worksheet.
This formula works fine.
What I am trying to do now is drag the cell to the right and down but a1 isn't changing to b1 and a2 respectively.
Ideally, I'd also like to be able to drag right and also skip to every 6th column also (a1 to f1), but I feel like I'm pushing my luck!
I've spent a few hours trying every combination I can think of, and online searching for a solution without any success.
Hopefully someone knows!
I am trying to fill a series for an INDRECT formula that links to another worksheet.
For example I have 2 Worksheets: 'Overview' and 'Staff Member'.
The formula I'm using is: =INDIRECT("'"&$B$2&"'!a1") where B2 contains 'Staff Member' and a1 the information in the cell on the Staff Member worksheet.
This formula works fine.
What I am trying to do now is drag the cell to the right and down but a1 isn't changing to b1 and a2 respectively.
Ideally, I'd also like to be able to drag right and also skip to every 6th column also (a1 to f1), but I feel like I'm pushing my luck!
I've spent a few hours trying every combination I can think of, and online searching for a solution without any success.
Hopefully someone knows!