data ectract

  1. R

    extraction of data

    I have a user form that dumps data into a sheet. at a future date a supervisor will type yes in an approved column if they approve the request. once they make the change in column F to "YES" i need to extract the data from that row so the data is columns A-E in the same row where F had the...
  2. T

    VBA Marco to extract data from multiple workbooks and compile data in a single workbook

    Hello all, I am new and still learning macros, using Excel 2010 on Wins 7. I am in need of finding/creating a macro that's purpose would be to: Go through every workbook in a defined directory (C:\test) Locate the Worksheet named "Change Log", in every single Workbook in C:\test In the...
  3. P

    Referenceing NonConsecutive Cell with Macro

    I need to extract data from Sheet1 into Sheet2. The data being extracted is sample book analysis and each book has a series of row headers and column headers. The row headers are repeated for every book while the column headers are repeated once at the top. Each book is separated by a blank row...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    • Replies: 49
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    • Replies: 37
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    • Replies: 35
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    • Replies: 35
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    • Replies: 30
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    • Replies: 25
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top