i tried that kept getting message formula error. what I need is acutally the
numbers i enter in column L to repeat into coloum R; then Column S to repeat
to column V, each row from 6 to 250


"JENAB" wrote:

i want to enter a # in one column, then need that number to appear in
another. ie: Column B & D are the same i enter 55 in B and 55 will appear in
D. I cant seem to find the formula. Also need the entire column from row 6
to 250. Thanks for any suggestions,