snowmansmartie
New Member
- Joined
- Jun 19, 2013
- Messages
- 14
Hi guys,
I have 2 workbooks.
WB1 is stored in a Sub-Folder with a Username and stores a list of figures
WB2 is stored in the Root Folder and pulls information from WB1. For each User there is a separate Tab. I know by using =REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),"") will give me the Sheet Name.
What I would like to do is where I have a link - ='c:\scores\username\[Ticket Audit Form.xlsx]Week 1 Audit'!$B$130 - Where the username is I want to pull this from the sheet tab as they will be the same.
I have already tried to concatenate the replace formula in, but this doesn't work. Any help would be appreciated.
Cheers
I have 2 workbooks.
WB1 is stored in a Sub-Folder with a Username and stores a list of figures
WB2 is stored in the Root Folder and pulls information from WB1. For each User there is a separate Tab. I know by using =REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),"") will give me the Sheet Name.
What I would like to do is where I have a link - ='c:\scores\username\[Ticket Audit Form.xlsx]Week 1 Audit'!$B$130 - Where the username is I want to pull this from the sheet tab as they will be the same.
I have already tried to concatenate the replace formula in, but this doesn't work. Any help would be appreciated.
Cheers