Automation of change of data range
 

It is too tedious to have to go in and manually type in the new cell
references to update charts weekly. Is there a way to automate the process?
If I could simply reference the new dates or something with maybe a macro
would help. I am not conversant in Visual Basic, but an quite skilled in
Excel.

Thanks,

KIOhio

Automation of change of data range
 

Update, I neglected to mention Excel 2007.

"KIOhio" wrote:

It is too tedious to have to go in and manually type in the new cell
references to update charts weekly. Is there a way to automate the process?
If I could simply reference the new dates or something with maybe a macro
would help. I am not conversant in Visual Basic, but an quite skilled in
Excel.

Thanks,

KIOhio

Automation of change of data range
 

HELLO--Anybody--I still need help, please.

"KIOhio" wrote:

It is too tedious to have to go in and manually type in the new cell
references to update charts weekly. Is there a way to automate the process?
If I could simply reference the new dates or something with maybe a macro
would help. I am not conversant in Visual Basic, but an quite skilled in
Excel.

Thanks,

KIOhio

Automation of change of data range
 

Hi,

Have read up on dynamic named ranges.
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"KIOhio" wrote in message
...
HELLO--Anybody--I still need help, please.

"KIOhio" wrote:

It is too tedious to have to go in and manually type in the new cell
references to update charts weekly. Is there a way to automate the
process?
If I could simply reference the new dates or something with maybe a macro
would help. I am not conversant in Visual Basic, but an quite skilled in
Excel.

Thanks,

KIOhio

Automation of change of data range
 

Thanks so much. I am going to do some reading now. This looks like my answer.

Dan D. Brown

"Andy Pope" wrote:

Hi,

Have read up on dynamic named ranges.
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"KIOhio" wrote in message
...
HELLO--Anybody--I still need help, please.

"KIOhio" wrote:

It is too tedious to have to go in and manually type in the new cell
references to update charts weekly. Is there a way to automate the
process?
If I could simply reference the new dates or something with maybe a macro
would help. I am not conversant in Visual Basic, but an quite skilled in
Excel.

Thanks,

KIOhio