How do I copy and paste visible cells in another column in the same worksheet with out the hidden cells copying also. If it can't be done is there an east macro to do the same thing?

You can use the Ctrl Key to select non contiguous ranges.

1) Select the range of cells to copy
2) Ctrl-G opens the Go to window
3) Select Visible cells only
4) Now copy and paste.

Video example (http://screencast.com/t/xr3p224jH6)