track

I am looking for a way to track the last updated version of pdf Files in another folder that I have linked to a power pivot. I saw threads about tracking last updates on sheets themselves but wasn't sure if there was anyway to track back updates/edits made on files in a different folder? Thanks...

At my company we currently use an google sheet to track the progress of installations in progress, Installers have access and enter times manually. We have also recently created a Word Form that is essentially checklist of these same points for installers to follow and keep them on track. I was...

Dear all, I am trying to use th VBA to control the function of Track Changes and i would like to know about the code.Please share to me. First of all, i would like to use VBA to : 1.trigger the Track Changes function 2.tick the box of Track changes while editing.This also shares your...

Hi I am learning how to share a workbook and track changes. Under Review there is a option called: "Protect Shared Workbook". I did not find that option is needed in anything. I can track changes without clicking on that option! not sure why is there. Thank you.

Hi I am experimenting Track changes option. I noticed that If I highlight cells and change the color (background color), Excel would not consider that as a change. Why is that? Thanks .

I have one spreadsheet that looks something like this <tbody> date track race n1 n2 n3 n4 n5 n6 1/11/2017 doomben 1 4.5 2.3 18 8 6 1/11/2017 dubbo 5 2.3 4.5 8 20 2/11/2017 flemington 4 2 5 7 </tbody> now i want to get the correct n value for the correct...

Hello, I am trying to figure out a formula the will copy the 1's in the Export Sheet C2:F6 and place them in the Track Sheet in cells C2:F6. The Export Sheet contains the data and the Track Sheet should match A2, B2, and C1 with the same cells in the Export Sheet to get the correct cell with the...

Hi there, Please see the attached Sample on dropbox link. I have a Master sheet that I want to track the total of events that occur each week for a sports team. https://www.dropbox.com/s/mpsxrh3couwu2lh/Sample.xlsx?dl=0 On the Engine sheet this will track the possible events each week and...

Hi all. 1st foray into Excel and I'm stuck. I have a basic workbook which allows users to enter holiday requests and I need to track the user who is making the changes. Unfortunately this is done on shared PC's so i cant use the UserName associated with the PC./Excel which is where I've come...

Hi All! I am creating an excel spreadsheet for an event There are two time columns side by side in the same sheet. One shows ‘time code’ (like what is used for film) and the other shows ‘track time’ (which shows how long that particular track has been going) So for example, for the third...

R1 R F R 2 4 F 1 0 The formula for above format. =IFERROR(MATCH(1,(SKIPSUMS!$AG$21:$AG$6631=$A17)*(SKIPSUMS!$AG$22:$AG$6630=B16),0)-1,"") I would like the formula to be in this format. Book1CMCNCO1F2R1FR23PKG004HITS4945055MED116MAX10107AVG2.021.988CUR SKIP1009PREV...

I'm looking for a way to track correspondence (email or Direct mailing) Example that I would like on 12/1/17 Mailed to "David K", "Wanda S", "Bridgett C", "Dack T", "Hannah H".....etc..... on 12/2/17 Mailed to "David K", "Steve M", "Chris P", "Ryan S", "Hannah H" The names...

Hi, I am trying to create a way to track volumes for orders received for multiple products against orders completed on a daily basis. I do not need to track the order details, just the overall number received/completed for a day. I currently have 3 sheets - 1. Orders received (table with list...

This isn't a problem, just curiosity. I've got a reasonably large Excel forecast model (10Mb). I recently rebuilt the model to FAST standards, so it now uses a ton of SUMIFS over 1200 cell ranges and these feed a lot of other sheets. Calculation is Automatic. At bottom left, where it says...

I'm trying to figure out how to properly input a formula that will match the first 7 characters of C2, with the first 7 characters of A2. =IF(ISNUMBER(MATCH(LEFT(C2,7..........),true,false) Not sure if I'm on the right track. I'm confused with using "ISNUMBER" because I'm not looking for a...

Hi, I'm working on the production of a Microsoft Office e-learning course. My Excel file contains a worksheet where I track progress for each individual course module. The 4 production stages are (simplified): text - screenshots - voice-over and animation Whenever a step is completed I...

Hi, all, Trying to find a way to explain what I need so bear with me. My daughter and I have setup 2 marble tracks. We have 5 sets of colors marbles and we want to have mini tournaments (seasons) racing the 5 different colors over 2 tracks. It is very easy to calculate the W/L as a total...

Quick Question, In excel 2016, I want to track all my changes but when i make a change on the workbook, i want to record the reason for the change on the history sheet. I wanted to do this by adding another column in the history sheet tab but the sheet is protected. Is there any possible way...

Good afternoon, I am trying to generate a score based on responses with values from 1-3. For example: I have three categories: on track, off track, and N/A. I would like to generate an "IF" statement where "on track"=3, "off track"=1 and "N/A"=0. This will be pulling from a pick list from...

I'm trying to make a table that determines the price of a track depending on the length of the track and the track type. What I want is to have a table that does the following: Column A= Track Type (Ceiling fix and Face fix) Column B = Track Length Column C = Track Price If track type...