Results 1 to 2 of 2

Thread: VBA To copy certain cells from row if two cells match to another sheet

  1. #1

    VBA To copy certain cells from row if two cells match to another sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Good Morning

    I am after a formula/macro that will copy a row of data if two certain cells match.

    In sheet 25 (Called 'All Orders') I have headings in the columns A-O. The headings are in row 2 and the data starts in row 3.

    Sheet 26 (Called 'Wolds') is set out in the exact same lay out.

    What I need to do is; If Column E in 'All Orders' matches the text in cell A1 in 'Wolds' then copy the row of information from 'All Orders' to 'Wolds'

    In Column 'P' in 'Wolds' I have a code to number each order (W1, W2, W3...ETC.) I need this row to remain.

    In previous attempts at doing this macro every time it ran it would re add all the orders so some were being duplicated several times on the 'wolds' sheet. I am looking for new orders to be added to the previous one when the macro is run

    Thank you.

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,480
    Articles
    0
    Excel Version
    365
    please post links to all locations you have cross posted to.
    Some light reading too: http://www.excelguru.ca/content.php?...-cross-posters

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •