sheet to sheet data transfer

[jlahey1]

I know that I can take data from one sheet cell and input it into a cell in another sheet (Sheet1!b22). But, I don't know if I can take an ENTIRE COLUMN of data from one sheet to another sheet. Any help? Thanks

 

[DonkeyOte]

yep - use record to show you the code...record what you want to do and look at the VB. That simple - here would be an example...

Sheets("sheet1").select
Columns("M:M").Select
Selection.Copy
Sheets("sheet2").select
Columns("J:J").Select
Selection.Insert Shift:=xlToRight

 

[jlahey]

Thank you so much for your reply. This message board is incredible, particularly with folks like you who are so prompt. Thank again for your help.