+ Reply to Thread
Results 1 to 5 of 5

Copy and Paste Problem

  1. #1
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Copy and Paste Problem

    Hello Friends.........

    i have uploaded a excel file and it contains 04 sheets

    i want a simple code for copy and paste

    code should run in entire workbook excluding "All_Merged" and "Sheet1"

    for example:- copy the first sheet's data and paste the data in "All_Merged"
    then code run in second sheet.......copy the data of second sheet and paste it in "All_Merged"
    then code run in third sheet..........copy the data of third sheet and paste it in "All_Merged"

    thats it
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Copy and Paste Problem

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Re: Copy and Paste Problem

    Thankyou works perfectly

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Copy and Paste Problem

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Copy and Paste Problem

    An alternate version:

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Replies: 6
    Last Post: 02-28-2018, 09:40 AM
  2. VBA Copy & Paste problem
    By fahadakbar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2015, 06:10 PM
  3. [SOLVED] Excel Macro - Copy & Paste (Font) problem & Delete Last Added Rows problem
    By LennartB in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-05-2015, 06:58 AM
  4. Copy / paste problem
    By bobpic in forum Excel General
    Replies: 2
    Last Post: 06-23-2014, 06:56 PM
  5. problem with copy / paste
    By michael143 in forum Excel General
    Replies: 1
    Last Post: 04-22-2012, 09:49 AM
  6. Replies: 3
    Last Post: 12-09-2005, 01:20 PM
  7. Replies: 1
    Last Post: 01-04-2005, 06:06 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