+ Reply to Thread
Results 1 to 4 of 4

Command Button - move Row from Sheet1 to Sheet2

  1. #1
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Command Button - move Row from Sheet1 to Sheet2

    Hello,

    I have a userform for entering data to sheet1. What I need to do is find a row of data on Sheet1, populate my useform to make any changes needed and have another button to allow me to move that row to Sheet2, basically Cut & Paste. The way it is now I use "cmbFind" and then "cmbAmend" which I need, the reason for moving a row to Sheet2 is I need to move certain rows to what will be "History" (Sheet2) Attached is my complete code...

    Any help is greatly appreciated. Thanks

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Re: Command Button - move Row from Sheet1 to Sheet2

    Can anyone please look at this code and give me some tips? I would GREATLY appreciate it and would really help me out. Thanks in advance!

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Command Button - move Row from Sheet1 to Sheet2

    Can you please upload the sample file that you are using along with the code?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Re: Command Button - move Row from Sheet1 to Sheet2

    Hi Arlu1201

    Thanks for replying.... I was finally able to figure this out today and seems to be working. But I will be starting a new thread for the same project, different problem.

+ 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