+ Reply to Thread
Results 1 to 5 of 5

Copy and paste

  1. #1
    Registered User
    Join Date
    09-14-2011
    Location
    Nepal
    MS-Off Ver
    Excel 2007
    Posts
    98

    Copy and paste

    Hello All,

    I have a master sheet, where I update new extra data and copy recently entered data to new worksheet "Sheet3" for mail merge. I am using simply copy and paste command. Is it any other way to copy and paste recently entered data to sheet 3? Your suggestion is highly appreciated. Sample file is also attached herewith. Thank you.


    Indra
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Copy and paste

    Hi Indra Rai,

    Another way could be VBA (macro)... if you are fine with this, you need to define the "new extra data" i.e., is there any date or other identifier referring which one can identify new extra data, which would be copied to sheet 3 using macro. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    09-14-2011
    Location
    Nepal
    MS-Off Ver
    Excel 2007
    Posts
    98

    Re: Copy and paste

    Hello dilipandey,

    There is no such identifier but can be define or only highlighted part.

    Indra

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Copy and paste

    Ok..

    Created a little macro which will copy the highlighted rows from sheet 1 and append into sheet 3.
    So if you have selected cells a4 and a5, the rows 4 and 5 will get copied to sheet 3. Button is in cell A1. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-29-2012
    Location
    Gujrat, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Copy and paste

    hello,
    in my opinion
    > Right click on sheet in (footer option)
    > click to "move or copy"
    > select the sheet you need to copy
    > mark to "create a copy"
    > and click "OK"
    tray it,
    thanks,
    Web Development at techfreakdevelopers.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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