I am using this function, with B2 containig sheet name, C21 is the cell i am refering to with sheet name in B2.
=INDIRECT("'"&$B$2&"'!C21")
works fine!
But: i want to copy down / copy right this with a chaning C21 (C22, C23, ...; D21, E21, ... respective)
Since C21 is indicated as string, the formula is keeping C21; i tried =INDIRECT("'"&$B$2&"'!"&C21), but C21 is meant to be on the current page now (i get the colored box around a cell), the formular itself does not work anymore and has invalid reference.
I was playing around with function CONCATENATE, couldn't get it work.
anyone has an idea?
=INDIRECT("'"&$B$2&"'!C21")
works fine!
But: i want to copy down / copy right this with a chaning C21 (C22, C23, ...; D21, E21, ... respective)
Since C21 is indicated as string, the formula is keeping C21; i tried =INDIRECT("'"&$B$2&"'!"&C21), but C21 is meant to be on the current page now (i get the colored box around a cell), the formular itself does not work anymore and has invalid reference.
I was playing around with function CONCATENATE, couldn't get it work.
anyone has an idea?
