Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |