+ Reply to Thread
Results 1 to 1 of 1

Extract information from external closed file according to a date

  1. #1
    Registered User
    Join Date
    06-27-2011
    Location
    Argentina
    MS-Off Ver
    Excel 2007
    Posts
    12

    Extract information from external closed file according to a date

    Hi Mates,

    I have a Dashboard who needs to show the Top Ten Overtime Spenders.

    This data is allocated on other file, with the following format:

    ='C:\Users\leandro.m.broffoni\Desktop\DWP\02- CADO Overtime Report\CADO Jun''11.xlsx]JSA Evidence Management'!AJ6


    The data in red needs to change according to the date (file) and the project (sheet)

    I need an formula on the overtime section that works automatically.

    Attached are my file.
    Attached Files Attached Files

+ Reply to Thread

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