There are 3 spreadsheets involved:
Reference Spreadsheet A contains the hyperlinks to the Source Spreadsheet. Source Spreadsheet is online (this is what needs to be scraped) contains data to be scraped and inserted into the Target Spreadsheet C.
Reference Spreadsheet contains a list of hyperlinks to other spreadsheets in column A. The process is:
1) Go to the first cell in column A of Reference sheet A that contains a hyperlink
2) Open the source spreadsheet B in the hyperlink (password required the first time)
3) Scrape data from 8 fields of the source spreadsheet B
4) Populate a new row of the target spreadsheet C with the data
5) Go to the next row of column A in the Reference Spreadsheet
6) Repeat steps 2 - 5
70 freelancers are bidding on average $127 for this job
Hi there, I can scrape spreadsheet data from .asp files and populate in new spreadsheet. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
Hello, This is doable to me using VBA / Macros. I can take the data's from the sites that has credentials. Please let me know how many links are there. Thank you, Karthik.