Data layout still wrong

Column CU should be GP but is G.

Will work if you check the data

Enter a blank row and add this formula in I2 and drag across

=IF(MOD(COLUMN()-8,5)=0,5,(MOD(COLUMN()-8,5)))

G should always equal 2

VBA Noob

__________________
_________________________________________


Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters

Please remember to wrap code.

Forum Rules

Please add to your signature if you found this link helpful. Excel links !!!