+ Reply to Thread
Results 1 to 8 of 8

Copy/Paste multiple columns as values based on another columns criteria

  1. #1
    Registered User
    Join Date
    08-07-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    39

    Copy/Paste multiple columns as values based on another columns criteria

    I have a worksheet called "Test Log" with a "Y" in column A - starting in row 5...(A5:A)

    For as far down as the "Y" goes (but no further) I want to copy and paste the formula as VALUES in column E, again starting in row 5...I need the formula to stay in place for any rows that do not contain "Y" in column A for future calculations...

    I would like to offset this by 6 columns, 12 times.

    Can anybody help, I cant figure it out !!

    Thank you for any advice in advance
    Attached Files Attached Files
    Last edited by Dgp2012; 07-28-2013 at 06:50 AM.

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Copy down formula in column X based on criteria in column Y

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    08-07-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Copy down formula in column X based on criteria in column Y

    Thank you, sample workbook attached...

  4. #4
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Copy down formula in column X based on criteria in column Y

    well i cant see what you actually mean

  5. #5
    Registered User
    Join Date
    08-07-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Copy/Paste multiple columns as values based on another columns criteria

    Sorry, i have adjusted my original post

    The formula in the columns are SUMIFs leading to a data sheet, as i remove older data i just want to be able to keep a copy of the result in these columns, hence needing values in only those rows...

  6. #6
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Copy/Paste multiple columns as values based on another columns criteria

    ok ill get a vba person to have a look

  7. #7
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Copy/Paste multiple columns as values based on another columns criteria

    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    08-07-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Copy/Paste multiple columns as values based on another columns criteria

    Thank you again Yudlugar,

    This worked great, with a slight adjustment:

    Please Login or Register  to view this content.

+ 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] Copy data from column to other sheets, based upon vlookup/criteria on column a
    By jedemeyer1 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-27-2013, 04:01 AM
  2. Need VBA to copy rows based on criteria in last column.
    By dlab85 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-31-2012, 05:10 PM
  3. [SOLVED] Copy Cells In One Column Based On Criteria In Another Column
    By hgteros in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-14-2012, 06:07 PM
  4. formula for max of one column based on criteria of another column
    By rclose in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-23-2012, 06:10 PM
  5. Copy Formula down the column based on data in the next column
    By karl_009 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2008, 09:48 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