Forum Discussion

Riaan1055's avatar
Riaan1055
Copper Contributor
Mar 20, 2020

Excel - formual

Hi guys I want to if it's possible for excel to automatically update data. For example: I have a table of dates, 1st till end of month. I want it to keep on showing the current dates data. Like ...
BI & Data Analysis
excel
Formulas and Functions
Riaan1055's avatar
Riaan1055
Copper Contributor
Mar 24, 2020
Hi Savia, here is an example of the sheet. As you may see in the bottom row 48, column M. I need that percentage to uodate automatically in row 61, column W.
So let's say today is the 24th, I need it to update to the current date, but when it is tomorrow, i need it to put in that data.

Thanks
Savia's avatar
Savia
Iron Contributor
Mar 24, 2020

Riaan1055 This image doesn't include the row/column headers so I can't really follow.  Could you attach a version of the file with dummy data or otherwise explain what the formulas here are doing?

  • Riaan1055's avatar
    Riaan1055
    Copper Contributor
    Mar 24, 2020
    It's a attendance register. With a full month dates. Each date has its own column. Each cell in the column has a drop-down with the following: Present, AOWP, Annual leave, Normal leave, Sick leave etc.
    As you will see on the image I sent you there is only Total AWOP showing... The other totals are minimized.
    I just net the data that has been processed to show below the legend of AWOP.
    Example: on 24 March 2020 there were 25 AWOPS. I already did the calculations to give me a % answer. Now all i need is that tge percentage I calculated beeds to show in the legend below AWOP and of its possible to update according to the the date.
    I'll send the sheet now.

Resources