+ Reply to Thread
Results 1 to 1 of 1

Copy rows to 2 sheets using criteria

  1. #1
    Registered User
    Join Date
    10-31-2009
    Location
    S
    MS-Off Ver
    Excel 2003
    Posts
    25

    Copy rows to 2 sheets using criteria

    I copy data to the sheet "3" in a daily basis so the row count vary every day depending on the date range I need. I need only the data in the rows with green headings from sheet "3" to go the corresponding headings in sheets "1" and "2" with the following criteria:

    I need all of the rows with green headings from sheet "3" with the word criteria "Asset" from column "BJ" copyied to the green section of sheet "1" after clicking a button called run in sheet "1".
    I also need all of the rows with green headings from sheet "3" with the word "criteria "Stock" from column "BJ" copyied to the green section of sheet "2" after clicking a button called run in sheet "2".

    I need the macro to also keep the two rows of space between the green and yellow sections in sheets "1" and "2" regardless of how many data it is copyied to the green section. In other words I would like it if the green section autosizes so that there is always a 2-row space between the green and yellow section after the data is pasted in sheets "1" and "2".

    Thank you for your time and I would really appreciate some assistance with this Macro.

    Attached is the excel file.

    Thanks,

    moroformat
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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