Inventory and product worksheet- copy row based on cell value to a new sheet

[Addiaddi1]

I am making this inventory and order workbook for my small business that I am starting. I’m having hard time coding a VBA that will copy the entire row to another sheet based on the cell value. Here below I am trying to clarify what I need exactly. Hope there is someone that can help me with this.

I have 5 sheets named as you can see in the photo.

“Front page” sheet- does not matter in this workbook

"Total" - Is the sheet where you can see all the products and quantity you have ordered.

“BB & TT”, “AA & TT”, “SS & GG” – are similar sheets with list of products that you can order as you can see here below.




“BB & TT”

“AA & TT”

“SS & GG”

When I insert a number into column H in sheet “BB & TT” , “AA & TT” , “SS & GG” I want the row to be copied to the sheet named “Total” where it get stacked up as you can see:

From this

To this

The quantity number you write in column H in sheets “SS & GG”, “BB & TT”, “AA & TT” and “Total” is the quantity of product you want to order. And please notice that all the data in those sheets are in data form.

I need to be able to go to sheet “SS & GG”, “BB & TT” and “AA & TT” and change the order quantity in column H and the sheet “Total” would then change also based on the new quantity number.

And if you are smart enough it would be amazing if you are able to write a code so I can also change the order quantity in column H in sheet “Total” and the number would then change in sheet “ SS & GG”, “BB & TT” or “AA & TT” based on the new quantity value.

Hope you can help me with this :D

 

[Fluff]

Duplicate Inventory list- copy row based on cell value to another sheet

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

 

[Addiaddi1]

Duplicate Inventory list- copy row based on cell value to another sheet

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

I thought it would be okay because this is a completely new form of my question with additional information and a more detailed explanation.
If not, I can delete this version. No problem.