In cell A4 I have name of sheet (e.g. Sheet1) w/ data values in cells B10:K10 that I would like to copy into cells C4:L4 of current sheet.
I'd like to use
arrayformula function, however, I am having trouble getting function to recognize a valid 'sheet name'.
In cell C4, tried using
I've also tried using 'indirect' function which works fine by itself (e.g.
=indirect(C4&"!B$10")) for a single cell copy.
How can I merge both indirect and arrayformula together to get bulk 'live' copy to take effect?