tracker

I need to copy a row from one workbook/worksheet to another workbook/worksheet based on the value in column "A". I have tried a dozen different codes I found online and have been unsuccessful in figuring it out. No clue where I went wrong. I need every row with "Jane" in column A in workbook1...

Good Afternoon All, First time poster, long time lurker! Great forums helped me out many times! Hopefully someone can help with this quesitons? I have created an action tracker in Excel and I've used a formula to indicate if actions have past their target completion date. The formula i have...

Hi, Im trying to add in some way of tracking debt of customers in a spreadsheet. So far the formula say if a date is over 60 days then it will say Recourse =IFERROR(IF(O2>60,"RECOURSE"),0) But i now need it to do the same thing track if an invoice is over 60 days but also if the customers...

So the code I currently have is button-based, and is located in Workbook A, when pressed, it opens Workbook B and pastes a designated range of data from Workbook A to Workbook B. Unfortunately, I am now stuck. I know it seems simple, but I am at a writers block. I need this code to not just...

Good Morning, I have an excel sheet I'm building that does budgeting for specific types of projects. I have most of the VBA worked out for that. The part I'm having issues with is updating an exteral excel tracker. This is the script to create the tracker if it doesn't exist: Sub...

Hi, I have a team of 40 associates and currently, we have one excel based file with multiple columns to capture the data on a daily basis. These columns are bifurcated into Four parts: The first part, basic details: First 12 columns: Date, Month, Week #, Unique ID ( Aklphanumeric), Tracker...

I searched this forum and many others with the same results. I am unable, using the attached sheet, to place a vertical perpetual moving date vertical line. Many different tutorials explain ways to achieve this but I believe I am unable to replicate because of how my Gantt chart is designed...

Re: Employee attendance tracker In the new 2016 excel is a template called Employee attendance tracker. There is only 4 leave types, i would like to have 6 leave types and then it only got full day leave options. How can i change it to fit my needs. I would appreciate it if anyone can help.

Hi all, I'm trying to develop a absence tracker; I managed to cover most of the requirement apart from one that I need your help with. Workbook contains dates in row 12 and each individual absence is recorded in rows below as 1, 0.5 (day) etc. We are measuring absence on rolling 12 months basic...

Hello, I am trying to set up an investment tracker for stocks and I am pulling in data from a web query but it comes in as a long string. For example...

Hi, firstly thank you for any help. I am building a tracker that I need help with a formula I want a cell to increase by one for every 5 increment in another cell.

I have created an absence tracker that tracks points accured on a rolling 12 month system. If an employee takes an unexcused absence he gets a point. After 12 months, a point will be taken back. I believe I have completed this with this formula in I5...

I have got a sales tracker that identifies sales per month, but I need to make another tab with daily captures on and want it to pre-populate the monthly information, is this possible?

The dictionary items are not showing Sub Tracker()Dim a, w(), i As Long, ii As Long, n As Long, z As String, ws As Worksheet, dic As Object Sheets("Tracker").Range("a6: b100000 ").ClearContents Set dic = CreateObject("Scripting.Dictionary") dic.CompareMode = vbTextCompare For Each ws In...

Hi everyone, I don't know if anyone can help me, but I'll give this forum a try. I am trying to modify a template published by Chandoo since I think its look really neat: Employee Vacation Tracker & Dashboard using MS Excel | Chandoo.org - Learn Microsoft Excel Online Here the idea, we ask...

Hi all, I am extremely bad at verbally explaining things, so I hope I'll manage to explain what I need clearly. :eeek: I have a "case tracker", where I track actions on cases and their status. There are several actions in the process (5+). Below is a very simplified example: So basically...

Hey Guys, I'm a Digital Marketing Consultant for Online Lead Generation company. We use PPC advertising on Google and Bing ads. We have over 10 clients that we do this for on a monthly basis. I created a Budget tracker, that tracks each clients clicks, impressions, daily budget, and cost...

I am trying to build a patient tracker (aka Date Tracker) in excel, my requirements are the following: 1) I need to be notified within the first 48 hours of release date —excluding weekends. 2) Again notified within 7 days with weekends of release date. 3) Again notified within 14 days...

Hello everyone, I've been searching for(unsuccessfully) a way to create a form in Excel where people can go in and select multiple items from drop down menus then enter the information for the items. Once the form is completed they can select an "enter" button and the form distributes the...

Hi, I have a team of 50 people and counting. I would like to create an automated attendance tracker wherein a user should be able to login / logout with command buttons. As soon as he opens the file, he should be a pop up message requiring him to login. The logoff button should be hidden until...