Updating Query

[harryhornet]

Hi All

I am wondering if you could help. I am running a number of queries on data that I receive on an annual basis however every year I receive the data, h columns re not one over, for example instead of using row S it will now use row T. Is there any way that I can update the queries with out having to update them all manually

Many Thank

 

[mole999]

what does the query look like ?

 

[harryhornet]

they're not actually queries just cell references. I am trying to replicate a complicated word report in excel I have linked to cell but I know when I next do it the cell will now be the next column along. I am using = I24 but the next year it will be J24. I will have about 200 in total

 

[mole999]

so you could change all your references to a single master in the code (near the top) then you only have to change the master once and everything else will then take that value, once you set it up right