Hi, I've set up my Office 07 sheet to import data from various web html
tables. Upon clicking "Refresh all" my data is all updated correctly, but as
there are more rows fetched each time, I'm currently having to manually do a
new "fill down" to get my vlookup sheet to contain the last few rows. I then
have to manually update the range of each of my charts.

I hope and assume that there is a better way to do this :)

The exact situation is:
1) I import a bulk amount of weekly data into one sheet
2) A second sheet does a large amount of vlookup/index/match calculations to
format the data in such a way that I can make useful weekly charts out of it.
3) Charts are created from that formatted data.

I had kind of hoped that Excel would be intelligent enough to work all this
out for itself upon Refreshing the data, but I guess I'm going to have to
write some kind of VB or Macro? Can someone point me in the right direction
please?

thanks,

Alistair

Sounds as if you are looking for a dynamic names range. Check out the info at
http://www.contextures.com/xlNames01.html#Dynamic by Debra Dalgliesh..I was
working on pivot tables needing to update a constantly growing range. I am
quite sure I mangled her name, but the tips she presents were right on the
money for me several months ago.

hth

"Alistair H" wrote:

Hi, I've set up my Office 07 sheet to import data from various web html
tables. Upon clicking "Refresh all" my data is all updated correctly, but as
there are more rows fetched each time, I'm currently having to manually do a
new "fill down" to get my vlookup sheet to contain the last few rows. I then
have to manually update the range of each of my charts.

I hope and assume that there is a better way to do this :)

The exact situation is:
1) I import a bulk amount of weekly data into one sheet
2) A second sheet does a large amount of vlookup/index/match calculations to
format the data in such a way that I can make useful weekly charts out of it.
3) Charts are created from that formatted data.

I had kind of hoped that Excel would be intelligent enough to work all this
out for itself upon Refreshing the data, but I guess I'm going to have to
write some kind of VB or Macro? Can someone point me in the right direction
please?

thanks,

Alistair