track

Good day. I'm running Excel 2016 on Windows 10 Pro. I have a workbook hat contains 8 worksheets with 17 Macros. I intend to make this workbook available to other Excel users who wish to track the data that my workbook will track. Each user will have the ability to have tracked items changed...

Hi, I am currently working on a template to be shared among several people within the organization. It is suppose to be stored in a sharepoint using the web. The idea was to generate a backlog where you could see all changes that people have been doing. The purpose for tracking the changes is...

I have a large spreadsheet to track golf statistics by player, by day, participating by month. Each day a player participates they get a $0 or a positive dollar amount depending on their results for the day. Currently I have a =COUNT formula to track the number of days each participates and it...

I'm creating a tracking document for the real estate team I work with. I'm in way over my head in excel skills (this is news to no one on the team, we just realized it's cheaper for me to spend the hours to make this document and have it as our own rather than pay for the one we've been using...

I wish to catalogue my albums but when they are in excel they are shown by the track number first 06 Killer Queen 02 Spirit in the sky 96 life on mars Some are even shown as 1-01 sweet Love 2-02 Strut your funky stuff I wish to remove the fist word in the string and report just the song title...

I have a text string in excel that is a series of notes delimited by <> following each note So an example would be: It is going well - I hope; we'll know more next week<>Project is slipping - more to some<>Project is on track as of 7/7/18<>Well, it's back off track as of 7/15<> Would very...

I've been looking for a set of macros I could use to put together to keep track of items I order. I want to take the data from one worksheet and mesh it together into a history worksheet on another. Basically to keep track of how many of an item I buy by date and add new part numbers as...

I have this which I am using to track changes to a range; Dim xrng As Range Set xrng = Range("A2:N16") If Not Application.Intersect(xrng, Range(Target.Address)) _ Is Nothing Then Set ws = Sheet1 iRow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row...

hello i wonder if any of you could help me i need a formula in a cell that can "remember" or "keep a record" and sum the values that changes in other cell example <tbody> 1 1 </tbody> then <tbody> 2 3 </tbody> then <tbody> 0 3...

Hey all, I'm trying to use this to increment a number if certain cells equal other cells and then if the range F13:T21 <> the criteria, reset to "0". Am I on the right track? I know it's not working the way it is now. TIA =MOD(COUNTA(F13:T21,N2:Q2,+COUNTIFS(F13:T21,I2:K2))

First off, I'm an Excel novice! I'm rebuilding a spreadsheet to track training that was built by a previous employee who is no longer here. And now I need to add a sheet to track hours, and I'm utterly confused on how to do it. I can't post a picture, so hopefully I can adequately explain...

Hello, So I am looking for the most efficient way using VBA worksheet_change to track cell changes and populate into a column. So say I have cells A1 and A2, when either of them change I want to populate it into another column, say C and D. I will have quite a few of these so looking for the...

Hello all, I need your help in making of my file tracker sheet. My sheet is looks like below: ******** width="450" height="270" frameborder="0" scrolling="no"...

Hi all I am trying to build something to use for my local darts and dominoes league and are unsure which one is best for what I need and am looking for help. I have downloaded some football spreadsheets from internet where you enter the score and it updates the league but our league is based...

I have a 4 digit padlock like this one that I have forgotten the number to. I can buy a new lock for ~$15 but I'd rather try & unlock the one I have. I'd like to create an excel sheet that contains all the different possible combinations (10,000 of them). That way, I can keep track of the...

So we will eventually have three spreadsheets, but for now we're getting the ball rolling with two. The first sheet is for individual employees to keep track of issues that arise. Various columns to track the aspects of each issue. I wanted to have the data automatically written from the...

Hi all. Thank you, in advance, for your help. I found this code to track any changes made to each tab. I have a table in columns A-AV (different rows for each tab, depending on the data). Is there anyway to update this code to not track when rows are inserted? Additionally, how would I write...

Good morning! My line of work includes bidding projects throughout each month. My estimator does not keep track of the jobs very well so I find he piles up so many jobs on a single day that this is all I can get done. I would like to smooth it out so I am doing about 5 jobs per day on every...

Hi there - here's the issue I'm having: I measure how long it takes our people to contact a lead that comes into our system. Currently, we track this Monday through Saturday, 9am to 9pm (Sundays are not counted). Here's the formula I'm working with...

I’m not an advanced excel user and my Access skills are non-existent, so I am looking for a simple approach. I need a project management solution for a large team of consultants to track i) client meetings and activity, ii) assignments and progress, iii) new prospects & contacts that they have...