+ Reply to Thread
Results 1 to 6 of 6

Vba copy range from sheet 1 and paste values within a range on sheet 2

  1. #1
    Forum Contributor
    Join Date
    11-03-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    246

    Vba copy range from sheet 1 and paste values within a range on sheet 2

    Hi,
    I am looking to copy a range ("Y9:AH9") from sheet 1,
    and paste values into the next empty row within a range ("C5:L33,C48:L76") on sheet 2.

    Your help is really appreciated.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Vba copy range from sheet 1 and paste values within a range on sheet 2

    Hi,

    You might use a loop like this
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Contributor
    Join Date
    11-03-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    246

    Re: Vba copy range from sheet 1 and paste values within a range on sheet 2

    Many thanks, can you change the code so it pastes the values only into sheet 2 please, it is copying the formulas.

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Vba copy range from sheet 1 and paste values within a range on sheet 2

    Certainly- change this
    Please Login or Register  to view this content.
    to this
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    11-03-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    246

    Re: Vba copy range from sheet 1 and paste values within a range on sheet 2

    Brilliant, thank you so much

  6. #6
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Vba copy range from sheet 1 and paste values within a range on sheet 2

    You're welcome.

+ 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] Help! - Copy Range (Sheet1,A10:F50), Paste Range (Sheet 2,A1:F41), Offset Range & Repeat
    By cjtimmer in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-30-2015, 06:27 PM
  2. [SOLVED] Copy Paste a Range of Values from a Different Sheet Based on Value Entered in Cell
    By hamidxa in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-13-2015, 04:53 PM
  3. [SOLVED] copy range and paste values only to another sheet in next empty row
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2015, 05:08 AM
  4. [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
  5. Copy variably sized range and paste values in another sheet
    By Masun in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-27-2013, 06:03 AM
  6. Check if Date is in Range, Copy row values and paste into new sheet
    By learning123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-12-2012, 03:11 PM
  7. Copy paste a range of values into a different excel sheet
    By Hugopellegrini in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2012, 05:15 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