+ Reply to Thread
Results 1 to 6 of 6

Inputbox ---> Cut Row ---> Paste to next blank row in specified sheet

  1. #1
    Registered User
    Join Date
    09-14-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    6

    Inputbox ---> Cut Row ---> Paste to next blank row in specified sheet

    Hi,

    Firstly i have been browsing as a non member for some time and pilfered a few bits here and there to perform minor tasks i wanted so thank you to all the community for that.

    I am trying to create a code that will allow me to enter what i am looking for (in this case an asset tag), once found it will select the entire row and cut it to the next blank row of the specified sheet. all within the same workbook.


    i have started a bit and had alot more than below but they all just kept failing. i am learning this as i go.....:
    Please Login or Register  to view this content.
    any help on this would be really appreciated.

    Thanks

    Paul

    *edit* in case you are wondering, all our asset tags start with D so i was using this as a way on confirming the correct search criteria has been entered.
    Last edited by DaDDy ICEPOC; 09-14-2012 at 11:00 AM.

  2. #2
    Registered User
    Join Date
    09-14-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Inputbox ---> Cut Row ---> Paste to next blank row in specified sheet

    attached is the sheet i am working on. Apologies column's C and D are empty but the contain sensitive data i would lose my job for.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-14-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Inputbox ---> Cut Row ---> Paste to next blank row in specified sheet

    ok so i tried to move this on a bit and have this but although i think i am specifying it to cus the row it is cutting the entire sheet!:

    Please Login or Register  to view this content.
    any idea's anyone?

  4. #4
    Registered User
    Join Date
    09-14-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Inputbox ---> Cut Row ---> Paste to next blank row in specified sheet

    i have updated the code now..... i can make it copy and move it no problem now but what i cant do is CUT and move it. could someone point me in the right direction for the cut part?

    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: Inputbox ---> Cut Row ---> Paste to next blank row in specified sheet

    Try this:
    Please Login or Register  to view this content.
    Post responsibly. Search for excelforum.com

  6. #6
    Registered User
    Join Date
    09-14-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Inputbox ---> Cut Row ---> Paste to next blank row in specified sheet

    Chippy you are gold mate

    works very nicely. only thing i noticed is that the search is case sensitive. is it easy to change that?

    also marked as solved and given rep

    **EDIT*** scratch that question on case sensitive. i was having a fat finger moment
    Last edited by DaDDy ICEPOC; 09-18-2012 at 05:37 AM.

+ 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