tracking

  1. F

    problems with copy and pasting the cell

    I have a problem with the code. the purpose of this code is to trace the changes. it does work, but it when I want to copy and paste an entire row. it only copies a single cell. I tried to use an "If else statement" to allow the copy but my skills are focused in Java and php I am new in this...
  2. M

    Excel WebPage Sites Hits Tracker

    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.
  3. S

    Spreadsheet Tracking

    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?
  4. C

    Keeping Tally each day

    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?
  5. M

    VB Reporting On Late Projects

    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...
  6. D

    How to track expiry dates in a training spreadsheet

    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...
  7. N

    Start/Stop Timer

    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"...
  8. M

    School Menu / Inventory Tracking

    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...
  9. A

    Help with running relay time tracking sheet

    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...
  10. S

    Trying to track product in & out w/ employee

    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...
  11. B

    What is the best approach to keep track of multiple versions

    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...
  12. C

    Copy from same column into different column into a tracking sheet

    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...
  13. C

    Looking up Fedex Tracking arrival date

    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...
  14. C

    Open Action Item TEmplate

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

    Creating a calendar from data entered into a tracking worksheet

    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...
  16. B

    Can you tell when an excel file has been opened?

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

    Scheduling Help?

    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...
  18. O

    Embedding tracking information into excel spreadsheet

    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)...
  19. Y

    Conditional Formatting - A*-F Student Alpha Grade(s)

    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...
  20. L

    Continuous count based on two factors

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top