Hello all and thanks in advance for any help I may get.

Here is what I am trying to do. A3 to F3 in the column headings.

They are as follows:
Store ID, Retailer, Last Name, First Name, Amount, and Contest. Each has its own formatiing and in B4 I have a combo box. What I would like to happen is after all required info is enter into row 4 I would like row 5 to take on the properties that row 4 had before the data was entered.

Make any sense?

Thanks
Brian