+ Reply to Thread
Results 1 to 4 of 4

Match Cell Value to Worksheet Name Then Copy/ Paste Range to Worksheet

  1. #1
    Registered User
    Join Date
    09-24-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Match Cell Value to Worksheet Name Then Copy/ Paste Range to Worksheet

    Hi,

    I'm in need of a code that will look at the cell values in sheet1, column A and match to the worksheet name. If a match is found I want to be able to copy the range in that row from Column B to Column O and paste it to the worksheet in the first empty row up from my totals row that starts in row 33.

    I've attached a sample workbook.

    Thanks in advance for any help!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Match Cell Value to Worksheet Name Then Copy/ Paste Range to Worksheet

    Hi,

    Try this code.
    Caveat: Make sure you are on Sheet1 when you run the code. I have not explicitly referenced the code.

    Please Login or Register  to view this content.
    Regards,
    Rudi

  3. #3
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,810

    Re: Match Cell Value to Worksheet Name Then Copy/ Paste Range to Worksheet

    Try:
    Please Login or Register  to view this content.
    Last edited by Mumps1; 05-31-2014 at 01:13 PM.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  4. #4
    Registered User
    Join Date
    09-24-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Match Cell Value to Worksheet Name Then Copy/ Paste Range to Worksheet

    Thanks for the help! It worked great!

+ 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. VBA Match Cell Range to Worksheet Name and copy/paste to respective worksheet
    By rlsublime in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-24-2014, 04:06 PM
  2. Find, Match, Copy Paste Value to another worksheet
    By vty in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-03-2013, 01:37 AM
  3. Vba code to copy and paste second visible cell to other worksheet range then the next
    By Justin25150 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2012, 09:03 AM
  4. Copy Range from Worksheet 2, Paste to Next Empty Row Worksheet 1
    By oOarthurOo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2010, 04:07 PM
  5. copy cell from a worksheet and paste to another worksheet
    By kingpeejay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2009, 10:35 PM

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