+ Reply to Thread
Results 1 to 4 of 4

Copy and paste values from one sheet to another if criteria is met

  1. #1
    Forum Contributor
    Join Date
    03-14-2015
    Location
    Mexico
    MS-Off Ver
    365
    Posts
    279

    Copy and paste values from one sheet to another if criteria is met

    Hi i am totally new to vba but decided to post here looking for some help.
    On the attached file you can see 2 sheets, the "Source" sheet has information that i need to paste on sheet "May" based on Company Name from Column "A" (sheet MAY). If Company name from sheet "source" is found in "May" sheet then, search every single "Item" from sheet "source" column "C" in sheet "May" column "A" and copy and paste QTY and PRICE accordingly as shown in my file.

    Thanks in advance of any kind help.
    Attached Files Attached Files
    Last edited by fabian_76; 06-16-2017 at 01:15 AM.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    Re: Copy and paste values from one sheet to another if criteria is met

    Hi fabian_76

    Is this what you are trying to achieve...Populate May from Source...Right?
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    03-14-2015
    Location
    Mexico
    MS-Off Ver
    365
    Posts
    279

    Re: Copy and paste values from one sheet to another if criteria is met

    Thank you Sintek, it did work perfectly!! I am surprised that I was able to shorten my workload.

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    Re: Copy and paste values from one sheet to another if criteria is met

    Pleasure...thanks for rep +

+ 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. Copy paste Values based on criteria
    By toci in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 04-15-2016, 08:29 AM
  2. Search row with criteria in all sheet, copy rows and paste in new created sheet
    By dekueb in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-24-2013, 01:42 PM
  3. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  4. Copy and Paste Values Base On Criteria
    By allan.90 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-03-2012, 01:56 PM
  5. Copy row and paste at bottom of sheet if criteria is met?
    By juniperjacobs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2010, 06:08 PM
  6. Copy and paste from one sheet to another if the criteria met
    By wali in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-12-2009, 04:25 PM
  7. copy and paste values based on a criteria
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 11-15-2008, 11:35 AM

Tags for this Thread

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