•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Use a cross reference website to return results
Our take
Are you looking to enhance your Excel experience by creating a master data table that links part numbers with their equivalents? If you're using Excel in Office 2024 LTCS Pro Plus, you might be wondering if it's possible to scrape data from the web directly into your spreadsheet. Specifically, you want to explore how to extract information, such as transforming part number BF988 into its corresponding equivalent P553004. Let’s dive into this innovative approach and see how you can streamline your data management effectively!
Hi all, need a bit of help about whether this can even be done. (Im using Excel in Office 2024 LTCS Pro Plus)
Im trying to create a master data table for work, where part numbers for items we sell are displayed alongside their respective equivalents.
I currently have my spreadsheet set like this: https://imgur.com/a/NvI9IZO
Is there a way to have excel scrape the web using sites like this: https://imgur.com/a/5UharO4 and return its answer?
For example, I have a part number BF988. Excel then scrapes the allocated website and returns a result, like P553004.
Any help is greatly appreciated.
Thanks!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- join content from cells in a column without losing content from the corresponding columns.basically how do i make the highlighted screenshot look like the unhighlighted one but with a function for a spreadsheet with like 170k rows. sorry that this is in sheets. im trying to figure out if what i need is to buy excel basically what i want is to condense duplicative info while listing/joining the different pieces, all controlled for case number. https://preview.redd.it/4rfjrucnjdzg1.png?width=1408&format=png&auto=webp&s=ff424cf0a8553fe30b769986169901c1ca25a3bd https://preview.redd.it/c8mtq58ojdzg1.png?width=1080&format=png&auto=webp&s=21ccbdfd8ae8d41eb2d69368e62163df3737088b submitted by /u/Abi-Ankeney-PMM [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- New tables being created after filling previous onesHello, I am creating an Excel spreadsheet to calculate the cost of various parts. The exact number of parts is not known in advance and may vary; furthermore, these parts may be either purchased or manufactured. For this calculation, there are four specific tables—in addition to an initial table that names the part and specifies whether it was purchased or manufactured: Materials, Processes, Transport, and Fasteners. If a part is purchased, it utilizes only the Transport and Fasteners tables; if it is manufactured, it uses all four. Is there a way to have the entry rows for new parts be added automatically, and then—once the user selects whether the part was purchased or manufactured—have the necessary corresponding tables appear? I have looked online but I couldnt ffind anything. Many thanks for considering my request. submitted by /u/Traditional-Gas-1355 [link] [comments]
- Help locating specific data from rangeHello all, I was wondering if someone could assisst me. Im still learning excel and having some success, but currently im struggling with a problem. I have a bunch of data across multiple cells. Some columns would have time stamps, location, error codes, vehicle numbers etc. Lets say i have a bunch of data for all vehicles and errors. How would i go about automatically filtering through the data looking for, example, error code 515. Ideally have an entire sheet that shows all data but just for a specific error code. Or a name. I appreciate any help on the matter. Even if you point me in the direction of useful information, videos etc. Id be very grateful. Thank you submitted by /u/liveactiongeek [link] [comments]