Results 1 to 7 of 7

copy selected row and paste it to another sheet command button vba

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    copy selected row and paste it to another sheet command button vba

    Hi ,
    I am trying simple macro.
    I have sheet1 with column 1,2, & 3.
    Sheet2 is identical.

    There is a command button on sheet1.

    If I select in sheet1 ( A) column any row and press command button then selected row is deleted from sheet1.
    Pasted to sheet2 in next available row.
    And sheet1 rows shift up.

    Any suggestions and help please.
    Kind regards
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Command button to copy data from WB1 to WB2 based on selected value in WB2 vba
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-05-2014, 09:49 AM
  2. [SOLVED] VBA Code to copy all data from sheet 1 and paste it to sheet5 using a command button
    By Angnz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-10-2013, 10:06 PM
  3. [SOLVED] Simple Copy and Paste Command Button
    By j_gideon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-25-2013, 02:38 PM
  4. Using a command button to copy selected data to another worksheet
    By 02.flea in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-17-2012, 02:12 AM
  5. Replies: 2
    Last Post: 06-11-2012, 05:14 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