Results 1 to 13 of 13

Assigning value for each scraped row based on another cell

Threaded View

  1. #1
    Forum Contributor Anka's Avatar
    Join Date
    08-25-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2016
    Posts
    174

    Assigning value for each scraped row based on another cell

    Hello everybody

    I have a macro that scrape (in Sheet2) some table from a list of url (from Sheet1).
    Now i need to modify this macro to assign a value in another column for each scraped row, based on cell value from Sheet1.
    Any ideas are welcome.
    Thanks in advance
    Attached Images Attached Images
    Many thanks to all who have helped me.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to Organize Scraped Data
    By anartey in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-20-2015, 02:13 AM
  2. Cleaning up Data Scraped From the Web by Deleting Certain Rows
    By torchD. in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2015, 10:52 AM
  3. assigning a value in a cell based on your selection from a drop down menu
    By tstephanic in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-25-2014, 03:30 PM
  4. assigning cell value based on a number range
    By dzedncnfused in forum Excel General
    Replies: 2
    Last Post: 09-11-2013, 07:07 PM
  5. question on assigning value to cell based on array
    By canadave in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-05-2011, 08:17 AM
  6. Replies: 2
    Last Post: 01-11-2011, 04:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1