Greetings! This my first post; please let me know if I'm coloring within the lines.
Using Excel 2010 on Windows 7
I have created a table to document and track employee attendance: range B5:Z149 (including headers). Minus the header, each row is an employee with various pieces of relevant data for each employee in columns B thru L. The cells in columns M thru Z are blank, and provide a cell for each day of a two week work period. Each employee absence in documented with a 1-4 character text code in the applicable day-cell indicating the kind of absence - sick, vacation, excused, etc. At the end of the work period, the range M6:Z149 will be a checkerboard of blank cells and cells containing an absence text-code. I want to apply a filter that will display only rows that contain text in any of the cells in columns M thru Z for the row, thereby creating a report of all employee absences for all reasons for the work period. I have watched and read a number of tutorials on filtering, but am falling far short of figuring out how to do this. This is step one. Step two is to create a toggle macro for the filter and assign it to a form control so I can run it on command. I will leave that to post to the VBA forum should I have success here.
Any help is much appreciated.
dsb
Bookmarks