Results 1 to 1 of 1

Reference cell Date and populate cells on one workbook from another workbook

Threaded View

  1. #1
    Registered User
    Join Date
    04-25-2013
    Location
    Florida, USA
    MS-Off Ver
    Excel 2003
    Posts
    8

    Reference cell Date and populate cells on one workbook from another workbook

    I would like to reference the date in cell B2 of workbook “Processed Report” “Sheet1” and populate cells O13, P13, HI33, and NO33, from workbook Processed.xls.

    Workbook “Processed” Sheet “MAY” cell O13 value would come from workbook Processed cell C33.
    Workbook “Processed” Sheet “MAY” cell P13 value would come from workbook Processed cell B33.
    Workbook “Processed” Sheet “MAY” cell HI33 value would come from workbook Processed cell C34.
    Workbook “Processed” Sheet “MAY” cell NO33 value would come from workbook Processed cell C35.

    Note, The two files are located on different computers, the file Processed.xls is located on a shared drive.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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