I need help writing a macro to automate a specific set of actions. I have a range of multiple rows containing various component data (product description, quantity, unit pricing, and total pricing) for a specific product. At the bottom of the section, I have a summary with totals.
<tbody>
</tbody>
I want the macro to add a new Product (Product B) by copying and pasting all of the rows in Product A -- including the header -- two lines below the last component of Product A to create spacing between products.
When I run the macro again, it should create a new product (Product C) by copying and pasting all of the rows in Product B two lines below Product B and so on.
Any help on this is much appreciated.
Component Type | Component Description | QTY | Unit Cost | Total Cost |
Product A | ||||
Component 1 | ||||
Component 2 | ||||
Component 3 | ||||
Component 4 | ||||
Component 5 | ||||
Component 6 | ||||
Component 7 | ||||
Component 8 | ||||
Pricing Summary |
<tbody>
</tbody>
I want the macro to add a new Product (Product B) by copying and pasting all of the rows in Product A -- including the header -- two lines below the last component of Product A to create spacing between products.
When I run the macro again, it should create a new product (Product C) by copying and pasting all of the rows in Product B two lines below Product B and so on.
Any help on this is much appreciated.