data extraction

  1. M

    VBA to extract data from several data files - Bank Deposit Analysis

    I prepare a weekly deposit analysis for 80 locations and we are growing rapidly. I pull POS data from 2 sources and bank data from 18 bank accounts. 1. Deposit Analysis Workbook: This workbook has a tab for each location where all the data is consolidated 2. QOS POS data file: csv file that...
  2. N

    Removing Duplicates Based on Date

    I'm new at this, so if I don't explain my problem correctly, please don't shout :cool: Column A = date Column B = name (sometimes multiple occurrences / date) >5000 rows I want it to show ONE occurrence of each name per date. 1) Does that make sense? 2) Can it be done? Cheers ~Phil
  3. A

    Extract unique values from disjoint columns

    Hi, I am new to VBA in excel and would request your help to solve my problem. I am currently working on a problem which involves extracting unique string values from 14 disjoint columns in excel. Each column in my data has around 500 string values with few blank cells in between. The 14 columns...
  4. ChrisRamsden

    Loop extracting all data but then causing runtime error 13 (Type Mismatch)

    Hi Everyone, I am a brand new member, although i have been using MrExcel for tips and information for a few years now. I am currently writing an excel macro to pull data from another workbook by finding the number 4 and using offset to pick the cells i want to copy and paste. The macro is...
  5. S

    VBA to extract values from multiple spreadsheets into one

    Hi, I have 30 files in the same folder (P3/2014/PPD Data) one for each month (last 30 months). Each file has approx 6000 rows of data with prices for the drugs for that month. I need to extract the data relating to only 5 of these drugs over the 30 months (call them drug 1, drug 2, etc). The...
  6. M

    Extract data after special characters

    I want to extract data from a cell containing this information: G# 202352, 202347 ZRX MED 4984 LT/PIR WE 218867 DUE 4/30 <tbody> G#222237/222240/222244 TUE 4911/4913/4940 PI/CFZ WE 220917 DUE 04/30 G# 202352,202347 ZRX MED 4984 LT/PIR WE 218867, 218357 DUE 4/30 <tbody> G# 202352 ZRX MED 4984...
  7. M

    VBA auto record macro change help required

    Hi, I need some help in below code. I recorded the macro and this code generated. It should save file in same format at the end that part I deleted because it asked for xlsm format so I did to get the code. What I was doing in this code is basically. 1. Filter "Pending" "Mobile" Status in...
  8. R

    Time series data

    Good day all. I’ve got a time series database for my economic data, and it generally works pretty well except I have one issue around data frequency in my queries. In short, different indicators have different release frequencies, such as daily, monthly, quarterly, annual etc. I have two...
  9. P

    Extracting data with certain "0000" characteristics

    Hi. I wish there was a way to attach a simple .xlsx file here. Just realised a pattern in my data analysis of (nearly 300 rows) BUT scratching my head how to extract all rows that have this "weird 0000s in the values in the 3 columns C D E. Column B is Details in case a vba is apt. My...
  10. V

    Need way or vba code to extract data from different excels to one single template.

    Hi am new to vba and need help on this which is very complicated for me. Is there any way like vba code where i have different fields in a template and the data can be extracted from other different excels like multiple excels or sheets by mapping the fields. please help. Hoping :)
  11. T

    Extracting Data From String in Exported Emails

    Hello, Thank you in advance for taking time to review my question. I have a list of emails exported from Outlook to a .CSV file and I am trying to extract data from the "Body" cell and paste it into corresponding cells on a different sheet. Each email contains somewhere in the body this...
  12. H

    Extract text from multiple sites on a Mac

    Hi all - first time poster, long time follower here! I have a website https://www.top10erp.org/erp-software-comparison-distribution-industry-164 that contains a table with a load of links. Each link takes you to a different (non-indexable) page. I'd like to copy the body of text from each page...
  13. 1

    Code Needed for Project

    Hello everyone, I have decided to take my confusion to the forums, though I've never done this before, so I will do all that I can to make this as least painful as possible, and if I don't follow protocol exactly, I am deeply sorry- I am doing my best. I am documenting sales velocity of...
  14. S

    VBA Code to pull information from multiple pages into an Excel table

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

    Extracting data from formatted workbook

    Hello MrExcel! I discussed a similar question with a MrExcel user earlier but wanted to open this up to everyone else on these forums, too. I've got a consolidated workbook with umbrella questions, subquestions, scores, and answers, and I would like to break it up into separate sheets. I'm not...
  16. V

    VBA Excel data extracting from a website for different dates with same URL

    I need to extract website table data from this link: https://www.iexindia.com/marketdata/areaprice.aspx for different dates. The problem is that even for a different date, the URL of the website remains same as the URL for the current date, So I can not use the dynamic URL in the VBA code. I am...
  17. D

    Automatic email

    Hello Everyone i have been assigned a task in my office to send multiple email by using one button,i guess i have to write a vba code for that. I have seen few vba codes but my requirement is bit different. I need code which extract data from the worksheet and send a mail via outlook . Is it...
  18. M

    Excel extraction help

    I have a lot of data and I want to write a formula. I have four companies in my data XYZ, XY, AB and CD. as you can see in below data. Original Data sometime contains company name sometimes there is no company name in front of original data. I want to keep same original data in desired output...
  19. M

    PDF Data Extraction help please.

    I have several PDF's that have many tables based on type, size, & year that I need to pull specific data from. The PDF's are company controlled and they send out updated versions whenever the need for change occurs. My quest is to have an excel sheet with drop down lists for the choices listed...
  20. C

    How do I extract a zip code from a column that may have a random amount of text (body of text) in a spreadsheet?

    Hi all, I have a spread sheet with a column that includes a random amount of text like so: ----------------------- Contact Name: Contact Email: Contact Phone: I am interested in 1234NE 12Tth, Williston, FL 32696. Search CriteriaCity : State : ZIP : 0 MinLotSize : 0 MaxLotSize : 0...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top