In an attempt to become more efficient, I am working on a training date tracker. What I am looking for is the cells to turn shades at the 10 month (yellow) and 11 month (red) mark. I have attached an example of the tracker.
For Example: On Mike, his first aid was completed 12-1-2008. On Oct 1, 2009 I want the cell to shade yellow and Nov 1, 2009 it will turn red.
If you have any questions, please let me know.
Thanks for the assistance.
Hi All
I was just wondering if any of you have seen a good Training Log or Tracker anywhere?
I thought before I launch into creating one, there might already be one!?!
I am thinking of having something in excel that will show employee training info, courses info, in-house, external etc etc...
possibly even have the ability to print a list of attended courses per employee...
Any pointers to an existing one would be appreciated..
Thanks
N
I have a list of about 10,000 odd training records and I need to find, for each of the approx 300 course codes, the earliest and latest dates the course has been run.
Columns of data a
Course Code
Course Name
Start Date
Finish Date
User name
So for each of the 300 course codes, I need to get the earliest Start Date and the latest Finish Date.
I'm familiar with Max/Min functions, Named Ranges and how to find the unique Course Codes from the list. But not so sure about how to set up a formula to find the records for one course code against which I can apply the max/min function.
Any help would be appreciated.
Ward
in Perth
Hi everyone,
I just wanted to give you a heads up about Dunamis Training, LLC. We are dedicated solely to Excel/Access VBA programming. If you are interested in having a 2 day VBA class at your site or come to an offsite class, contact us. We are in the Pittsburgh area! Our instructors have decades of proven experience in VBA solutions at companies like FedEx and GM. We target business professionals, so you don't have to be a programming expert to participate.
Check out our web site: dunamistraining.com
If you have any questions, shoot them to us from our website "contact us", or call us. Thanks.
Chad Marinelli
Owner/Trainer
Dunamis Training, LLC
1-412-628-9464
chad@dunamistraining.com
I am just beginning to learn how to make macros but I need help in a big way. what I need is a macro that will figure out how to schedule people for training based off their schedule and available training classes. I.e. i have a list of dates, times and number of people that can attend. I need something that would base the persons schedule on the available time and assign the class, then when it maxes the class out it moves to the next class. I know it is a lot to ask for but i am in desperate need for some help.
Hi there,
I was wondering if it is possible to play a video on excel directly from a web page?
I know how to put a video on from a file i have saved, but is it possible to do it directly from a web page?
Hi All ,
I'm a newcoemr for Excel VBA programming and i'd like to learn more about this exciting tool so i have looked on the internet for a nice video tutorial and i thought it would be better if i asked you if you have already tried one product so you can recommend it for me , that will make me sure that i'm spending my money on the right product.
Thanks in adavnace and waiting for your recommendations.
I want to display a video in Excel and automatically list the frame number in
a given column. Ideally, I want to be able to select from the frame numbers
and have Excel go directly to that frame in the video. Is this possible?
Guys look at this ******* hot video - blonde babe make a amazing blowjob. Suck it babe uuueeeee! You need show it your girlfrend, lets see how it need doing.
Hello,
Mr. Excel did a quick video of his top tips. However, I can't remember where he posted that. Does anyone have the link?
