Results 1 to 3 of 3

Create Rule to show, in some form, if a SEPARATE workbook has been updated within X days

Threaded View

  1. #1
    Registered User
    Join Date
    12-19-2013
    Location
    Kansas City
    MS-Off Ver
    Office 2010
    Posts
    42

    Create Rule to show, in some form, if a SEPARATE workbook has been updated within X days

    I am creating a dashboard in excel that pulls data from separate workbooks that are all on the same shared drive on our network. I can get data to and from workbooks as well as link to them, but I am looking to add one last dimension. At a low level, I would like to be able to show the last update/save date of the source workbook in the dashboard workbook.

    At a higher level, I want to find some way to color code or add a visual cue that the workbook was updated within X days of system date, or "Today". Does anyone have any ideas how I'd pull this one off?
    Last edited by nscarritt; 01-07-2014 at 11:02 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 11-28-2013, 09:00 AM
  2. Create a rule when merging reports to show balance changes
    By brandi2351 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-11-2013, 02:03 AM
  3. while opening workbook form.show method is not working
    By kvramana82 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-25-2013, 11:18 AM
  4. Strategy for Contact workbook updated by 2-3 users on separate workbooks
    By dmsmythe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2013, 02:01 AM
  5. [SOLVED] Create pivottable in separate workbook with ptcache
    By Martin Los in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-06-2005, 08:05 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