+ Reply to Thread
Results 1 to 2 of 2

Macro which moves any row from a Table to a Sheet and udpates content?

  1. #1
    Registered User
    Join Date
    01-18-2021
    Location
    Italy
    MS-Off Ver
    365
    Posts
    22

    Macro which moves any row from a Table to a Sheet and udpates content?

    Hello everyone,
    I would like to make a macro which lets me move one row (it mustn't necessarily be the first or the last one) from the Table set in"Sheet2" to the one set in "Sheet1".
    As you can see, the table in "Sheet1" does not have the Table Format like the one in ""Sheet2. That is because I will have to join some cells in the future...

    Additionally, I would like to update the content of the cells (I colored them in my example file) to the "Analyzed" state.

    May you help me, please?

    Edit:
    My apologies. I always try to pay attention to the rules, but this time I forgot an important one.

    This is the link to the forum in which I first asked this question: https://chandoo.org/forum/threads/ho...a-sheet.45993/

    I will continue writing there, too, because I had actually asked for help to learn how to make the macro step by step and already started receiving help.
    In this thread I asked an actual macro, because I need it to facilitate my work and I don't know how much time I will need to learn.
    Attached Files Attached Files
    Last edited by ifritaeon61; 03-25-2021 at 02:57 AM.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Macro which moves any row from a Table to a Sheet and udpates content?

    - removed as OP posted links -
    Last edited by Marc L; 03-25-2021 at 05:23 PM.

+ 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. [SOLVED] How can I get my Macro to set a range when it moves to a new sheet
    By Mr House in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2019, 08:40 AM
  2. Replies: 2
    Last Post: 12-24-2018, 11:27 AM
  3. Cell content over watermark moves depending on zoom
    By tstabile in forum Excel General
    Replies: 1
    Last Post: 09-17-2018, 02:16 PM
  4. [SOLVED] Macro that moves rows to another sheet.
    By Ricksterr94 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2014, 07:01 PM
  5. Plz HELP:Have Macro that moves rows to other sheet but need it to delete later row
    By frank521 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2013, 03:46 PM
  6. [SOLVED] Need help with Macro that moves row to another sheet
    By audioboxer in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-23-2013, 05:34 PM
  7. Problems creating a time macro that moves data from one sheet to another.
    By Sanorah in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2012, 08:27 AM

Tags for this Thread

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