I have a list from a1:a200

I want it so that if any values anywhere in that list are entered the
they should be copied and pasted in the b column starting at b1.

Eg if a5 = 10 and a27 = hello

B1 = 10
B2 = hello

any idea's

--
Message posted from http://www.ExcelForum.com