Duplicating Macro (Sorry if this is a duplicate post)

**midwest trader** · 07-08-2014, 12:47 PM

Hello Everyone.
Sorry if this is a duplicate post. I thought I posted it earlier but its nor coming up in my post. On the attached document in sheet "Non Standard Quote". I want to be able to duplicate row 4 at my convenience. Some jobs have more different material types than others. I can just drag down and duplicate everything, except the macro check boxes. Is there a way to have this correspond with the cells on their row without having to go in and change them one at a time. Or does anyone know of a simpler way to keep duplicating what I have.

Thanks in advance.

**Tinbendr** · 07-10-2014, 09:09 AM

Or does anyone know of a simpler way to keep duplicating what I have.

Remove the checkboxes and replace with Validation list. You can enter static values for a list. So, instead of a range, you just add YES,NO. Or TRUE,FALSE.

When you copy the formulas down, it also copies the validation list.