Put column from old sheet into new sheet

I need to take a column from an old sheet and add it to an existing sheet as shown here http://screencast.com/t/wW4svpiCZP   I am pretty inexperienced with this so some hand holding would be greatly appreciated.
rtod2Asked:
Who is Participating?
 
royhsiaoCommented:
hi,

you can do the following:
1) open both worksheet, and make sure they are the same version like both are in .xlsx. If not use save as to save as xlsx.
2) highlight the column from old sheet and right click, click copy
3) go to the new sheet , high light the column you want it to be, right click, click "insert copied cells"
 
0
 
rtod2Author Commented:
The "sheets" are individual tabs inside the same xlsx file as shown there.  You can see that "insert copied cells" won't work because the individual rows are different.  There are more rows in the first sheet than in the second.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.