=IF('Part 2'!C10="","","H,"&'Part 2'!C10&",allocation,"&TEXT('Part 2'!$F$9,"dd/mm/yy"))
=IF('Part 2'!C11="","","H,"&'Part 2'!C11&",allocation,"&TEXT('Part 2'!$F$9,"dd/mm/yy"))
=IF('Part 2'!C12="","","H,"&'Part 2'!C12&",allocation,"&TEXT('Part 2'!$F$9,"dd/mm/yy"))

Hi

i need to be able to copy the above, from A1 to BP1

but for the C to stick and the row number to go up 1

can any one help

thanks