wbeck257
06-02-2010, 10:14 AM
Every day an XLS spreadsheet is generated and placed into a folder. This spreadsheet contains a list of anywhere from 50 to 100 different usernames in one column, and a few other columns with info I need. I am only responsabile for 7 of those usernames; and not every day will they appear on that list.
Each day the spreadsheet is named "Daily Log MMDD.xls" (MM = Month, DD = Day).
What I want to do is create a report to query the daily log and generate a list of the names I'm responsiable for, and a few other columns from the daily log. I'd like it to be as automated as possiable...
Any ideas?
Each day the spreadsheet is named "Daily Log MMDD.xls" (MM = Month, DD = Day).
What I want to do is create a report to query the daily log and generate a list of the names I'm responsiable for, and a few other columns from the daily log. I'd like it to be as automated as possiable...
Any ideas?