I am trying to connect one spread sheet to another in a Network drive using multiple cells to fill in the destination as shown in this image.
9efeb94a7fd32a072841221b93d98b15.png
I am getting a #REF error but seem to be able to use a simple formula to connect to the same sheet on the network.
I have opened both sheets and used this formula multiple times.
dbfb746a61b317918d91079c141100c8.png
Bookmarks