macro
 

I have this type of excel report structure.
I want create a simple chart for John,Smith 8164. I have to do this daily
and I wanted to automize this process. I have about 20 employee names and
cells position may change from one report to another. What kind of loop/or
function/code can help me to proceed?
John,Smith 8164 4/4/2005 09:02:57AM
06:05:20PM

4/5/2005 09:07:19AM

4/6/2005 09:33:23AM

4/7/2005 09:03:22AM

4/8/2005 09:04:31AM
05:00:24PM