Put column from old sheet into new sheet

Posted on 2011-10-29
Last Modified: 2012-05-12
I need to take a column from an old sheet and add it to an existing sheet as shown here   I am pretty inexperienced with this so some hand holding would be greatly appreciated.
Question by:rtod2
    LVL 6

    Accepted Solution


    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"

    Author Comment

    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.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now