brianaclark1967
Member
Morning guys,
I have a master spreadsheet. It pulls information from numbered delivery sheets once they are created.
Is there a formula that I can use to link to a cell in a numbered sheet that has yet to be created?
='Lathams Documents:Delivery Notes:[DELIVERY REF 12358.xls]Del & Col Note'!$S$1
That is an example of the link, but when number 12358 isn't created yet, I just get the #REF
I look forward to your answer
Regards
Brian
I have a master spreadsheet. It pulls information from numbered delivery sheets once they are created.
Is there a formula that I can use to link to a cell in a numbered sheet that has yet to be created?
='Lathams Documents:Delivery Notes:[DELIVERY REF 12358.xls]Del & Col Note'!$S$1
That is an example of the link, but when number 12358 isn't created yet, I just get the #REF
I look forward to your answer
Regards
Brian