Copy one column to another worksheet

[JimLau]

I have data in a worksheet named "Log". I want to copy an entire multiple column from "Log" to another worksheet named "BackOrders".

[FDibbins]

if what you want to do is as simple as it sounds (probably isnt tho), high-light the column letter/s, copy, go to the next work sheet and paste (or paste values if there are formulas you dont want carried over)

let me know if thats what you wanted?

[JimLau]

I need it do it automatic when the source worksheet is updated. It also only needs to copy the row when a cell has a certain value.

[FDibbins]

yup, thought it couldnt be that simple. that needs VBA, and i am real weak in that area