+ Reply to Thread
Results 1 to 6 of 6

Copy the selected cell row and paste in another sheet

  1. #1
    Registered User
    Join Date
    06-26-2015
    Location
    UK
    MS-Off Ver
    2013
    Posts
    6

    Copy the selected cell row and paste in another sheet

    Hi,

    Please help me on this one. When i select a cell(ex: A2 or c4 or B5) in a row in sheet 1, then that row should be copied to sheet 2. When i select another cell in someother row in sheet 1 then the earlier row should be removed in sheet 2 and currently selected cell row in sheet 1 should be copied to sheet 2.

    Thanks in advance

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,778

    Re: Copy the selected cell row and paste in another sheet

    Where is sheet 2 ??
    Is sheet 2 the name of the sheet ?
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    06-26-2015
    Location
    UK
    MS-Off Ver
    2013
    Posts
    6

    Re: Copy the selected cell row and paste in another sheet

    Hi PCI,

    Yes sheet 2 is name of the next sheet. Please help

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,778

    Re: Copy the selected cell row and paste in another sheet

    And what about the location where to put the row in sheet 2 ???

  5. #5
    Registered User
    Join Date
    06-26-2015
    Location
    UK
    MS-Off Ver
    2013
    Posts
    6

    Re: Copy the selected cell row and paste in another sheet

    Hello,

    I need to put the copied row in row 2 of sheet 2. Inspite of watever row i select from sheet 1, it should be pasted in row 2 of sheet 2.

    Thanks

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy the selected cell row and paste in another sheet

    Maybe:

    Please Login or Register  to view this content.

+ 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 selected row and paste it to another sheet command button vba
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-22-2014, 03:22 AM
  2. VBA formula to copy paste selected data from main sheet to new sheet
    By vbanoob123 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-24-2014, 12:28 PM
  3. [SOLVED] copy-paste-selected-cell-range-another-sheet
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-26-2013, 06:12 AM
  4. copy paste data with multiple selected ranges from sheet to sheet
    By sivdin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2011, 02:45 PM
  5. copy paste selected range from one sheet to another
    By sivdin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-10-2011, 06:57 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