+ Reply to Thread
Results 1 to 7 of 7

Move(Cut/Paste) from one sheet to other sheet with macro

  1. #1
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Move(Cut/Paste) from one sheet to other sheet with macro

    Hi I need help to a macro, which can cut/Paste from sheet "Pastin" to Sheet "Robot".
    The input in sheet Pastin is veritical and the the result is in a row horiontsal.
    There can be no references between the names for the columns or rows, only the cell to move.
    I would like it to be so when I run the macro it example move it to sheet robot from row A3, and if I do again it make the next one from Row A4.
    What I want to move can be seen in below.
    Cell on the left is sheet "Pastein"
    and cells on the right is sheet "Robot"
    Special is that one move have to be taken from on cell comma separated input, so it goes to sheet "Robot" for each text/number, between the comma.
    I have attached a test sheet to work with also.

    Sincerely
    Abjac

    the move.Cut/Paste


    Please Login or Register  to view this content.
    Have a look at the test sheet also thanks
    Attached Files Attached Files
    Last edited by abjac; 07-24-2014 at 06:10 AM.

  2. #2
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Move(Cut/Paste) from one sheet to other sheet with macro

    Saw just now I have switzed the names in the test sheet. Please change so sheet Robot will be Pastein and Pastein will be Robot.
    Sorry my mistake thanks

    Abjac

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Move(Cut/Paste) from one sheet to other sheet with macro

    Try:
    (but before make sure you will see anything in row 3 - now it is formatted to be invisible :-P)
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

  4. #4
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Move(Cut/Paste) from one sheet to other sheet with macro

    HI Kaper and thanks. I don't know what you mean with invisible. I think its formatted as text. I tried you code and it didn't copy anything there. But maybe I just misunderstand some. If so could you upload a test sheet here.

    Sincerely

    Abjac

  5. #5
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Move(Cut/Paste) from one sheet to other sheet with macro

    Ok I think I got it Kaper. I changed the sheets name the error I made in the test sheet. But I still have some error which is not correct. If you look at the list I showed here. B4,B12, B21 and B22 shall not be included. And it make some incorrect in the list. Don't know if its possible to specify this in the macro.

    Please have a look.

    Sincerely

    Abjac

  6. #6
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Move(Cut/Paste) from one sheet to other sheet with macro

    Quote Originally Posted by abjac View Post
    I don't know what you mean with invisible. I think its formatted as text.
    Text with white font !!!
    try simple (but not elegant) solution:
    Please Login or Register  to view this content.
    As you see, I used most of the previous code
    Attached Images Attached Images
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Move(Cut/Paste) from one sheet to other sheet with macro

    Hi. Kaper. I needed to change the name in the sheet so Robot was Pastein and Pastein was Robot hehehe, But I tried your code and its working brilliant really. No need in this case for a nice code, but it works just perfect. So thanks allot really appreciate it.
    Thanks allot
    Have a nice day

    Sincerely Abjac

    My ending code.

    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. Replies: 2
    Last Post: 10-09-2012, 04:40 PM
  2. Macro to move rows from one sheet to another sheet based on a cell vaule
    By d55272 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-09-2012, 03:33 PM
  3. [SOLVED] Copy, paste, then move to a new sheet.
    By Cyberpawz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2012, 02:12 PM
  4. Macro: Count rows in sheet A, copy count in sheet B, paste offset in sheet A
    By Agent:Orange in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-19-2011, 07:56 AM
  5. Macro - Move information from Sheet 1 to Sheet 2
    By Barbosa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-14-2006, 04:17 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