tracking

Hello everyone. I use Office 2010 and I have created an Excel WebPage at work and was wondering if anyone knew how to track page hits for it. Thanks.

How do you track your production? I need to develop a method for tracking the location of the many spreadsheets that are developed daily for different projects and I'm at a loss. What method do you use?

I have a worksheet, where each day the team runs a macro and it displays data. Is there a way, in a new sheet to keep track of the data each day, for the month?

Hi All, I am having a lot of trouble with a particular spreadsheet I'm trying to develop. It's a project tracking tool and what I need to do is copy and past all the late projects into a specific sheet for review with our dept heads which is quite laborious. I am trying to find someway to copy...

Hi I am really struggling. I have a training spreadsheet with circa 2000 dates in and i need to keep track of the following 3 things: •Total valid certificates •Total certificates within 1 month of expiry •Total expired certificates I already have conditional formatting to show which ones are...

Hi Everyone! first, I'm not good at creating VBAs from scratch. I usually get ideas from the forums then putting everything together to build a macro. I am trying to create a timer macro using Active X Control Button so that when I click "Start", the button will automatically switch to "Stop"...

Hello all, I am looking for a way to automatically add up the qty of an item that has been used in sheet "MENU" on the "Inventory" Sheet. I have 2 sheets: Sheet 1: Inventory <tbody> ITEM QTY USED REMAINING CHIPS 100 Sum From "Menu" =QTY-USED CAPRISUN 200 Sum From "Menu" =QTY-USED...

I am trying to create a sheet that will allow me to estimate the time for each runner (12 total) over 36 total legs for the Hood to Coast relay in a couple weeks. I have the layout below with these colums F-runners name G-leg # H-total miles for that leg I-estimated time that leg should take...

I have no clue if this is possible or not, but here is what I am trying to do. I want to have a spreadsheet of product that has been scanned in using a bar code scanner. This will be in A1. I then want B1 to auto-generate the product name [using a table on another sheet?]. In C1 a timestamp will...

Hello, I need to create a simple database that will keep track of the latest version of a document we are using. For some reason, I cannot decide the best way to do this. All I need to track is the Document number, document name, date, version number, and system number. Ex: document...

Hello all, I am trying to build a macro where it allows me to copy data in Range(I3:I40) within master sheet where the data changes every day into a tracking file Range (the next available black column) so, into newsheet C4:C41 on day 1, D4:D41 on day 2 etc. i can never get the right column...

I am trying to create a VBA program in which one of the sub-procedures sends a single tracking ID to FedEx's website and then retrieves the estimated arrival date. I can get the VBA program to open FedEx's webpage showing the tracking information, but by using the data connections I cannot get...

Wanted to know if anyone had an OAI template they would like to share. I created one but hate the reporting and the look.

Hi! Okay so I have created a revenue and production tracking worksheet in Excel. Each month booking forms that are signed off within that month are entered under the sales rep's name with details such as the start and end date of the booking, the financial breakdowns of the bookings, etc. As...

Is there a way to find out the date and time an excel file has been opened within the file?

Hey, This is my first post, and i have taken a look around the forums and haven't found anything that quite meets what i need, and i cant seem to work up my own formula to do this. But basically I'm creating a military leave schedule for my unit. What i need it to do is when i have more than 4...

I want to be embed information into a spreadsheet (file) that will allow me to track when the file is sent out of an organisation via email. The background to this is: An intranet application needs to provide excel download functionality, we want to be able to embed a set of bytes (byte array)...

Hi All I am trying to set up the conditional formatting for a spreadsheet that contains grades achieved against a target value - some students have a target grade over the boundary of 2 grades - for example A/B - so either is "good". Any ideas on how can I format grade cells so that if it...

Hey guys, this is my first time posting on the forum but I have always gotten a lot of help from reading other posts. Here is my question: I have a workbook in which I have created a tracking program with a user interface, the information posted to the interface gets stored into hidden...

I want to be able to measure the progression of a cell that is in a dropdown in Excel. Once the cell "closes" it is important but it is more important to see what the cell was before it was coded as closed. Is there a way to see what the last item in that cell was? maybe put it in another cell?