Copying Column

[grifdoogindoggy]

Is there a way to automatically copy and paste a column from one sheet to another formulaically? (not using a macro)

That is to say, if I copy and paste data into sheet A, a column of my choosing automatically populates in sheet B.

Thank you

 

[Fluff]

Copy and paste no, but you could put =A1 into sheet B & copy down.