scrap

  1. J

    Scrap Produt IDs SKUs from category Page Power BI

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

    Pivot Table Help

    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...
  3. M

    Vlookup

    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...
  4. M

    VLOOKUP Help

    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...
  5. M

    VLOOKUP and IF Statement

    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...
  6. A

    Break one column into multiple, based on information from another column.

    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...
  7. C

    Scrap data from Yahoo Finance

    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 =...
  8. T

    Need Macro to extract Amazon data and Photos, Thanks!

    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...
  9. J

    How to import owners info from pinellas county property appraiser to excel.

    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...
  10. D

    Scrape Data from Website

    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...
  11. V

    VBA selecting radio button and search text and getting data

    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 '...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top