milesy1000
New Member
- Joined
- Oct 13, 2010
- Messages
- 1
Hello there,
I will start by saying my knowledge of excel is relatively basic unfortunately.
My problem:
My colleagues and I receive vehicle logsheets both daily and in different offices and we all use the same spreadsheet to input this data. Because the drivers are a bit slack and the office the sheets turn up at can vary, I have created a tab (i.e. OCT 2010) Where next to the 120 vehicles I have the following 3 coloumns:
First Date of Log Sheets / Last Date of Log Sheets / Miles Driven
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. This is because the logsheets need to be inputted immediately when received.
What I need though is a way based on these date range entries to somehow highlight an October Calendar on the next tab so I can see what particular days we have unreceived logsheets for and which need chasing up. I'm currently doing this manually by just hlighlighting as I enter but my colleagues need an automated method.
So in summary I need cells in a separate tab to be either marked or highlighted in color based on date ranges in the previous tab.
Is this possible?
Many Thanks and apologies for the bulk of text! (using Excel 2000)
I will start by saying my knowledge of excel is relatively basic unfortunately.
My problem:
My colleagues and I receive vehicle logsheets both daily and in different offices and we all use the same spreadsheet to input this data. Because the drivers are a bit slack and the office the sheets turn up at can vary, I have created a tab (i.e. OCT 2010) Where next to the 120 vehicles I have the following 3 coloumns:
First Date of Log Sheets / Last Date of Log Sheets / Miles Driven
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. This is because the logsheets need to be inputted immediately when received.
What I need though is a way based on these date range entries to somehow highlight an October Calendar on the next tab so I can see what particular days we have unreceived logsheets for and which need chasing up. I'm currently doing this manually by just hlighlighting as I enter but my colleagues need an automated method.
So in summary I need cells in a separate tab to be either marked or highlighted in color based on date ranges in the previous tab.
Is this possible?
Many Thanks and apologies for the bulk of text! (using Excel 2000)
