+ Reply to Thread
Results 1 to 5 of 5

Copy range to sheet with same name as specific cell

  1. #1
    Registered User
    Join Date
    03-20-2014
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    10

    Copy range to sheet with same name as specific cell

    Good afternoon, I hope the title reflects my query well enough.

    I have found similar questions, most of which search through a range and when they find a match copy that row to a sheet with the same name.

    My query seems simpler but I cannot seem to find code that I understand well enough to adjust to my needs.

    attached is an example workbook, a snippet of my actual workbook.

    on the "Summary page", I would like C5 through to F5 copied to the next row, of the sheet which is named at J2.

    J2 on the main workbook is a VLOOKUP which populates it with a staff members name, in the example I have just written one in text. The name at J2 will always match the name of a sheet in the workbook.

    You can probably see on the sheet "Bland Catherine" where I would like the range copied, but it will be copied to the next available row from C5 onwards. I do not wish for data to be overwritten, so to copy to the next available row.

    Thank you in advance

    Copy to Sheet test.xlsx

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Copy range to sheet with same name as specific cell

    sguyott,

    Will this work?

    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Copy range to sheet with same name as specific cell

    Try this code........
    Please Login or Register  to view this content.
    For detail see the attached sheet.
    Attached Files Attached Files
    Last edited by sktneer; 04-04-2014 at 09:17 AM.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Registered User
    Join Date
    03-20-2014
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Copy range to sheet with same name as specific cell

    Thank you stkneer, that does exactly what I was asking for.

    Sorry Arkadi, although that does indeed copy to the last row, it does not search for the worksheet first as requested. Thank you for your effort though.

  5. #5
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Copy range to sheet with same name as specific cell

    Hey no probs, but it does take the sheet name from the Summary page, cell 2, 10 is J2...

+ 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 and paste range as values to specific sheet/range
    By lukestkd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-06-2014, 09:48 PM
  2. Check cell Value in range and copy specific cells to another sheet
    By jmethejedi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-08-2013, 06:25 PM
  3. Copy and paste specific range to date specific range in alternate sheet
    By alanalmarza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 08:29 AM
  4. Copy specific range from sheet to another if condition in cell met
    By Zagadka in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-28-2012, 11:42 AM
  5. Replies: 2
    Last Post: 07-17-2011, 05:28 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