Hi All
A bit of a confusing one......

I have a workbook ("Costing") that can be saved in multiple locations and is used in conjunction with another sheet "FINxxxx concession form" where xxxx = user input into costing - cell K2 and is also the name of the file and saved in multiple locations along with the costing sheet. I have developed a hyperlink within the Costing that will dynamically allow the user to click through and open FINxxxx concession form.

=HYPERLINK(LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-12)&"Concessions\"&"FIN"&K2&" Concession Form.xlsm","Link to Concession")

What I need is a way to pull a value from the FINxxxx concession form (cell P4) into the Costing sheet without opening the concession form.

Can anyone help?

Many thanks in advance for any help.

Mario