This is what I'm after I'm having some trouble working out when the code copies row 5 my formulas get messed up. They are below
This is the formula in row 5 before running the code.
=IF(ISBLANK('C Section'!G11),"","A"&'C Section'!G11&"P1")& IF(ISBLANK('C Section'!H11),"",'C Section'!H11&"P1")& IF(ISBLANK('C Section'!I11),"",'C Section'!I11&"P1")& IF(ISBLANK('C Section'!J11),"",'C Section'!J11&"P1")& IF(ISBLANK('C Section'!K11),"",'C Section'!K11&"P1")& IF(ISBLANK('C Section'!L11),"",'C Section'!L11&"P1")& IF(ISBLANK('C Section'!M11),"",'C Section'!M11&"P1")& IF(ISBLANK('C Section'!N11),"",'C Section'!N11&"P1")& IF(ISBLANK('C Section'!O11),"",'C Section'!O11&"P1")& IF(ISBLANK('C Section'!P11),"",'C Section'!P11&"P1")& IF(ISBLANK('C Section'!Q11),"",'C Section'!Q11&"P1")& IF(ISBLANK('C Section'!E11),"",('C Section'!E11)&("G"))
This is the formula in row 5 after running the code.
=IF(ISBLANK('C Section'!G12),"","A"&'C Section'!G12&"P1")& IF(ISBLANK('C Section'!H12),"",'C Section'!H12&"P1")& IF(ISBLANK('C Section'!I12),"",'C Section'!I12&"P1")& IF(ISBLANK('C Section'!J12),"",'C Section'!J12&"P1")& IF(ISBLANK('C Section'!K12),"",'C Section'!K12&"P1")& IF(ISBLANK('C Section'!L12),"",'C Section'!L12&"P1")& IF(ISBLANK('C Section'!M12),"",'C Section'!M12&"P1")& IF(ISBLANK('C Section'!N12),"",'C Section'!N12&"P1")& IF(ISBLANK('C Section'!O12),"",'C Section'!O12&"P1")& IF(ISBLANK('C Section'!P12),"",'C Section'!P12&"P1")& IF(ISBLANK('C Section'!Q12),"",'C Section'!Q12&"P1")& IF(ISBLANK('C Section'!E12),"",('C Section'!E12)&("G"))
And the formula in row 6 is after running the code
=IF(ISBLANK('C Section'!G13),"","A"&'C Section'!G13&"P1")& IF(ISBLANK('C Section'!H13),"",'C Section'!H13&"P1")& IF(ISBLANK('C Section'!I13),"",'C Section'!I13&"P1")& IF(ISBLANK('C Section'!J13),"",'C Section'!J13&"P1")& IF(ISBLANK('C Section'!K13),"",'C Section'!K13&"P1")& IF(ISBLANK('C Section'!L13),"",'C Section'!L13&"P1")& IF(ISBLANK('C Section'!M13),"",'C Section'!M13&"P1")& IF(ISBLANK('C Section'!N13),"",'C Section'!N13&"P1")& IF(ISBLANK('C Section'!O13),"",'C Section'!O13&"P1")& IF(ISBLANK('C Section'!P13),"",'C Section'!P13&"P1")& IF(ISBLANK('C Section'!Q13),"",'C Section'!Q13&"P1")& IF(ISBLANK('C Section'!E13),"",('C Section'!E13)&("G"))
I need to make it like this
This is the formula in row 5 after running the code
=IF(ISBLANK('C Section'!G11),"","A"&'C Section'!G11&"P1")& IF(ISBLANK('C Section'!H11),"",'C Section'!H11&"P1")& IF(ISBLANK('C Section'!I11),"",'C Section'!I11&"P1")& IF(ISBLANK('C Section'!J11),"",'C Section'!J11&"P1")& IF(ISBLANK('C Section'!K11),"",'C Section'!K11&"P1")& IF(ISBLANK('C Section'!L11),"",'C Section'!L11&"P1")& IF(ISBLANK('C Section'!M11),"",'C Section'!M11&"P1")& IF(ISBLANK('C Section'!N11),"",'C Section'!N11&"P1")& IF(ISBLANK('C Section'!O11),"",'C Section'!O11&"P1")& IF(ISBLANK('C Section'!P11),"",'C Section'!P11&"P1")& IF(ISBLANK('C Section'!Q11),"",'C Section'!Q11&"P1")& IF(ISBLANK('C Section'!E11),"",('C Section'!E11)&("G"))
This is the formula in row 6 after running the code
=IF(ISBLANK('C Section'!G12),"","A"&'C Section'!G12&"P1")& IF(ISBLANK('C Section'!H12),"",'C Section'!H12&"P1")& IF(ISBLANK('C Section'!I12),"",'C Section'!I12&"P1")& IF(ISBLANK('C Section'!J12),"",'C Section'!J12&"P1")& IF(ISBLANK('C Section'!K12),"",'C Section'!K12&"P1")& IF(ISBLANK('C Section'!L12),"",'C Section'!L12&"P1")& IF(ISBLANK('C Section'!M12),"",'C Section'!M12&"P1")& IF(ISBLANK('C Section'!N12),"",'C Section'!N12&"P1")& IF(ISBLANK('C Section'!O12),"",'C Section'!O12&"P1")& IF(ISBLANK('C Section'!P12),"",'C Section'!P12&"P1")& IF(ISBLANK('C Section'!Q12),"",'C Section'!Q12&"P1")& IF(ISBLANK('C Section'!E12),"",('C Section'!E12)&("G"))
And the formula in row 7 is after running the code
=IF(ISBLANK('C Section'!G13),"","A"&'C Section'!G13&"P1")& IF(ISBLANK('C Section'!H13),"",'C Section'!H13&"P1")& IF(ISBLANK('C Section'!I13),"",'C Section'!I13&"P1")& IF(ISBLANK('C Section'!J13),"",'C Section'!J13&"P1")& IF(ISBLANK('C Section'!K13),"",'C Section'!K13&"P1")& IF(ISBLANK('C Section'!L13),"",'C Section'!L13&"P1")& IF(ISBLANK('C Section'!M13),"",'C Section'!M13&"P1")& IF(ISBLANK('C Section'!N13),"",'C Section'!N13&"P1")& IF(ISBLANK('C Section'!O13),"",'C Section'!O13&"P1")& IF(ISBLANK('C Section'!P13),"",'C Section'!P13&"P1")& IF
(ISBLANK('C Section'!Q13),"",'C Section'!Q13&"P1")& IF(ISBLANK('C Section'!E13),"",('C Section'!E13)&("G"))
and so on for each row after that if the command button is used.
Any help would be great thanks,Matt