I’ve got a neat idea to save quite a bit of work in a spreadsheet if I could only figure out how to do it. I don’t even know how to look it up in “Help”.
The problem: I have a command in a cell that brings in the value of another cell, in another spreadsheet. the command that does this is:
=’\NAME OF SPREADSHEET]AM900
I need to generate the cell designation dynamically by combining the AM (the column number) with the 900 (the row number).
This can be done as a text function easily, but I need to get the result incorporated into the command line as shown above so that the appropriate value will be pulled in from the second spreadsheet.
Any ideas?