This will be an easy one for you folks, but I am a novice in VBA.

Starting in row 9 of sheet1, if there is a value in b9, copy the values in cells b9, c9, d9, g1 and g2 and paste special the values in the same order into the next blank row in sheet2 starting at cell a14. Continue this copy/pasting of data for all rows in sheet1 if there is data in column b for the range b9 through b15. The data copied from cells g1 and g2 will need the same for each record like $g$1 and $g$2$ in a standard formula.

Thanks in Advance for any help you folks can offer,

Scott