extraction

0 I'm looking to carry out a task in VBA of searching a number of websites for a specified phrase. I've got a spreadsheet with a dynamic data which changes accordingly creating a link in column F. I am looking for a macro to open each individual link, search website content for a specifif phrase...

During the course of extracting the date and time data from this Excel sheet into a word document it adds a tab character between 2020, the @ and the time, in this case, 11:40. So I first tried using the concatenate but it inserts numbers instead of date and time formats. Changing the format of...

Hello - I would like to find a way to (i) extract a certain number of words, that surround a keyword/s (and include the keyword in the extraction, and (ii) have the keyword/s colored in the extraction. I have ~90,000 biographies that I am looking to "classify", based on keywords. With that...

I have data which I need to sort based on certain criteria. Here are a few examples of the data. 1TT66 32144 24TTT 5T153 36335 TTTTT 44T23 So the data may contain no 'T's' or a number of 'T's'. These occur randomly in the data. I need to identify only the following: Those that contain only 1 'T'...

How can I ensure the extraction of data from a webpage has finished before proceeding to the next sub?

<colgroup><col style="mso-width-source:userset;mso-width-alt:8338;width:171pt" width="228"> </colgroup><tbody> Dark Aero Form: 31 Alien Loren Form: TTTTT Cairns Lulu Form: T3166 Shellam Larry Form: 415 Madabout Molly Form: 55161 Cashen Flo...

Hi all, I have 2 worksheets: Extraction and Dataset. On the extraction sheet (where I want the data to be presented), if cell A1= "7500-2018", I want to extract from the dataset worksheet anything with 7500-2018 in column A. Within Dataset, I would want columns A to L copied across, if...

I am currently working on a project in which over the past couple weeks I have not been able to remedy. I would like to extract data from COL B to another row based on multiple search criteria including date ranges e.g. 01/01/16 - 09/29/17 in COL A , Name COL C, the current COL D (which will...

Good morning everyone, I have these extraction on a sheet, let's call it "main" sheet. I have formulas on P5:Q1000 that depend on the extraction and change constantly every time the extraction is refreshed. So I am trying to find a way (through a macro push button) to copy past the new refreshed...

Hi everyone, very new VBA user here. I'm trying to copy and paste information from multiple pages. So I'm looking at a site on pension schemes. There are 150 pages of schemes, with 20 or so schemes on each page. To get information from each one, you need to click the name of the scheme and...

Dear All, I need to extract a number from a cell containing : "Glass unit formula4-12-4-12-4И. R-value - 0,81 m² • С/W" or similar case. I have a problem with defining in a correct way the left, mid, find etc. Can you help?

I have a spreadsheet that contains a list of work site numbers, and I want to extract the beginning and end of a range of sites for sets of 16, 24, 32, 35, and 61. Also, I have a column with numbers of boxes for each site and I need to count the number of boxes <=48 and return the beginning and...

Hi MrExcel Community, See below for a sample of data that I need to extract information into a searchable database. All of the information is provided in both columns and rows. I'd like to create TABLE 1 into TABLE 2. What's most frustrating is identifying project type by finding the YES and...

Hi I want a formula or a VBA Macro for extracting a series of hyperlinks target files and putting it into user-defined folder. Will you please help me? I know how to extract a hyperlink address and put it into a cell but I can find it enough for this purpose. Regards

I have a report that I have to download from one application and then paste that info in to excel. When I copy it into to excel, the entire report is in one column (about 800 rows). What I have been doing is using the left, right and mid formulas but I know there has to be a better way (one...

Hi there, So I have a column full of IMAGE data e.g. =IMAGE("http://pbs.twimg.com/profile_images/479251403328585728/0uLakxHx_normal.png",1) Now I am trying to load this into Tableau but it does not recognize the data and NULLs it. I need to extract the url from this column. Is there a...

Hey everyone! I was doing some googling for help with some data extraction and found a code that was actually provided on this forum some years ago and I tweaked it to fit my exact situation. So the code below takes a column (and some other stuff) from multiple workbooks in the same folder and...

I am wanting to extract word archives from 1999 to 2015 the following into Excel for the purpose of create Access databases of 1000s of pieces of information. 1. Subject: Ad Removal November 20 <database of subjects 2. From: John Smith, Project Engineer <database of senders 3a.Personnel: Ron...

I am working on a grad school project analyzing the average prices for used luxury cars in Houston. So far, I have been able to develop the following macro. I am trying to extract price, make, model, year and miles. Private Sub CommandButton1_Click() Sheet9.WebBrowser1.Navigate...

What I am doing wrong here? does value 0814 greater than 2000? I need result {z} in cell B1. all cells are with general formatting a1 590_310814 b1 =IF(RIGHT(A1,4)>2000,"x") result in B1 x <tbody> a b c d e 1 590_310814 =IF(RIGHT(A1,4)>2000,"x","z") 2 </tbody>