extract data excel

Hi all, I'm retrieving data from the SAP Erp system using a main macro that calls several macros, using a structure like this: sub Main() call Macro1 'get parameters from the Excel worksheet call Macro2 'input some basic parameters in SAP call Macro3 'get first data from a SAP transaction...

Hi all, I'm trying to extract a list from a couple of columns. <tbody> A B 1 Documents Required? 2 Form 1 Yes 3 4 Form 2 Yes 5 6 Form 3 No 7 </tbody> First column has a list of all the forms (one blank row after each form). Column B indicated whether that form is...

i have this type of data in excel, in cell a4 i have text 34, in b4 i have text 21, and in c4 i have 55 (a4+b4) comma seprated values etc 32,34,54,543,567 and i want in cell d4 first 34 values (as an a4 written) and on e4 remaining 21 values (as per b4 written) Here is the sample Available...

Hi - I have a comments text cell and somewhere within will contain a specific string of numbers I need to extract and place into a seperate cell. The number I need to look for will always be in a ###-###-### format (ex: 145-875-886) How do have excel scan the cell for this format and...

Hi everyone, I have text data in the single cell in the following format. <tbody> New Advice Requested 242.59 Target Bps, [ Quantity : 3,700, Bps : 0, Target Bps : 242.59 ] </tbody> I would like to extract the 3 data points in the [ ] brackets into adjacent cells if possible. 1...

I copy and paste the following data from the UBER website. Data before copy and paste: TIME DURATION MILEAGE FARE October 31, 2014 12:50PM PDT 37:05 8.76 $19.22 October 29, 2014 4:20PM PDT 12:18...

Hi All, I am using Excel 2007. I am trying to prepare new a Excel sheet which will replace a conventional white board usage in my company.Btw I'm new to Excel VBA. Ours is a car rental company we need to track where our vehicles are daily at the end of the day.So this sheet will be updated with...

hello again yall I am trying to extract data from a cell to a new cell Example F3 = 10002-6000572-new I am trying to get B3 = 100002 any ideas?

Hello Y'all I am trying to extract data from a cell to fill another Example in CELL D220 = Black - (Part ID: 4278910) I want in CELL C220= 4278910 How to extract?

Dear all Excel gurus, I need help on macro to extract data from cells and populate them into a table. Kindly go to the links below for the images. I have no idea why I can't attach images here. Your help is greatly appreciated. Thanks in advance...

Hi Guys, I have never posted before but I am hoping that someone will know how to knock this out. My admin is going crazy opening all these files and then cutting and pasting little snippets into one merged file! I have to believe a macro type VBA program can help here. We need a...

Hi All, My excel file looks like this: <tbody> chr 1 1 A chr 2 2 A chr 3 3 G chr 4 4 A chr 5 5 G chr 6 6 A chr 7 7 A chr 8 8 G chr 9 9 A chr 10 10 G </tbody> I need to systematically extract 5 rows : 1- line 0->5 2-line 6-10...

I have a cell of text that is separated by a colon (:) character. The amount of text in the cell and the amount of colon characters varies. I need to extract all data to the left of the last colon character into a cell and all data to the right of the last colon character into another cell. My...