Hi
Not sure what you mean but if you put in B5 =B2, it does't matter what is in B2
it will be in B5
HTH
John
"malik" wrote in message
...
hi

i have a worksheet number in cell A eg 6 and a number in cell B1 eg 100, i
want to have the number 100 in cell B2 to B5 automatically, the number in
cell A is always a single digit number but in cell B it is always two or
three digit number. can i do this? thanks