extract data

Hi there, I am looking for a way of extracting specific data from a large Excel data set I have. For example, if the below is my large data set... <colgroup><col><col><col span="4"></colgroup><tbody> Team Account Manager Jan Feb Mar Total A Daniel 2 5 5 12 B Jane 5 8 3 16 C Gill 3 6...

Guys, i've been trying this for a long time and now i give up trying lol. i want a macro that access the website https://br.financas.yahoo.com/q?s=pmam3&ql=1 copy the value of the quote, then paste at the worksheet after that, go to the "digite o símbolo" box, search for another cote and...

Hi, I'm creating a "Dashboard" to display metrics. I have a number of "Tracker" files that I need to extract data from and summarize in my Dashboard. All day I've been searching the internet trying different ways and adapting them to my situation but none of them have worked. The tracker...

I was curious if there was a formula to pull data from three rows and place them into one column even if there are different amount of data in each row. This is similar to excel magic trick 701 and this is the same question that was asked on that page at the bottom...

Hello, I'm using Excel 2013. I'm looking for a VB macro. I've got a workbook which has got more than a million records. Therefore, this workbook has become very sluggish & difficult to handle. I now want to extract every 100,000 records to a new workbook so that I can manage the data well &...

Hi I'm struggling to extract the last 1,2 or 3 digits from an IP address. the problem I have is that I have different length of IP address, so for example 10.1.93.145 145.10.5.16 145.168.192.1 I am trying to extract the numbers after the last full stop so the above example results would be...

Farm boy needing a hand here: I am lost on this I have been puttering around with this for a month now and no luck. I want to get all the Agriculture delayed quotes from the CME website and input it into excel and update say every 20 minutes. The issue is, that all the data is being generated by...

I have two worksheets. Worksheet 1 is the Detail AP Listing which has the vendor #, Invoice number and the description of what the invoice is for. Worksheet 2 is the GL which has the vendor # and the invoice number but not the description. I need to populate the Description of the invoice in...

Hi, I am working on an excel sheet and need some help. I have data in the format of the table below. I have only shown 2 examples of the data, but I have 15+ various line items which all have different work items, descriptions, work orders, completion dates, etc. Table 1 <tbody> Line Item...

Hello guys, Does anybody know the formula to insert in Google docs to extract an email address from an url? So (column A) www.sitename.com | (Column B) email thanks

:confused: I have a list of movie names in B1:B1000 and I would like help grabing the following data from "http://www.omdbapi.com/?t=". The data I need to grab goes into these fields, D:D - Year E:E - Rated F:F - Run Time G:G - Genre H:H - Plot I:I - Poster J:J - Imdb...

Hello everyone, I have some data, in a xlVeryHidden sheet, with multiple headers. An example is given below. I would like to auto-generate a table on a different sheet with only revelent headers and filter by source and month/year. Basically, I want to write a macro that would make this table...

Hi I am new to this forum. I have already gone through the other threads to make sure that I am not asking questions which have already been answered and I have asked two relatively very experienced Excel users but left with no answer, I now humbly request your assistance. I have a huge...

I've a list of names with different numbers of spaces, i would like a formula to give me the last name regardless the number of spaces... is that possible? List example: <colgroup><col></colgroup><tbody> Amélia Alexandra Correia Almeida Maria Albertina Alves Moreira Figueiredo Mário...

Hi folks, Have an issue which bothers me for a year now, I receive every month a list with data from our website, users who registered in one of the cells I have the name and the email address but i need it separated here are an example of it what i have <tbody> charlie pink -...

Hello, I'm trying to extract certain text within Outlook 2003 emails an put the information into an Excel 2003 Spreadsheet with the column headings of: DATE/TIME SENDER RECEIVER APP SENDER REF# ERROR MSG...

:confused:Hi All, I have an excel document that's a very long list and i want to automate my process with extract certain information for my new document, but using java. I am also open to vb. So I have 5 columns with information that i will need to use to create this new excel sheet. See...

Dear Mr Excel, Is there way to get the extract the data from the autofilter to another sheet dynamically? The following is my data sheet: my excel sheet has just two columns Assignment code <colgroup><col><col></colgroup><tbody>...

Hello all and thank you in advance for any help you can give. My overall goal is to have a MasterLog worksheet that contains summary data from individual files. There will regularly be subfolders added and individual excel files within those subfolders. The individual files are all formatted...

Hi, I am trying to create a macro that will extract data from all the worksheets in a workbook to a summary sheet (which occupies Sheet1). In a nutshell, I have several worksheets in a file that I adjust individually from time to time, they all maintain the same exact format with same...