ShawnExcel
Member
I am currently trying to create an attendance tracking that accounts for two separate pieces of data in each cell - how much time off, and what type of time off. I am storing the data as a number and color.
The issue I'm having is with the user defined function. It isn't recalculating correctly and I have to manually click into each formula and exit for it to recalculate. Additionally, the function is triggering part way through macros that I run and it interrupts it, not letting it finish. Can I just have the UDF run and recalculate when I hit a "Recalculate" button instead of messing with my macros? I've attached the spreadsheet I'm working on.
Thank you in advance!!
The issue I'm having is with the user defined function. It isn't recalculating correctly and I have to manually click into each formula and exit for it to recalculate. Additionally, the function is triggering part way through macros that I run and it interrupts it, not letting it finish. Can I just have the UDF run and recalculate when I hit a "Recalculate" button instead of messing with my macros? I've attached the spreadsheet I'm working on.
Thank you in advance!!