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
Bookmarks