• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Offset and Indirect function with full directory path to file

pgarakani

New Member
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
 
Back
Top