J
JDB
I use the Indirect function to summarize data from various worksheets;
If I have a worksheet named "Lucky", I can easily use the indirect
function. My problem is that I will receive a workbook with a varying
number of worksheets that are named as shipping container numbers.
Each of these are unique and there is no order to them.
I would like to be able to use the indirect function by using the sheet
number instead of the sheet name but have had no success in doing so.
So the question is; "How can I use the sheet number in the Indirect
function to retrieve a value?"
Thanks
JDB
If I have a worksheet named "Lucky", I can easily use the indirect
function. My problem is that I will receive a workbook with a varying
number of worksheets that are named as shipping container numbers.
Each of these are unique and there is no order to them.
I would like to be able to use the indirect function by using the sheet
number instead of the sheet name but have had no success in doing so.
So the question is; "How can I use the sheet number in the Indirect
function to retrieve a value?"
Thanks
JDB