Hi again!
In a file on Sharepoint I save down our tracker, alongside a .csv file which is fed in by a formula
This is fed into a Tab called "FULL"
On Sheet1 in my Tracker I compile the stats.
Is it possible to have a cell state "LAST UPDATED" - and the Date / Time the .csv feed in file was last updated?
Additionally / alternatively, is it possible to have a pop up text box state "This Tracker has just been updated"
There are 5 people who will have this workbook open and working on it at the same time (In their own individual tabs that take the information from the "FULL" tab.
In a file on Sharepoint I save down our tracker, alongside a .csv file which is fed in by a formula
Excel Formula:
=IF(TableExtract.csv!A2=0,"",TableExtract.csv!A2)On Sheet1 in my Tracker I compile the stats.
Is it possible to have a cell state "LAST UPDATED" - and the Date / Time the .csv feed in file was last updated?
Additionally / alternatively, is it possible to have a pop up text box state "This Tracker has just been updated"
There are 5 people who will have this workbook open and working on it at the same time (In their own individual tabs that take the information from the "FULL" tab.
