I can do that, but is there not an easier way. i was wondering if
there was a way of doing it with say a macro in order so speed things
up. The problem is that the first list  (to copy  from) is a list,in
positions A1,A2,A3,A4 etc, but i want to put the values in every 9th
box on the next sheet.Since there are 250 products, i feel i will be
there for ever inputting the data. I was thinking maybe there was a
loop type macro available.