close

Hi,

I have a nice book set up with web querys and it's doing a fantastic job for
me, except for one little problem:

The data does not always get imported to exact same place in the sheet, I'll
clarify.

The first column is supposed to contain a name, while the next 10 columns is
supposed to contain data after running a web update. That's the ideal
situation every time, and i'm updating once a day.

Now the problem is that somedays the data is imported in a different way.
For instance the name which is supposed to end up in the A column gets split
up so it now takes up the two first columns instead of just the first (A) and
this relays to all the other data which now ends up in the wrong column. I
don't know if this problem derives from the source, changing it's tables or
something else. Sometimes this issue won't arise for weeks then one day it's
there again and ruins my day...

Any help would be very appreciated.

Regards
Mitch

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()