tracker

Hello, Each week, my whole company attends a meeting. Before each meeting, an email is sent out with a Microsoft Forms link which the whole company must complete to state they've acknowledged and understand the briefing. This is because some employees who work nights can't attend a daytime...

I have a leaver tracker to record when people are on leave. People put an A when they are on a day off. I'm making another separate spreadsheet to assign a task but it's important to know when people are going to be off so it doesn't get conflicted. I'd like to be able to bring through the A's...

I'm in the process of making a training tracker for multiple office sections. I was able to create a data entry form that will send an individual's information to the sheet for their respective section. However, the only solution I could think of to easily update old information without making a...

Hello, I have an absence tracker which records absence in a current 6-month rolling period and a previous 6-month rolling period. Each occasion of absence is recorded as a separate row and absence is manually added to the "current 6 month" sheet daily (as it occurs). A piece of VBA code then...

Hi, I have been struggling with this for weeks now, trawling through various web pages, so any help would be greatly appreciated. I have a number of learners who's progress I wish to track. They have a number of criteria that they must meet twice using two separate log sheets. Some of the...

I have a few columns and couple thousand rows. Name Location Status Action Jake Germany out Retain Jake Ethiopia out Delete Jake Germany in Retain Jake Germany out Retain Jake Ethiopia out Delete In the above table, if Jake is "in" (3rd column) "Germany" (just an...

Hi excel wizards! I'm looking for some assistance with a sheet to track up to 200 simultaneous projects by automatically updating the date in a cell when any cell in the row to the right of the date cell is modified. I have done lots of digging online and I understand that I will need a VBA...

Hi, I have multiple (hundreds) of archived spreadsheets consisting of the same mix of tabs and content format (only the data is different). I want to add an extra tab (lets call it 'Tracker') to pull bits of data from the various tabs into one easy to copy n paste column. Simple. :) What I then...

Hi, I'm trying to create a basic excel formula based on red/black bets on roulette. The basic layout is currently like this: <tbody> A B C D E F 1 Bet Round Red Stake Black Stake Bet Outcome Bet Profit/Loss Running Balance 2 Round 1 1 1 Black 0 0 3 Round 2 2 1 Black -1 -1 4 Round 3 4...

Hi, I have the following code which looks up the value in cell G6 in sheet "Fulfilment Tracker - Data" and pull the adjacent cell data into cell G8 of sheet "Fulfilment Tracker -Input" Set Table_Range = Workbooks("Fulfilment Tracker - Data").Sheets("All Data").Range("A2:T20000") Set...

Hi Everyone, I am trying to create a booking tracker, for example if I input start and end date per guest/room, this days will be highlighted on calendar. One room can have different guest on different dates range. I was using if(and(vlookup, but only able to have first guest info on the...

Hello!! Does anyone know how to make a sort of interactive task tracker? I have a tracker that has different tabs, one for each client. Each tab has deliverables for that client and the due date. I want the "Summary tab" (main tab) to show the items that are pending, in-progress, to-do, etc but...

Hi All I'm trying to speed up a process and in need to your help. I requested something similar a while back in an earlier post but can't adapt it. Here's what I do right now for each new tab. Sheet1 (Called Data) holds duplicate site names in Col A and staff names in Col B (sometimes...

This may be a basic question for many here so apologies. I'm working with a Project Tracker within Excel for the first time. I have the following catagories Status Assigned to Categories Percent complete I need to add more titles within the Category bucket I've looked and researched but...

Morning all I am trying to populate listboxes with hyperlinks. I have 2 Userforms "Project Tracker" and "Add Links". When "Project Tracker" is in use I want to be able to add links into different ListBoxes via an additional "Add Links" Userform when the command button "Add" is pressed from my...

Hi, Can someone please provide me a VBScript code for my below requirement. I have a master tracking document that I use to record project information. My client sends me an updated schedule each week which may (or may not) have additional stores on it and some of the details of the stores may...

Hi, Can someone please provide me a VBScript code for my below requirement. I have a master tracking document that I use to record project information. My client sends me an updated schedule each week which may (or may not) have additional stores on it and some of the details of the stores may...

My array formula below works BUT, I think I need to apply maybe an INDIRECT function to stop the ranges from moving when I add a new row to my data set. Can anyone help? {=IFERROR(INDEX('EIRF Tracker '!$N$9:$N$2000,MODE(IF('EIRF Tracker '!$G$9:$G$2000="Injury",IF('EIRF Tracker...

Please help I am trying to correct the below formula as I would like to use INDEX MODE MATCH with INDIRECT in a array. The below works, but if I enter a new line at the top of my data set (EIRF Tracker Row 9-2150) the MODE and MATCH arguments change to read from row 10-2151 still...

We have a system that we are using to generate login and logout times throughout the day (that you can export to excel), and we also have a manual excel tracker that we use to input the time we logged out and logged back in and the reason we logged out at that time. Now, the official report is...