Hi all,
I've got 2 Excel documents.
In document 1, there's data pulled in from an external program. This could be the total produced amount of articles on a certain date. This is linked to a certain cell. Let's say, there has been 100.000 articles produced on 1-4-2023. This info is automatically (for example) put in cell A1. However, after refreshing (1 week later), the data in this cell will change. Then, the same data (but then for 8-4-2023) will be put in A1.
Now there's document 2. In here, I want to automatically fill in the inportant data of document 1, but per date. (I'm gathering the most important data from multiple documents in one document to create a dashboard). Now, I know that I can link the cells of doc. 1 with doc. 2, but due the data per cell changes every week makes this unsuccessful.
Is there any way to link the cells to dates?
Kind regards!
Luc
I've got 2 Excel documents.
In document 1, there's data pulled in from an external program. This could be the total produced amount of articles on a certain date. This is linked to a certain cell. Let's say, there has been 100.000 articles produced on 1-4-2023. This info is automatically (for example) put in cell A1. However, after refreshing (1 week later), the data in this cell will change. Then, the same data (but then for 8-4-2023) will be put in A1.
Now there's document 2. In here, I want to automatically fill in the inportant data of document 1, but per date. (I'm gathering the most important data from multiple documents in one document to create a dashboard). Now, I know that I can link the cells of doc. 1 with doc. 2, but due the data per cell changes every week makes this unsuccessful.
Is there any way to link the cells to dates?
Kind regards!
Luc