Results 1 to 2 of 2

Thread: Help with dynamically pulling data from other workbooks

  1. #1
    Neophyte Dolenhil's Avatar
    Join Date
    Mar 2021
    Posts
    1
    Articles
    0
    Excel Version
    Office 365

    Help with dynamically pulling data from other workbooks



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Good evening and thank you in advance for your time and support.

    I am creating a daily report that has a date specific name for example.

    01-03-2021 Daily Report
    02-03-2021 Daily Report
    03-03-2021 Daily Report
    04-03-2021 Daily Report

    And they are all saved in the same folder.

    The idea is that each report pulls data from the same 12 cells of the same column of the previous day's reports , so =today()-1 should then be the varriable.
    I tried "& or concatenate to break down and put together the address of the other workbooks but nothing is working up to now.
    Just to give some heads up I dont want to use indirect as that would mean that the workbooks should be open which I dont want.

    Any ideas ?

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,910
    Articles
    0
    Excel Version
    365
    Code:
    =TEXT(TODAY()-1,"dd-mm-yyy") & " Daily Report"
    or
    Code:
    =TEXT(TODAY()-1,"dd-mm-yyy") & " Daily Report.xlsx"
    ?

    For closed workbooks, as you've discovered INDIRECT won't work, even if you do have the full path to the workbook.
    You will need VBA (a macro) to put such a formula into cells.
    Power Query will be able to do this easily too.
    Last edited by p45cal; 2021-03-04 at 11:10 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •