Hi, I'm working on a database and looking for a code: I want it copy if cell A2 is 1 I want it to copy the values of cells T48:X48 then transpose them and paste them onto a separate sheet under (below) 1 or whatever the value of what A2 contains. It should do the above only in the sheet that also corresponds to the value of cell G8. So if value in G8 on the original sheet is "gear" it should paste the values of T48:X48 in sheet "gear" under the value similar to that of cell A2.

I have made the values of A2 and G8 drop down lists. I want this Code to run every time any of these values are changed.