scrap

below details are given on Source Code page. How can i scrap these SKUs for all pages in that particular category...

Hey Guys, I have a data that currently looks something like this... <tbody> WO Nbr Part Nbr SCP Orig WO Qty Qty Scrap 10044 31593 PDB 408 22 10044 31593 HMI 408 11 </tbody> Obviously there are a ton more row, scrap codes, etc. But how would I go about setting up a pivot...

Need help with a formula for v lookup... Original Data kind of looks like this.. Work order Part Number Scrap Code Amount Scrap 29135 49055 CDX 15 29135 49055 FTX...

Hey Guys, I'm having an issue with a formula. I have 4 main fields.. Part number, work order number, scrap code, and scrap. I have a separate sheet setup with part number and work order in the rows and scrap codes going across. I have already setup a vlookup to look up how many pieces of...

I get a data dump from my ERP system that is not customizable so it's really all I have to work with. I'm a bit unfamiliar with IF statements and i'm assuming that's what I will need. My data dump includes titles Work order, part number, scrap code, and quantity scrapped. Each like has all...

Hello, I am attempting to create a break out crafting/costing system for an online game. The game market system is all posted on an online website so I have been using Excel Power Query to gather the information into a list. The issue I have run into is that the information I've gather has been...

Hi Team, i am trying to scrap finance data (Stock Price)using excel VBA, i have written below code but unable to scrap the data. !!! need urgent help !!! Sub macro1() Dim ie As Object Set rgn = Range("A3:A5") Set Row = Range(rgn.Offset(1, 0), rgn.Offset(1, 0).End(xlDown)) Set ie =...

Hello everyone, I have an Amazon store with 2000+ products but I need a Macro to extract data from Amazon URLs of my products, particularly the "Product Bullet Points/Features" section and "Product Description" section. Then the next I need is to download the 1000x1000 pixel or greater full...

I have 2612 addresses and need to import the owners address into the excel file.Trying to do it one by one is hard.Please help if you can.Here is the website to find the info and the example of the addresses i am using. Pinellas County Property Appraiser a few addresses and the columns they...

Hi, I am a farmer and I am looking to scrape the market data from this website, Farms.com. I am having some issues, this is what I have been trying, perhaps there is an easier way or different approach. Thanks Sub ab_milk() Application.ScreenUpdating = False Dim dataStartCell As Range...

Hi All, Thanks in advance for reading and giving your time. I am trying to access this page and automate search of lot#: "https://www.smarteda.qld.gov.au/pools/properties/propertySearch.action" I am using MSXML to do this: Sub Getlot() Dim xml As Object ' MSXML2.XMLHTTP Dim html As Object '...