Vlookup change column looking at

[paulnray]

HI,

I have had a look round the site and couldnt see an answer on this what is probably a simple question.

I have a table of data lets say 5 columns by 5 rows as a named range called data.

I want to create a chart where the values loop through each column with a pause of lets say 5 seconds after the data changes

so in basic terms it does this

vlookup(j2,data,2,false)
pause 5 seconds
vlookup(j2,data,2,false)
pause
etc.

Can this be done, if anyone can give me a starting point would be really appreciated.

Cheers

Paul R

 

[Repush]

do you mean
vlookup(j2,data,2,false)
pause
vlookup(j2,data,3,false)
pause
. . .
that can be done by referencing the colNo, lets say this is in K3: vlookup(j2,data,K3,false)
then make a loop that changes the value of k3