Manipulating Excel Data from different sheets/books

Posted on 2014-08-14
Last Modified: 2014-09-19
I have two excel books (office 2013).

The First Book has 600 names listed in column A. In column B it has data relating to mailbox sizes for the corresponding names in column A.

The Second Book has the same names but spread over 10 sheets (relating to the company they work for). The names are common in both books, (as in they are in the same format).

I am hoping to take the data in column B of the first excel book and input it into the various sheets in Book 2 using the name as the common element.

What's the best way to do this ?
Question by:paologiorgio
    1 Comment
    LVL 31

    Accepted Solution

    This is a simple case of VLOOKUP, in Book2 with multiple sheets, against each name on each sheet


    Probably easier to create the formula with selecting cells as you go rather than copying and pasting from here as I have used generic book and sheet names.
    Rob H

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    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

    26 Experts available now in Live!

    Get 1:1 Help Now