+ Reply to Thread
Results 1 to 3 of 3

Populating a cell with data from another cell in a different workbook

  1. #1
    Registered User
    Join Date
    12-13-2013
    Location
    Detroit
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Populating a cell with data from another cell in a different workbook

    I am entering data into one workbook 1 (WB1) that contains a worksheet for every month. I manually extract some of the data from WB1 and put it into workbook 2 (WB2), which also contains a worksheet for every month. Is there a way to populate WB2 from WB1? For example, I want cell B5 from WB1 to automatically populate B5 in WB2, and so on. I have to update this every day and would like to way to automate it to cut down on data entry errors since they need to match. And both of these files are stored in SharePoint for others to access if need be. I don’t know if that matters or not.

    I have attached a sample of the workbooks (yet only have one month in each of these wb).
    Attached Files Attached Files

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Populating a cell with data from another cell in a different workbook

    Are you able to provide more parameters for what you'd like to copy over?

    Functions such as SUMPRODUCT could be used to accomplish this and it does not require your source WB to be open. You'd simply define the target variable and range, and then Updates Links everytime you open WB2.

    For example =SUMPRODUCT((.../[WB1.xlsx]December2013!A4:A34=A4)*(.../[WB1.xlsx]December2013!B4:B34)) would give the value of Column B from WB1 when the date in A on WB2 matches the date on WB1.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Populating a cell with data from another cell in a different workbook

    VLOOKUP will also work on closed workbooks
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Populating ranges of data using one reference cell.
    By davecleaves in forum Excel General
    Replies: 1
    Last Post: 07-19-2011, 05:21 PM
  2. Populating one cell data based on another cell value
    By vampyr07au in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2011, 11:08 AM
  3. Populating array from Cell data
    By Aussiexile in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2011, 05:57 PM
  4. Populating a cell based on combobox data
    By mrdata in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-18-2006, 05:29 PM
  5. looking up data in another column & populating another cell
    By Manda in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-08-2006, 02:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1