+ Reply to Thread
Results 1 to 2 of 2

Audit/Catalog in Excel

  1. #1
    Registered User
    Join Date
    01-19-2015
    Location
    Sacramento, CA
    MS-Off Ver
    2007
    Posts
    8

    Question Audit/Catalog in Excel

    I have an excel spreadsheet with a list of appointments. (This includes multiple columns- Appointment Name, Date)
    I have a folder of PDF of notes from those appointments (They're titled AppointmentNameDate.pdf)

    I need a way to audit/catalog that I have a PDF for every appointment.

    I have the ability to get a list of the PDF names in an excel spreadsheet, if that helps.

    Ideally, there would be a way to highlight all the appointments that I don't have PDF's for, without me having to go through and look at each PDF and highlight on the spreadsheet accordingly.

    Any ideas?

  2. #2
    Registered User
    Join Date
    01-19-2015
    Location
    Sacramento, CA
    MS-Off Ver
    2007
    Posts
    8

    Re: Audit/Catalog in Excel

    Oops, I now realize I've posted this in the wrong place!

+ 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. Need to Create a Catalog based off an Excel File
    By tlb4327 in forum Excel General
    Replies: 5
    Last Post: 07-16-2013, 09:36 PM
  2. Using Excel to create a customizable catalog
    By eaglestl in forum Excel General
    Replies: 4
    Last Post: 06-25-2013, 04:30 AM
  3. [SOLVED] Maintain Audit Log file on Sharepoint using Excel VBA
    By mustang1966 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 03:48 PM
  4. Excel Audit Trail?
    By jvest0648 in forum Excel General
    Replies: 1
    Last Post: 12-17-2011, 02:57 PM
  5. [SOLVED] Catalog drive content into Excel sheet?
    By tiki2k in forum Excel General
    Replies: 2
    Last Post: 03-04-2005, 10:06 PM

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