+ Reply to Thread
Results 1 to 4 of 4

Copy and Paste data based on two criteria being met

  1. #1
    Registered User
    Join Date
    12-03-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    14

    Copy and Paste data based on two criteria being met

    I am trying to copy and paste select data if two criteria are met in any row. I searched the forums and dind't find anything I could adapt. I may have missed it, but this is just beyond my ability. Thanks for any help that can be offered.

    One Sheet Workbook:
    Sheet Name - DWB
    A1:T23 - Sheet totals and command buttons for macros. Think one gigantic header area.
    A24:T1000 - Data range. I expect the number of rows (not columns) to expand over time.
    F11:F21 - Target range for pasting

    If F24 value = "Decision Writing Process" and S24 = "No" or blank, then I want to copy A24+D24 and paste into a single cell in the target range.
    If F24 value = "Decision Writing Process" and S24 = "Yes" then nothing.

    Example: If I ran the macro today, and there are 5 instances of where the criteria are met, I would need the pastes to be in F11:15. There may be some days that no rows meet the criteria.

  2. #2
    Forum Contributor thameem127's Avatar
    Join Date
    04-06-2012
    Location
    Jeddah,Saudi Arabia
    MS-Off Ver
    Excel 2003,Excel 2007
    Posts
    321

    Re: Copy and Paste data based on two criteria being met

    Upload your file

  3. #3
    Registered User
    Join Date
    12-03-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Copy and Paste data based on two criteria being met

    Sorry but I can not. The security protocol at our company prohibits/disables all downloads and uploads.

  4. #4
    Registered User
    Join Date
    12-03-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Copy and Paste data based on two criteria being met

    Respectuful Bump.

    I am really at an impass.

+ 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