Dec 21 2021 08:05 AM
I receive a monthly ageing receivables sheet from a colleague and have to manually enter the arguments into the sheet in order to get a chart to use in my presentations.
Usually this sheet has blanks and certain variables such as retention receivables that requires manual entrys to sort into the correct format.
Is there a way to make this dynamic so when I receive the monthly update I can just copy the table from the previous month (or utilise a seperate sheet) in order to save time?
Dec 21 2021 08:31 AM