• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

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.
0
rtod2
Asked:
rtod2
1 Solution
 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now