data extraction

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

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

Hello Mr. Excel folks! I have made great strides on my attempts to automate logging into, and then extracting data, from a website. I have gotten all the way to the point where the data is indeed in excel! However, the data is all going in only one column, column A, and I cannot figure out how...

I'm now in a headache to extract data from files and really wish somebody could help me out of this. The problem is that there is a directory, e.g. I:\john In this directory, there are 100 zipped files. In each zipped file, there are 26 different .csv files. I only want to extract the data...

Hi, I'm trying to extract data from multiple worksheets from over 30 workbooks from a same path to a another master workbook. For instance, if cell D9 in the different worksheets is equal to "X", I want to extract data from specific cells for all those worksheets. I am very new to VBA and...

I'm not sure if I'm on the right track or if I started off entirely in the wrong place. I have the below, which I am using to create a new workbook. After that workbook is created, I would like to use those same variables (the dstart & dend) to define a range, which will be copied out of each of...

Hi guys. I found some brilliant advice on extracting the last cell from a cell of data in this thread from 2012. The user Rober Mika provided this formula for extraction of the last word from a cell: =UPPER(TRIM(RIGHT(SUBSTITUTE(TRIM(X1)," ",REPT(" ",99)),99))) This works great for most...

Hello, I am looking to pull information from multiple pages on one website (data extract is the term I have been seeing mostly) and am looking for a simple solution. Long story short the info I am looking to grab must be selected after going through a couple clicks. Ie Base webpage -> select...

Ok, this is what I would like to do. I need to access an aspx website that I log into with my own personal login. There is a specific collection data I would like to then navigate to and that is a web form that houses data for my clients. I want to aggregate this form data into an excel sheet. I...

I am a rookie with VBA, Macros etc. I don't know coding at all. I want to use iMacros to extract data from websites how is this possible? I want to extract data from website and put it into an excel workbook using iMacros automation. Looking forward for your valuable answers.

Hi, I am wondering if anyone here knows if there is any way possible to recreate the 'Double Click to Source Data' event on a pivot table. For instance, I have created a few tables using sumif and countif etc etc, I would like to recreate the 'Double Click to Source Data' event within this...

Hi, I am new here (obligatory comment!) I would really appreciate help with the following: I have a workbook with multiple worksheets, each worksheet is a client with a a list of pending payments and dates (among other info). My boss wants a "cover" worksheet that pulls the information of the...

Hello all, I am currently working with a large PPT file sent over from a co-worker. There is about 40 charts in this PPT that he built within PPT. My question, is there anyway to extract the data from all of these charts into excel so that I can add data and create new charts? :confused...

So I am a engineer running a test that usually has 150 conditions. Every odd condition is a "equilibrium condition" that is meant to stabilize the test rig between the even conditions. The even conditions are the actual results I want to look at and evaluate. I've been trying to use a IF...

Hi, Need assistance in finding solution on, how to extract phone number from a text string. http://goo.gl/qucPe7(Link for test file) I have searched the forum but was not able to find any solution which can help. Thanks in Advance.

Hello All, I have a VERY long string of text copied from a web page. I'm only interested in certain relative data. Can the string be parsed or delimited such that I end up with three columns? One for The deceased's name, one for the executor, and one for the cause number? The text to columns...

Hi all, I am facing a two-pronged challenge: 1. I have a workbook with school rosters. Each sheet in the book is a school roster from a different week (i.e., sheet 1 = 06/01/10-06/08/10, sheet 2 = 06/09/10-06/16/10, etc). Most of the students are simply carried over week to week, although each...

Hi, Let's say I have a master table with company name, person name's and business title. Now have a subtable with names of a few companies and names of a few people belonging to those companies. I'd like to query from the master table the appropriate business title of those people in those...

I save bounced messages in an Outlook folder and export these as CSV/Excel sheet. I then need to split out the email addresses so that they can be marked dud in my mailing lists. The cells with the email addresses are laid out thus (cut and pasted from the cell): "Delivery has failed to these...

I have an excel 2007 spreadsheet at my work, its about 30 colums across and contains a couple of thousand clients, one client per row. I'm pretty happy with it at the moment Ive done some (what I would consider) nifty stuff when it comes to summarising the data on there, stuff per month, that...