Auto update helper column
 

Hello,

I set up a pivot table based on data in a web query. I added a few helper
columns to the right of the web query data that apply formulas to data from
the web query and place the results in the helper column, which is then also
used in my pivot table. Is it possible to have the information in these
helper columns update automatically when the web query updates? Currently I
need to reapply the formulas in the column by dragging the forumla from the
first cell in the column down to the bottom of the web query range.

Thanks,

Tom

Auto update helper column
 

Hi Tom:
Can you send me the excel scenario to . I think I
know how you can do it, but I don't want to waist each other times. Take care.


"tommcbrny" wrote:

Hello,

I set up a pivot table based on data in a web query. I added a few helper
columns to the right of the web query data that apply formulas to data from
the web query and place the results in the helper column, which is then also
used in my pivot table. Is it possible to have the information in these
helper columns update automatically when the web query updates? Currently I
need to reapply the formulas in the column by dragging the forumla from the
first cell in the column down to the bottom of the web query range.

Thanks,

Tom