S
SamuelT
Hello again,
Thanks for the replies on the dates - it worked a treat.
Now for the complicated bit...
I have a load of weekly reports sent to me. They get stored on the Q:\
drive; this is on a network so I have to check at the end of the week
to see what reports have been sent (they pertain to the status of
various projects).
I have a list of around 25 projects, but do not always get 25 reports
(usually more like 8!).
What I'd like to do, is for Excel to check the Week End date on the
reports (all the old reports are stored in the same location), then if
they correspond to my master spreadsheet, I want to display the
information in the report in the master spreadsheet.
Once this is done, I'd like to list the projects which haven't been
sent a report at the bottom.
This might be horribly complicated, perhaps even impossible. Any tips
which might help me on my way would be greatly appreciated though!
TIA,
SamuelT
Thanks for the replies on the dates - it worked a treat.
Now for the complicated bit...
I have a load of weekly reports sent to me. They get stored on the Q:\
drive; this is on a network so I have to check at the end of the week
to see what reports have been sent (they pertain to the status of
various projects).
I have a list of around 25 projects, but do not always get 25 reports
(usually more like 8!).
What I'd like to do, is for Excel to check the Week End date on the
reports (all the old reports are stored in the same location), then if
they correspond to my master spreadsheet, I want to display the
information in the report in the master spreadsheet.
Once this is done, I'd like to list the projects which haven't been
sent a report at the bottom.
This might be horribly complicated, perhaps even impossible. Any tips
which might help me on my way would be greatly appreciated though!
TIA,
SamuelT