Hi
I've got Sheet1 with date imported from CSV between A1:Y2000.
I can refresh manually or by a sub, HOWEVER, I would like to refresh the data based on a condition or a function (UDF) located on Sheet2.
For instance:
On Sheet2 , in Cell A1 there's a random value. (It's not really random, but just for the illustration of the example it is).
I would like B1 to has a condition or a function that check if the A1 is greater than 100, then refresh the data in Sheet1.
Any solution for this?
Thank you
I've got Sheet1 with date imported from CSV between A1:Y2000.
I can refresh manually or by a sub, HOWEVER, I would like to refresh the data based on a condition or a function (UDF) located on Sheet2.
For instance:
On Sheet2 , in Cell A1 there's a random value. (It's not really random, but just for the illustration of the example it is).
I would like B1 to has a condition or a function that check if the A1 is greater than 100, then refresh the data in Sheet1.
Any solution for this?
Thank you