Hi, I am using Importxml to import the data from the the urls in column C and Xpath from Column D2, the following script works great though it have fixed value of row 3-6 which I have to change every time new urls are added. I want this value to be based on the urls present in column C. I've tried to use getLastrow function but somehow I can't make it work. Any help would be appreciated 

Please Login or Register  to view this content.