Hi,
I've got a spreadsheet that is built on external users filling in manifests for vessels and storing them in a day-of-month folder (so one day can have say 13 files, depending on how many ships sail). If a vessel doesn't sail, then a file is not saved, but in my spreadsheet it lists and links to the file as if it was there (my file has one tab per vessel which has data brought in from the vessel file - if it exists). When opening up the file I get presented with "there are a number of sources that have not been found" (for the vessels that have not been manifested), but what I want to do is to avoid that and have some code that looks to see if that vessel file exists, and if it does not, then return an error or blank. At the moment all of the 'last available version' of the vessel file is being used which distorts the figures.
Can anyone help?
Thanks!
Bookmarks