donkeycrusher
New Member
- Joined
- Aug 13, 2004
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
I'm not sure what the proper nomenclature is for what i'm trying to do, but here's a description
In Cell B1 I want to paste the filepath to another workbook and worksheet (E.g. 'C:\Users\User1\Dropbox\Active\JACKSONVILLE\[Peachtree_Model.xlsm]Summary')
In Cell B2 I want a formula that combines the filepath in B1 and cell reference to that sheet (E.g. =$B$1&$B$3)
The cell populates with the the text 'C:\Users\User1\Dropbox\Active\JACKSONVILLE\[Peachtree_Model.xlsm]Summary'$B$3 instead of making a formula and referencing the information in that cell, which is "Fernandina Beach, FL"
In Cell B1 I want to paste the filepath to another workbook and worksheet (E.g. 'C:\Users\User1\Dropbox\Active\JACKSONVILLE\[Peachtree_Model.xlsm]Summary')
In Cell B2 I want a formula that combines the filepath in B1 and cell reference to that sheet (E.g. =$B$1&$B$3)
The cell populates with the the text 'C:\Users\User1\Dropbox\Active\JACKSONVILLE\[Peachtree_Model.xlsm]Summary'$B$3 instead of making a formula and referencing the information in that cell, which is "Fernandina Beach, FL"