Put this in D6:

=IF(B6="","",B6)

then copy down to D250. The cells in column D will mirror what is in
column B.

Hope this helps.

Pete

On Nov 1, 2:40*am, 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,