dariuzthepole
Board Regular
- Joined
- Jul 23, 2008
- Messages
- 111
Hi,
I'm looking to reference the same cell in multiple other workbooks and I'm trying to add in a variable with the user's name, to make it more resilient.
What I have is this:
='C:\Documents and Settings\john.smith\Desktop\[2013 John Smith.xlsm]Sheet1'!$A$2
'John Smith' is entered in A1 also, so I'm looking to replace 'John Smith.xlsm' with something like '\[2013 &A1&.xlsm]...'
I just cannot seem to get the syntax correct! I'm sure it is easy enough. I'm using WinXP and Excel 2010.
Any help you could provide would be greatly appreciated!
I'm looking to reference the same cell in multiple other workbooks and I'm trying to add in a variable with the user's name, to make it more resilient.
What I have is this:
='C:\Documents and Settings\john.smith\Desktop\[2013 John Smith.xlsm]Sheet1'!$A$2
'John Smith' is entered in A1 also, so I'm looking to replace 'John Smith.xlsm' with something like '\[2013 &A1&.xlsm]...'
I just cannot seem to get the syntax correct! I'm sure it is easy enough. I'm using WinXP and Excel 2010.
Any help you could provide would be greatly appreciated!