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

macro
 

The answer will depend on what you want your chart to show, so hard to answer
without more detail. First, what kind of chart (collumn, line, scatter,
pie...); then what will the series be (what values do you want to show?).
Finally, in what way will the position of the cells change. Are they always
in the same column, but may have different numbers of rows? Would need to
know.

"agenda9533" wrote:

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

macro
 

Hi,
What was said in the previous response is true. Maybe you can give us an
example of your current out put from the data you have presented, which you
do "manually."

Thanks,

"agenda9533" wrote:

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