+ Reply to Thread
Results 1 to 1 of 1

Retrieve value of field across different Excel files

  1. #1
    Forum Contributor
    Join Date
    12-03-2021
    Location
    Brussels
    MS-Off Ver
    Microsoft 365
    Posts
    186

    Retrieve value of field across different Excel files

    Dear,

    I am creating my bills based on the same Excel template. In this template, there is a Date field with the format DD/MM/YYYY.

    Besides, I have a Dashboard Excel in which I'm creating statistics and one of those statistics is "Last Billed in" where I'd retrieve the Year of the latest bill.

    Do you think there is any way for this Dashboard to search through all the bills of a folder and retrieve the latest year of billing ?

    Thanks
    Simon

    Sample workbook and bill attached
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by davesexcel; 02-27-2022 at 09:22 AM.

+ 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. How to retrieve a particular value from multiple lines of a field in Excel?
    By excelhelp2045 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2017, 02:00 PM
  2. Replies: 0
    Last Post: 06-28-2017, 03:22 PM
  3. Replies: 2
    Last Post: 05-03-2016, 10:07 PM
  4. [SOLVED] To retrieve a single cell's value for all Excel files in a folder
    By alice2011 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-24-2015, 10:19 AM
  5. Replies: 5
    Last Post: 10-24-2014, 04:58 PM
  6. Replies: 4
    Last Post: 04-10-2014, 12:11 PM
  7. VBA in Excel: define file to open (I retrieve data from 2 Excel files)
    By zeno1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2012, 12:19 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