Excel - Costing

[GKPByDesign]

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. The price list I have is generated from inventor, hence posting here.

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.

[bradeneuropeArthur]

Hi,

Do you have an example?

I don't see any attachments!

Regards,

[GKPByDesign]

attached 

[bradeneuropeArthur]

Hi,

Why aren't you using the excel functionality selves for:

 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 the 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.

The following could be programmed:

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.

With the macro recorder in Excel you could record the macros and use the code for what you need it for!

Regards

[GKPByDesign]

I upstaged how to use excel, but I wanted to make it work more like an interactive gannt chart. I think I may have have to accept the copy and insert function, along with the other features. I am trying to eliminate the need for as much manual entry as possible, so that the form is dummy proof.