Forum Discussion

bpcowans's avatar
bpcowans
Occasional Reader
Apr 13, 2026

Pull data from other tab

Hopefully I can explain correctly. 

I have a calendar tab and on this tab, I have a box that is to give me my PTO available hours. The PTO available hours are located on a separate tab. My goal is to pull my available PTO hours over to the calendar tab BUT I'm trying to figure out if I can pull it based on today's date. Currently on my PTO tab I have the whole years worth of PTO so the calendar tab is pulling that last PTO available (December's). Any help would be greatly appreciated. 

Thanks

excel

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Apr 13, 2026

    bpcowans​ 

    Would be helpful if you could share a link to your file (private information removed) on OneDrive or similar. Otherwise it's difficult to visualise how your calendar and PTO data is structured.