importing columns

[ANTiSEEN]

How can all the values from one column without putting the individual lookup
in it?

I want B3:B53 to be the same on 2 different worksheets, and only have to
enter the data once.

 

[Don Guillett]

one way is to put
=source!b3
in a cell on the destination sheet and copy down