Results 1 to 5 of 5

Copy rows that meet conditions from one sheet to another sheet

Threaded View

nilamani Copy rows that meet... 11-27-2014, 02:39 AM
davesexcel Re: Copy rows that meet... 11-27-2014, 03:21 AM
nilamani Re: Copy rows that meet... 11-27-2014, 08:42 AM
nilamani Re: Copy rows that meet... 11-27-2014, 01:10 PM
davesexcel Re: Copy rows that meet... 11-27-2014, 05:00 PM
  1. #1
    Registered User
    Join Date
    01-21-2012
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    9

    Copy rows that meet conditions from one sheet to another sheet

    Hi
    I have 3 sheets "Select", "Master" and "Report" in a workbook. "Select" sheet is for selecting the conditions. "Master" sheet contains all data. "Report" sheet to show the result.
    My query is (a) select the conditions (2 conditions) from "Select" sheet. (b) Based on the condition select, copy all rows from "Master" sheet those meet the condition to "Report" sheet. (c) Every time when I select the new condition in "Select" sheet, the "Report" sheet shows the new result based on condition meet from "Master" sheet.

    I am looking for VBA codes for this.

    I attach the example file for the reference.

    Please help on this.

    Thanks
    Nilamani
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-11-2013, 02:58 AM
  2. Replies: 3
    Last Post: 04-23-2013, 06:49 PM
  3. Copy rows into a new sheet as per set conditions
    By walchase in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-06-2012, 03:51 PM
  4. Replies: 4
    Last Post: 11-28-2012, 01:43 PM
  5. Copy rows from one sheet to another based on 2 conditions
    By chrispulliam in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-23-2010, 01:38 AM

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