+ Reply to Thread
Results 1 to 4 of 4

VBA to Copy & paste values from one sheet to another based on criteria.

  1. #1
    Registered User
    Join Date
    12-16-2008
    Location
    Blackpool, UK
    MS-Off Ver
    2003, 2007, 2010
    Posts
    54

    VBA to Copy & paste values from one sheet to another based on criteria.

    Good Morning all, I could use some help creating vba code to copy columns O and P from sheet “work” to sheet “Print” based column N being either “Premier League”, “Championship”, “League One”, “League Two”, or “Vauxhall Conference” and paste values into the relevant columns in the Print sheet.

    The data will be changing each week and each league will grow or shrink, I was thinking the best way to go about this is to look for criteria in column N then copy O:P then past values in Print sheet in the next available cell starting at A3 for “Premier League”, D3 for “Championship” etc.....

    Any help for this would be greatly appreciated as I am stumped as to where to start.

    Thanks
    Attached Files Attached Files
    Last edited by rossi_69; 09-05-2018 at 07:02 AM.

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: VBA to Copy & paste values from one sheet to another based on criteria.

    I had to change the header on the Print sheet to "League Two" instead of "League 2" to get this to work better. Attached has a macro in Module1 which should do what you want.

    WBD
    Attached Files Attached Files
    Office 365 on Windows 11, looking for rep!

  3. #3
    Registered User
    Join Date
    12-16-2008
    Location
    Blackpool, UK
    MS-Off Ver
    2003, 2007, 2010
    Posts
    54

    Re: VBA to Copy & paste values from one sheet to another based on criteria.

    Thank you WBD that Is exactly what I needed to do, and it is seamless and quick, i never in a 100 years would have been able to reason that out.

    Thanks again.

    Rossi

  4. #4
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: VBA to Copy & paste values from one sheet to another based on criteria.

    No problem. Glad it's what you wanted.

    WBD

+ 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] VBA to copy & paste VALUES based on criteria
    By stacymyers11 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-29-2018, 10:36 PM
  2. Help with VBA/Macro to copy and paste values based on criteria
    By Bhaz in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-04-2018, 10:43 AM
  3. [SOLVED] Copy and paste values from one sheet to another if criteria is met
    By fabian_76 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2017, 06:28 AM
  4. Copy paste Values based on criteria
    By toci in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 04-15-2016, 08:29 AM
  5. Copy and Paste Rows based on Criteria onto another sheet and sort based on oldest item
    By Kushal8684 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2013, 05:37 AM
  6. [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
  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

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