Hi,
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...