+ Reply to Thread
Results 1 to 4 of 4

Code to Copy from Sheet 1 and Paste to Sheet 2 (Paste as Numbers and as Formulas)

  1. #1
    Forum Contributor
    Join Date
    07-10-2022
    Location
    USA
    MS-Off Ver
    2021
    Posts
    190

    Code to Copy from Sheet 1 and Paste to Sheet 2 (Paste as Numbers and as Formulas)

    Hi,
    Ranges to Copy and Paste as Simple Numbers (Without Formula)
    I want such a code which should copy these ranges from sheet1 and then it should open a new sheet (sheet2) and paste this copied data in this sheet 2. The data should be pasted as Simple Numbers only without formulas. These are the Ranges which should be copied from sheet 1
    Please Login or Register  to view this content.
    Ranges to Copy and Paste with Same Formulas
    This code should also copy these ranges from sheet1 and then it should paste this copied data in this sheet 2. The data should be pasted with the same formulas as they were on sheet 1. These are the Ranges which should be copied from sheet1. For these Ranges Formulas should also remain same as they were on sheet1.
    Please Login or Register  to view this content.
    When i again Run this code then it should again copy these ranges from sheet1 and then it should open a new sheet (sheet3) and paste this copied data in this sheet 3. Same way, When i again Run this code then it should again copy these ranges from sheet1 and then it should open a new sheet (sheet4) and paste this copied data in this sheet 4. And so on,

    While pasting, cell Format should remain same.
    Please note that every cell copied from sheet1 should be pasted in the exactly same cells on sheet 2.

    Sample file is attached for more clarification
    Last edited by rexcel548562; 08-05-2022 at 04:30 AM.

  2. #2
    Forum Contributor
    Join Date
    07-10-2022
    Location
    USA
    MS-Off Ver
    2021
    Posts
    190

    Re: Code to Copy from Sheet 1 and Paste to Sheet 2 (Paste as Numbers and as Formulas)

    Hi,

    Can anybody Please solve my issue as explained in this thread. I will be very thankful to you

  3. #3
    Forum Contributor
    Join Date
    07-10-2022
    Location
    USA
    MS-Off Ver
    2021
    Posts
    190

    Re: Code to Copy from Sheet 1 and Paste to Sheet 2 (Paste as Numbers and as Formulas)

    Hi,

    Can anybody Please solve my issue as explained in this thread. I will be very thankful to you

  4. #4
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,095

    Re: Code to Copy from Sheet 1 and Paste to Sheet 2 (Paste as Numbers and as Formulas)

    Hello Rexcel,

    Perhaps this may help:-

    Please Login or Register  to view this content.
    I hope that this helps.

    Cheerio,
    vcoolio.

+ 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] Need a Code to Copy data from Sheet 1 and Paste to Sheet 2
    By rexcel548562 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2022, 01:13 AM
  2. [SOLVED] VBA code to copy and paste data in one sheet from multiple sheet and loop through
    By Farhasnat in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-24-2021, 07:11 AM
  3. VBA Code for Multiple sheet Pivot Table Data copy and paste to another sheet
    By neeraj1418 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2021, 06:46 AM
  4. Copy/Paste cell range from sheet 1 to sheet 2 in numbers match in reference columns.
    By trickedout in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-23-2016, 07:44 PM
  5. VBA code to search from different sheet > Copy the row > Paste on different sheet.
    By qpywsqp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-26-2013, 11:13 AM
  6. Replies: 1
    Last Post: 03-28-2013, 02:49 PM
  7. Sheet code to copy & paste a new row of Info to another sheet
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2012, 05:31 PM

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