Hi. I am using Excel 2010.
I have a workbook with a web query.
Is it possible to autocopy the first cell that has more than 30 characters to a different sheet?
It would help me a lot, because I then could see if there were any changes from the Website.
Example:
"Sheet1"
Range F1:F238.
F1:F20 String < 30 characters. Don't autocopy
F21: => 30 characters. Then copy to "sheet2" A1
Thanks in advance.
Best regards from Norway
I have a workbook with a web query.
Is it possible to autocopy the first cell that has more than 30 characters to a different sheet?
It would help me a lot, because I then could see if there were any changes from the Website.
Example:
"Sheet1"
Range F1:F238.
F1:F20 String < 30 characters. Don't autocopy
F21: => 30 characters. Then copy to "sheet2" A1
Thanks in advance.
Best regards from Norway