Automation and Macro or VBA help in xl

[Vapanda]

Here's my problem. I'm pulling data from a server daily, so the date o
the worksheet will change. Not only will the date change, but so wil
the number of rows, due to the data that is collected. I tried t
create a macro to automate the graphing of each worksheet, but th
problem that I have ran into is that the macro is programed with th
worksheet name and the range that the worksheet used. I need to b
able to use the same macro for differently named worksheets an
different ranges. Is there a better way of doing this? Or is there
better way to code the macro so it doesn't recognize the name of th
worksheet or the range? I am new to vba, so it's all greek to me.

Also is there a way where I can automate this process daily. TIA

 

[Frank Kabel]

Hi
create a dynamic chart (no macros required). See:
http://www.tushar-mehta.com/excel/software/autochart/index.html
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

 

[Vapanda]

Frank,

Thanks for your help, but I'm sorry I might have been vague with m
question.
1) I collect data everyday.

The data is not the same, which means I'll probably have to put in
different workbook, not add on to the current work book

The number of rows or columns.

2) The data that I collect I have to make a Line Graph

The is created the same way, but with different data set.

Thanks for the links though, I've tried it and it didn't work. An
other suggestions for this type of automation