Currently, I have a list of urls. I scrape the content in the urls and append range to an excel sheet. This way, each content paragraph (from same article) is in its own excel cell. So, there may be 6 paragraphs in the article which would mean that there are 6 excel cells with content. I am doing this approach for 20+ articles from the same site.
My issue…I’m trying to label each content cell (in Col A) with the corresponding date, title, and url of the article (Columns B,C,&D). Unfortunately, my for loop I cannot get to work to label each paragraph properly (after hours of trying many approaches and reading many articles). I either write a unending loop of the article-title or get nothing at all. What am I doing wrong?
Thank you soooo much