+ Reply to Thread
Results 1 to 2 of 2

Help with table - Copy rows, delete rows, reset table & copy table

  1. #1
    Registered User
    Join Date
    10-15-2019
    Location
    London
    MS-Off Ver
    2019
    Posts
    1

    Help with table - Copy rows, delete rows, reset table & copy table

    Hello I am new to excel VBA, I have done some VBA but not enough within excel. I have attached an image ei require to add a few macros/vba's the work by double clicking a cell. I show buttons in the image, but I would rather be double clicking cells for the rule to run.

    I require the following functions if possible.

    1. Add row - Add the entire row, copy and insert. This must also shift the other cells down so that it will still allow me to insert other row using other commands.

    2. Delete rows - if there are 2 or more rows in any section, I require to be able to delete any row, but only 2 or more and not th original on, ie. if a new row is created a delete code is also created.

    3. Copy table for a second quote. Copy all elements including point 4. to the right of this quote, and this to be repeated to the right for every other quote and for the this cell to be continually moving.

    4. Reset table with a warning message to bring the table to what is shown. Bare in mind column A in the white space is a vloopup formula that is looking at index 1? 1 being the first value in the column on another sheet.

    Screenshot 2019-10-15 at 10.10.53.png

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Help with table - Copy rows, delete rows, reset table & copy table

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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: 0
    Last Post: 08-31-2018, 08:21 AM
  2. [SOLVED] Macro to Autofilter a table and delete filtered rows: Error 1004 cannot alter table
    By brytsyt in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-05-2018, 04:57 AM
  3. copy rows from table with criteria and paste to end of another table
    By PierrePolux in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2018, 08:03 PM
  4. Replies: 0
    Last Post: 02-01-2017, 06:07 PM
  5. [SOLVED] Vba to copy Filtered rows from table to another table
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2016, 06:46 AM
  6. macro to copy table from sheet1 to sheet2 (# of rows in table may vary everytime)
    By arkharova.s in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2014, 03:18 AM
  7. Copy and paste certain rows of a table to create a new table
    By redhawk87 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-12-2013, 12:37 PM

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