+ Reply to Thread
Results 1 to 4 of 4

Macro to extract data based on defined criteria

  1. #1
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    744

    Macro to extract data based on defined criteria

    Hi,

    Apologies in advance, this requirement is likely to develop/change as I understand what ultimately it is I'm looking to achieve.

    Basically I've got a large data extract from our procurement system that holds all the rates agreed for various types of work from different suppliers. What I've been asked to create is a macro that can extract certain elements of that data based on defined criteria. The attached workbook shows a simplified version of what I'm working with and what I'm looking to achieve.

    Thanks in advance,

    Snook
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Macro to extract data based on defined criteria

    tentatively try this macro test (macro and function to parked in the module) and give your comments. see comments in the code
    new sheet named C2 is opened by the macro and copied
    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    I am not an expert. better solutions may be available
    $$$$venkat1926$$$$@gmail.com

  3. #3
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    744

    Re: Macro to extract data based on defined criteria

    Thanks for trying Venkat1926 but it doesn't appear to be doing what I require.

  4. #4
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    744

    Re: Macro to extract data based on defined criteria

    Come on people, this forum hasn't let me down yet so please don't start now!

    If anyone has any queries about what i'm looking to achieve just give me a shout.

    Regards,

    Snook

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 12-18-2014, 10:27 AM
  2. extract data based on single criteria
    By auntiet in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-31-2013, 07:22 PM
  3. [SOLVED] Extract certain data based on two criteria
    By sam-0987 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-05-2013, 01:23 AM
  4. [SOLVED] Extract data based on 1 criteria
    By TexasRhode in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-06-2012, 06:08 PM
  5. Replies: 11
    Last Post: 07-11-2012, 06:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1