extraction

Hi guys, I'm having trouble figuring out how to complete this data cleanup: I have a list of items that all follow the same format: 123456789012 Abc company 5 10-04-2013 bcdefgh company y p The items were copied and pasted from a PDF file, hence the messiness, and the misalignment of the...

Help from the Excel Gurus Needed! As you’ll be able to tell, I’m a hotelier and not nearly versed enough in Excel. The data is laid out as follows: Each set of information is broken down by "date”(shown in brackets in column D) and “Period” (meal period to describe but it’s identified as the...

Hi, This could be a bit complicated, but hopefully also useful for others. We have the following sample of 10 cells from a large file with similar data: N: 1; B: 162; M: 278, 278; T: 24; A: 103, 105; I: 393; Ḥ: 7240, 7390, 7465, 7546, 7617, 7756, 27399, 8380, 8741, 8894, 8985, 9559...

Hello, I'm attempting to organizing an extraction file that was originally a tab delineated table (from AutoCAD ATTOUT). I copy this table to a sheet preset in my workbook (ATTOUT). I have three formulas: one that lists the symbols (column A), the other returns the quantity(ies) associated with...

Hi everybody, Below there are all the information needed to understand my problem. I tried to find something similar in the forum, but I couldn't. M(1 to R,1 to C): matrix with R rows and C columns [element known] M(i,j): elements of the matrix M in position i(row)-j(column) [element known]...

Hi guys! I am struggling with a data extract that i need to reformat and hoping someone can assist:) I have the below raw data in tab1, most of the fields in column h repeat themselves so i want to set these fields up as headings and then format the data as per example 2 in tab2. some fields...

I need help trying to retrieve the source code from a website. How I normally navigate there: I start at http://www.bls.gov/home.htm, scroll over Subject Areas, click Consumer Price Index, click Top Picks button for All Urban Consumers database (probably have to scroll down a little), check...

I have been trying to extract the same data set via an ODBC connection to a main frame database. One attempt has been using Access simply Query and the other via MS Query. The Access simple query does not return the information I need yet MS Query does. How can there be a difference if I am...

Good afternoon all, I'm attempting to create a macro that would extract all the text from an excel spreadsheet with multiple worksheets, remove all the duplicate words and place the file in a format that would allow it to be imported back on top of the current file with the newly translated...

Please Help! I have 100 or so workbooks named A1234.xls, A1235.xls, A1236.xls etc. I want to gather information from the same worksheet and same cell in each workbook. I want this information in a separate workbook named Master.xls In the Master spreadsheet I have the workbook names in...

Hi, I have a query that is doing my head and cannot solve, and I hate that! I have a pivot table based on a certain data set. When I double click on a cell in the data section to extract the data into a new worksheet, the format of the data in the new sheet is completely different to the...