copying and pasting from one workbook to another

[RoOmIE]

ok so this is the code that i am having trouble with

in the col G i have #N/A and some numbers of different parts in inventory (on a spread sheet called results)

now what i would like is that if we have #N/A in column G it copies the following cells on the same line B, C, D, G, and H and copies them to another spread sheet
I want to past these into the respective columns on the (Final results spread sheet) meaning B,C, D,G and H

else #N/A is not in G (meaning there is a part number in column G) i would like it to copy the cells on the same line but this time cells E,F,G and H and then copy them to the final results spread sheet but this time have them shift over (E from results pasted in B Final results sheet, F pasted in C, G pasted in E and H pasted in F)

do it while there is no more text in G

i am not familiar too too much with the vba codeing so i'm asking for a little help