Hi All,
Excel Spreadsheet Image attached (It won't let me upload the actual file for some reason)
EDIT: I've uploaded a different version of the Excel spreadsheet which is similar to the original.
Basically, what I need to do is create a new excel spreadsheet that will read and copy information from the attached spreadsheet onto the new one. In the attached sheet you will see a list for each day of the month (in the example I have only left Monday and Tuesday on there but Saturday and Sunday ARE included).
On each day of the month a series of registration numbers will be entered. The only information that I need to know is which vehicle registrations are being used on today's date. I don't know how to collect the information because of the format the sheet uses. I cannot make any changes to the sheet which I will be reading from because it is being used by another dept, so reformatting the original sheet to suit my needs is out of the question. I need to read the information into a new sheet in a clear and concise format which can be read by my BI software. It should simply show today's date being read from the attached sheet, and all vehicle registrations entered for said date.
On the next day, yesterdays information is irrelevant. I'd be happy if Excel overwrites yesterdays information with today's.
Is this possible to do?
Please let me know if anything doesn't make sense.
Thanks in advance.
Bookmarks