I want to be able to pick the cell using a number form another cell
so i start at c33 and if the number is 6 in the input cell so the range
selected would be c39.

Im using this method to in put data on stock picking sheet

a 3
b 4
c 0
d 1

what i wan to do i populate a cell with data based on the numbers. the first
item is 3 so i c33 c34 & c35 have that item listed then item b starts at
c36 and so on.