+ Reply to Thread
Results 1 to 3 of 3

Macro to move row into a table in another sheet

  1. #1
    Registered User
    Join Date
    06-06-2019
    Location
    Cyprus
    MS-Off Ver
    365
    Posts
    10

    Question Macro to move row into a table in another sheet

    Looking for a pretty simple macro that would copy the entry in the first sheet, paste it into an empty row of the table on the 2nd sheet and then delete it from the entry page, preparing it for another entry.
    The trigger has to be a macro in the button.
    I have a macro that acts similarily, but not exactly how i want it and even after fiddling with it for a while i couldn't make it do what i want.
    Please Login or Register  to view this content.
    Workbook example attached.
    Thank you very much!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    862

    Re: Macro to move row into a table in another sheet

    Hello,

    I have attached the file with the following code under the button click:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

  3. #3
    Registered User
    Join Date
    06-06-2019
    Location
    Cyprus
    MS-Off Ver
    365
    Posts
    10

    Re: Macro to move row into a table in another sheet

    Amazing!
    Exactly what i wanted!
    Multumesc frate! (hope that's correct Dx)
    You should change your name to flash for the speed of that reply

+ 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. Move row from one table to another on the same sheet based on cell value
    By Ghostrider757 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-30-2022, 12:48 AM
  2. [SOLVED] Move Row from a Table in one sheet to a Table in another sheet depending on cell value
    By peterchclarke in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-31-2019, 08:44 AM
  3. Macro to move a selected row from one table to another table
    By heyryy in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-05-2018, 12:20 PM
  4. Move Table to another Sheet
    By ionelz in forum Excel General
    Replies: 1
    Last Post: 10-12-2018, 10:44 PM
  5. Replies: 2
    Last Post: 01-30-2017, 03:25 PM
  6. [SOLVED] Macros To Move Multiple Rows To Another Sheet And Macro To Move Single Rows To DAX Table
    By jcaynes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 05:08 PM
  7. Excel 2007 : How to move table data from one sheet to another?
    By aboveliquidice in forum Excel General
    Replies: 1
    Last Post: 08-18-2011, 10:09 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