+ Reply to Thread
Results 1 to 2 of 2

Macro to Conditionally Copy and Paste

  1. #1
    Registered User
    Join Date
    02-24-2015
    Location
    Florida
    MS-Off Ver
    2010
    Posts
    1

    Macro to Conditionally Copy and Paste

    Hello all, first timer...

    I've attached a VERY general form of the file I'm working on.

    On Sheet1, I defined B2:B4 as company1, C2:C4 as company2, and D2:D4 as company3. Those ranges are meant to be my inputs which can be negative, zero, or positive.

    If it is positive, I need to have payment request printed for each instance. So I'm trying to make a macro that would do the following...

    Scan through company1, if a value is positive, copy the fund name in Column A, paste that fund name in Sheet2 cell B2, print that sheet, then resume scanning through company1 for other positive values to do this task. Once done for company1, I'd need the macro to then do the same for company2 (but pasting in Sheet2 E2) and company 3 (pasting in Sheet2 H2).

    I would really appreciate any help, I've tinkered a ton with it, but can't seem to get something working.

    Thanks a ton for everyone's time!
    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 Conditionally Copy and Paste

    I wonder whether you can try this
    in a new sheet sheet 4 copy this formula in B2
    =IF(Sheet1!B2>0,Sheet1!$A2,"")

    copy this formula to right and down.

    is this whkat you want.
    I am not an expert. better solutions may be available
    [email protected]

+ 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. [SOLVED] Insert new column and conditionally copy and paste values
    By kriahnadas.oo7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2013, 10:07 AM
  2. Conditionally Copy/Paste Data from one Workbook to another
    By justin19 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-02-2013, 04:48 PM
  3. conditionally copy formulas and paste their values based on columnA
    By cmmchick in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-29-2013, 05:02 AM
  4. [SOLVED] Conditionally Copy Cells from Multiple Sheets and Paste in Another Workbook
    By Gos-C in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2012, 09:22 AM
  5. Macro to Conditionally Copy-Paste Certain Cells
    By succel in forum Excel General
    Replies: 4
    Last Post: 08-10-2010, 09:37 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