extract data

Hi, Can you assist with a formula that will extract values (such as names or distribution lists names) contained within a cell. Below is sample data i would like to extract the person's name or the distribution list name. This file was obtained by exporting the members of a DL from MSOutlook...

Hi, I'd like to create a report that displays the values according to 3 criteria. I have 3 drop down boxes that one can select a customer's name, brand, and date (format of Jan 2013 Week Ending 1/26/2013). My drop downs are in a separate sheet under a5, b5, and c5 respectively. I will then need...

Hi, Thank you for reading this post. I have a table containing the result for different races I extract from another software, compared over 2 year (2011, 2012) The table look a bit like that : <tbody> 2011 2012 Alpha Bravo Charlie Romeo TOTAL Alpha Bravo Charlie Romeo TOTAL...

Hi guys, I am very new to VBA Macro's and kinda on a tight schedule, which is why any input will be helpful!! I have looked at multiple other posts and threads relating to similar situations, however i have not been able to adapt the macro's to what i need. The Excel file which i want to...

Is the an easy way (ie, No VBA) that can have a form (similar to this one http://www.sfu.ca/biology/forms/trclaimNonEmployeesOnly.xls) and then extract the input data to a regular table look spreadsheet with the column heads at the top that match the form, Name, Hotel costs, Date, etc? Thanks...

Hi. I've found several posts about returning variable substrings that dealt with one or two spaces, but I have not been able to find anything that is for multiple spaces. The number of characters before the substring will remain constant. For example: Income from transmission agreement - 83...

Hi all, I am wondering how I can use VBA to extract data from multiple excel files onto one summary workbook that pulls the data from the most recent date. All of the excel files have different names but each worksheet is labeled "Financials". Each worksheet is formatted almost identically - all...

<tbody> EncID Admit Date Discharge Date Service Count Service Hit 1231 1/1/2011 1/15/2011 7 OBGYN 1232 1/1/2011 1/15/2011 7 OBGYN 1233 1/1/2011 1/15/2011 6 OBGYN 1234 1/1/2011 1/15/2011 6 Heart 1235 1/1/2011 1/15/2011 5 Heart 1236 1/1/2011 1/15/2011 5 Lung 1237 1/1/2011 1/15/2011 5...

Hi Can you help with a formula solution for the following as I want to extract just the number from a string of text , in this case it is 150 but it could be a single digit like 5 , but in each case the amphersam appears after the number if that helps...

Basically I have the following data that I want to put in a table as shown in the second quote. I would like to write some code that checks "Header, Mis and Veh" if each one matches to the corresponding line in Table2, it places Answer in that cell. For example, for (String2, 1, 52) (Header...

I want to extract the brand names from a column of SKUs (stock keeping units). I know how to do it using standard worksheet functions (i.e. without using vba) and I know how to do it by simple looping. However I want to use arrays because there are several hundred thousand rows of SKUs and...

Hi There I am using InstrRev to extract items from around 200,000 cells in Col A. The problem is that the macro takes around 3 hours to run. I am relatively inexperienced in VBA so I was wondering if there is a way to make the code run faster. Example cells in Col A are: ADMIRATION SYBN...

Hi, I need some help with a spreadsheet I am currently working on. Basically, I am creating this for M.I purposes. I have got 1 sheet with raw data and used the Sumproduct formula to extract the amounts into a table in another sheet. The table has the current status' down the side, the age...

Hello forum goers, Need to extract only the numbers from the below string in A88. I need these numbers in individual cells in Row 88 from column K:FW <TABLE style="WIDTH: 439pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=585><COLGROUP><COL style="WIDTH: 439pt...

Hello, I am using Excel 2010 I have data in column A (arround 5,000 entries) and I want to extract the product type and put it in column B whilst leaving the whole product data intact in A. The product names are not regularly formatted which causes the problem for me. I suspect it is a...

I have a workbook supplied by someone else which contains cell entries with multi-lines - can I extract these by line?

Hello, I'd like to extract rows based on dates from another sheet (which is also an extraction. What kind of formula is best and what formula works? I've been trying to get this answer for a week now. <TABLE style="WIDTH: 568pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=756...

Hello, I'll keep it as simple as possible... This is what I have <TABLE style="WIDTH: 304pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=405 border=0><COLGROUP><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 48pt" span=5...

Hey there, I"m so confused. I have a sumproduct formula that works seemingly only if I keep the number of cells it's searching below a certain range. This works fine: =SUMPRODUCT(--(WEEKDAY('Daily Rundown'!$A$5:$A$83,2)=1),--(ISNUMBER(SEARCH("*advocate*",'Daily...

Hi everyone, I am new with vbs and trying to seek help from the expert here. I have lots of request forms data to be extracted from a specified folder (c:\Data\) into a new workbook (c:\Data\Complete\Data.xls). Been working on it for the passed 2 week and still didnt manage to get the result i...