Hi,
My name is Parrish. My experience is limited so please excuse incorrect wording. I have 2 workbooks. One is an inventory list and feeds to a separate workbook using the Offset function. TPI.xlsx is my workbook and Carrollton Office is one of a few worksheets I am referencing. The formula is in each cell with the exception of changing the "Carrollton Office" to whatever tab I am wanting to reference and so on. It works Flawless! But now I am saving these files on a shared server to be accessed in the office. I need to reference the directory path within the formula. I just don't know exactly where/how it goes. The formula is below.
=OFFSET(INDIRECT("'[TPI.xlsx]Carrollton Office'!$A$1"),ROWS($A$1:A1)-1,COLUMNS($A$1:A1)-1)
The directory path is...
M:\Equipment & Vehicle Inventory
Please help..
Parrish
My name is Parrish. My experience is limited so please excuse incorrect wording. I have 2 workbooks. One is an inventory list and feeds to a separate workbook using the Offset function. TPI.xlsx is my workbook and Carrollton Office is one of a few worksheets I am referencing. The formula is in each cell with the exception of changing the "Carrollton Office" to whatever tab I am wanting to reference and so on. It works Flawless! But now I am saving these files on a shared server to be accessed in the office. I need to reference the directory path within the formula. I just don't know exactly where/how it goes. The formula is below.
=OFFSET(INDIRECT("'[TPI.xlsx]Carrollton Office'!$A$1"),ROWS($A$1:A1)-1,COLUMNS($A$1:A1)-1)
The directory path is...
M:\Equipment & Vehicle Inventory
Please help..
Parrish