Copy row size and clear content to next row

[Chris1976]

Hallo , could you please assist

I have a code below that with a attached workbook. The command button "Click to Create New CA Row" when clicked, copies rows 130, 131, 132 to a next open row below row 132. It copies the rows with exact size and keeps the text in rows 13 and 131, it clears row 132's content however.

There is also drop down boxes through data validation that when then drop down box is selected it allows me to select one certain content that is entered and linked to the top of the document

The problem I have is that when i click the command button it does not allow me to select the the value in the drop down box, it provides value of the cel below the source cell to which the data validation is set . the second problem is that it copies the command buttons which is correct to the next open rows but duplicates the command button , the more new rows is made the more copies of the command button it creates

the code is

Please Login or Register  to view this content.

[Chris1976]

Hi there, anyone that could provide some advice ?

[AlphaFrog]

Your example Book6 workbook does not have your macro code in it or a "Findings_Summary_Sheet"

The problem I have is that when i click the command button it does not allow me to select the the value in the drop down box, it provides value of the cel below the source cell to which the data validation is set .

I didn't understand that.

[Chris1976]

Hi AlphaFrog

Apologies, I now included the code and also the Finding_Summary_Sheet fro you perusal

to explain the info in cell E125, E127 / P125, P127 / Q 119, Q 123 is linked to the above inputs through Range B5:N13, these are simply linked through =. So if I would change a site name at the top in Cell C5, it will change the value in cell E125 and so on


Cell P132 has a data validation with Source being =C5 and so does U132, V,132 W132, X132, Y132, Z132 - These are all data validated through source = to a applicable cell in Range B5:N13

So what happens now when I click the "CLICK TO CREATE A NEW CA ROW" it

Firstly - Clears the content of Row 132 (bear in mind once clicked the next clear row would be 135 and so on, depending on how many of those tables I need for corrective actions the code will identify the previous )
Secondly - It copies a next table to exactly the same size (as rows 130. 131. 132) and formats with Text content of Row 130 and 131 to a second table. Bear in mind there must not be any blank cells in row A132:Z132, else it will not copy, or copies the next table all wrongly


So here is my problem, when I click the command button "Create a New CA Row" it does all that but if you go to the drop down boxes in Cells as explained above, it is as if the code chooses the next row from the linked cell above - So say the data validation source was = C5, when I click a second "Create New CA Row" the drop down data validation would now be linked to C6 and inserts that value in stead of reaming with the original source I have set the data validation to

I hope that makes better sense ?

[AlphaFrog]

Change the dropdown source to an absolute cell reference...

=$C$5

[Chris1976]

Cool thank you Alpha frog i will try that