Hi,
i hope someone can help me. i need to create a formula that sits in a cell
and looks for data. ( obvioiusly ). however, the formula needs to be in place
even though the file from ehere the data comes from might not be there yet. (
i have to create a book that when a new file is created, the links are
already in place ). i think it could work with an IF type formula for ( if
B2="",""). here is my information.

Cell description:
A2 = Job no.
B2 = Client Name
D2 = Actual Spend on project
Register!D2 = Job Description
Register!H2 = Quoted Amount

my path is S:\Clients\ & Client Name & \ & Job Number & Job Description &
Job Number & " Quotes & Orders.xls
if H2 cell has no value then active cell shows no value.
( this cell will indicate the file created and filled in )

Can a formula be written to take the above details and create a path to a
proposed file?

Thanks in anticipation,

Nigel