Holiday absence tracker, holidays, or present won't change when selecting new dates

**mspeirs1971** · 06-09-2023, 11:46 AM

hi
ive attempted to design a absence, preset & holiday tracker on 1 sheet. I have done all the formulas so when the user selects the month or year, the system tells you the correct dates.
Here is my issue, when the user types in P = Present, A = absent & H = Holiday, when you change the month or year, the date still remains in the same cell, it does not disappear when you select a new month.
I'm not sure if this can be achieved by using formulas or does it require some VBA?
I'm happy to submit the file on here to find a resolution.

Thanks

**windknife** · 06-10-2023, 02:57 AM

I think that need to use VBA in worksheet "HOLS ABSENCE".

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim Rng As Range, rINT As Range

    Set Rng = Union(Range("I4"), Range("K4"))
    Set rINT = Intersect(Rng, Target)
    If rINT Is Nothing Then Exit Sub
    Range("N8:AZ1000").ClearContents
End Sub

Holiday absence tracker, holidays, or present won't change when selecting new dates

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Holiday absence tracker, holidays, or present won't change when selecting new dates

Re: Holiday absence tracker, holidays, or present won't change when selecting new dates

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Update absence tracker so that absence is automatically moved between sheets

Help With formula and function Absence tracker

[SOLVED] Leave of Absence tracker--modifying data in one sheet due to change in another

Excel formula to help count holiday and absence

Absence Tracker Template by employee

Absence tracker problem

Absence Tracker will not calculate

Bookmarks

Bookmarks

Posting Permissions