WednesdayC
Board Regular
- Joined
- Nov 7, 2010
- Messages
- 201
- Office Version
- 2016
- Platform
- MacOS
Hi Team
Please can someone help me as I have trying for ages to sort this out.
I am trying to reference other worksheets
The simple formula I have is:-
=INDIRECT(L2&"!A1")
However, I want to replace the hard coded 2 from L2 to the columns function i.e. in this case Columns($A:B) as I have a list of worksheets I am trying to reference (in column L). I can't find a way to do this.
Any help would be much appreciated.
Regards
Wednesday
Please can someone help me as I have trying for ages to sort this out.
I am trying to reference other worksheets
The simple formula I have is:-
=INDIRECT(L2&"!A1")
However, I want to replace the hard coded 2 from L2 to the columns function i.e. in this case Columns($A:B) as I have a list of worksheets I am trying to reference (in column L). I can't find a way to do this.
Any help would be much appreciated.
Regards
Wednesday