I can't figure out how to write the correct code for a button I have created.
Problem:
I have created a template for bidding jobs. I have formulas inserted from A12:V12 and I want to create a button that when pushed will create another row below the first. I want this row to basically copy all formulas in row 12 and add them to row 13. My hope is that I can create this template and every time a new bid item shows up I can click the "Add" button and a new row with all of my formulas will be created. I have dinked around with the code enough that I can get it to add a row but none of the formulas, lines, or functions transfer down.
Any suggestions on how to remedy this situation would be great, I may also want to mention that I am what some might call just below novice when it comes to excel code!
Problem:
I have created a template for bidding jobs. I have formulas inserted from A12:V12 and I want to create a button that when pushed will create another row below the first. I want this row to basically copy all formulas in row 12 and add them to row 13. My hope is that I can create this template and every time a new bid item shows up I can click the "Add" button and a new row with all of my formulas will be created. I have dinked around with the code enough that I can get it to add a row but none of the formulas, lines, or functions transfer down.
Any suggestions on how to remedy this situation would be great, I may also want to mention that I am what some might call just below novice when it comes to excel code!