C
cardan
Hello, I have an issue that should be easy to fix but I can't seem to
get the right syntax for the INDIRECT function.
I am trying to reference a cell in another worksheet. When I copy the
formula across, I would like it to still reference the sheet but also
reference the next cell over. The INDIRECT syntax I am using is..
....INDIRECT("'"&$B4&"'!E3")... Cell B4 contains the name of the
worksheet I am referencing. When I copy the formula over to the next
column it still references E3. I would like it to reference cell F3 of
the worksheet name in cell B4.
Any help would be greatly appreciated! Thank you in advance.
get the right syntax for the INDIRECT function.
I am trying to reference a cell in another worksheet. When I copy the
formula across, I would like it to still reference the sheet but also
reference the next cell over. The INDIRECT syntax I am using is..
....INDIRECT("'"&$B4&"'!E3")... Cell B4 contains the name of the
worksheet I am referencing. When I copy the formula over to the next
column it still references E3. I would like it to reference cell F3 of
the worksheet name in cell B4.
Any help would be greatly appreciated! Thank you in advance.