data extract

  1. N

    Extracting Data from Putty Logs

    First I want to say thanks for anyone trying to help. I have not been successful at pulling this data thru scripting as easy as I think it should be its just not coming to me. Currently we run a program thru putty and it displays a series of number I have to validate against another list that is...
  2. M

    Sorting Data from Multiple Pages by Date Based on Description

    Hello, I am attempting to generate an organized list of all entries from multiple sheets which have a date, vendor, cost, category, subcategory, and notes. I am looking to have them sorted by date based upon their vendor, and to display the original date, notes, and cost of the data which...
  3. M

    Sorting Data from Multiple Pages by Date Based on Category and Subcategory

    Hello, I am attempting to generate an organized list of all entries from multiple sheets which have a date, description, cost, category, and subcategory. I am looking to have them sorted by date based upon their category and then their subcategory, and to display the original date, description...
  4. J

    Data Collection Help

    I'm trying to build a sheet that collects addresses I receive from clients about available work throughout the US. This information comes to me via email from different clients. Each client sends me the information in a different format but all of them have the same information. The information...
  5. D

    Help with extracting uniform data from Multiple workbooks into one Master Data sheet in its own workbook

    Hi Guys, I am new to the forum and would appreciate some assistance with my problem as i have limited VBA coding knowledge. I am currently trying to program a command button to extract data from the same column but from multiple workbooks that contain only one sheet, and to insert it into one...
  6. S

    get data in a new column from first column with value

    When I get a report out of the system, “column a” should have all the names, instead it is first few rows name is in “column a”, then it is in “column b” then in “column c” and so on…. So I want to add a column before “column a” and in the “new column a” I want to get data from all the other...
  7. H

    Data Merge if data comes in different cell

    Hi Team, Looking for one function or macro in order to identify the blank cell (in sl.no column) if yes then it should merge the two given cells. I have data which is extract from PDF and in A1 column I have serial number the challenge here some cells divided in two different cells (down...
  8. A

    Macro to pull data from oracle

    I Have a workbook which consists of 50 worksheets and i use Edit query window to pull the data from oracle on all these sheets. We run this once in a month. I have to go to every sheet and execute this code which is time consuming and i have to change the date value everytime.Please help me with...
  9. L

    Template data extract

    Hey all, I've been working on our headcount templates for our planning process and I'm trying to find a way to extract the data from all of the responses into a single worksheet that can then be imported into Access. It's highly manual and did a simple macro but it didn't capture everything...
  10. M

    Extracting data from a table

    Hello all. I have a table with 6 columns. I need to extract a range of values from one column based on three criteria. Thats is the first three columns are used to filter the table and then I need to extract the data in the one of the remaining columns and write it to a list on to another...
  11. dukeofscouts

    Array Formula issue

    I'm combining two formulas that I have intergrated into workbook. I'm cleaning everything up so I would like to have the two formulas calculating in one cell, so this is what I came up with: =INDEX(Food_Items[Item],SMALL( IF($AM$3<>"", IF($C$2<>""...
  12. pedie

    Challenge for everyone...? Not sure..please help!

    :confused: Below is the code example i found... Whenever i ruin this macro code that will extract data from other resource..it does not work but gives error "Unrecognized Data format 'C:Book2.xls'. I dont even know how this works but i hope someone in here will be able to solve this...
  13. dukeofscouts

    Array formula issue

    The following formula servers to act as a dynamic data extract, similar to AUTO-FILTER. Every time I try to enter the formula I get an open box that is titled: Update Values: Data' I've gone over the formula again and again, but I don't see where it is separating the address 'Raw Data', or...
  14. T

    Advanced Find - loop

    Hi all I've got a spreadsheet which contains, in column L, a field entitled Unique Reference Number (URN). The data is over 9000 rows long. This URN field contains an integer. Each unique integer appears between 1 and X times within the dataset. I'm trying to extract any integers in a...

Some videos you may like

This Week's Hot Topics

Top