Hello there, first time posting and I'd really appreciate your help.
My problem:
My colleagues and I receive logsheets daily and we all use the same spreadsheet to input this data. The day and chronological order the sheets turn up at can vary so I have created a tab (i.e. OCT 2010) Where next to the 120 vehicles I have the following 3 coloumns:
I then have this group of three coloumns repeated 10 times across because the logsheets can turn up in drips and drabs and not in any particular date order. i.e 23rd - 27th October, then next week 4th -5th October. All the mileage is then added up at the end.FIRST BATCH ENTRY OF THE MONTH
First Date of Log Sheets / Last Date of Log Sheets / Miles Driven in this range
Therefore I need some sort of alert for when we haven't received a certain range. At the moment I have a manually made calendar in the next tab that I manually highlight myself as the logsheets come in. Can I get conditional formatting to do this or is another method advisable?
Many Thanks and apologies for the bulk of text! (using Excel 2000)
Bookmarks