Trying to create a spreadsheet that reads values from a certain sheet of another file using
I am trying that the referenced external cell be a cell on the current one so I could try to do something like:
E2 local cell is the name of the remote sheet I want to import from.
This reply looked very promising using the
INDIRECT formula but so far I haven't managed to archive it within an
importrange not sure if due to a syntax error or a limitation of the