Hi all! I am trying to set up an Excel spreadsheet that will list all
of the employees in our department, along with all of the training each
employee has. I would like to set it up so that I can keep track of
when an employee's training certificate is about to expire (probably
with colour codes: yellow when a training certificate is due to expire
in 3 months and red when a training certificate is due to expire in 1
Yes, I know there are lots of posts on this topic but I don't have any
formal excel training and I can't seem to find any templates to even
set up what I am trying to do. I would be very grateful if someone
could email me (or catch me on MSN) and send me a copy of any templates
they may be using to keep track of the same things I am trying to do.
I did manage to set something up but I am totally confused as to how to
get the formulas set up. If someone is willing to put in the time, I
could send them I have and then maybe they could set things up for me.
I don't need to send our entire staff list, I would only send a few
names and then I could figure out the rest myself by changing the
formula to match the different cells.
1. Keeping track of employee training
2. USD $20.00 VBA to keep track of changes and display them in pop up
3. Keeping track of text update by changing color
4. Keeping track of a worksheet modified date (not a workbook's)
5. Get one cell to keep track of changes in adjoining cells
6. Keeping track of the largest number under zero
7. A form to keep track of monetary goals for dated events and offeri
8. I need a way to keep track of incoming phone calls
9. Keeping track of results of refreshed/updated data
10. Keeping track of loan payments and interest
11. Keeping track of and totaling hours worked
12. keeping track of possible solutions?
13. How to keep track of opened sheet?
14. How to keep track of high & low values of a cell?
15. Help with keeping track of payments
16. What is the best template to keep track of all the utility bills..
17. How do I keep track of different versions or revisions?
18. I sell jewelry what template should i use to keep track of it?
19. keep track of previous excel range value after dragdropped...
Hi all! I am trying to set up an Excel spreadsheet that will list all of the employees in our department, along with all of
the training each employee has. I would like to set it up so that I can keep track of when an employee's training
certificate is about to expire (probably with colour codes: yellow when a training certificate is due to expire in 3 months
and red when a training certificate is due to expire in 1 month).
Yes, I know there are lots of posts on this
topic but I don't have any formal excel training and I can't seem to find any templates to even set up what I am trying to
do. I would be very grateful if someone could email me (or catch me on MSN) and send me a copy of any templates they may be
using to keep track of the same things I am trying to do.
I did manage to set something up but I am totally
confused as to how to get the formulas set up. If someone is willing to put in the time, I could send them I have and then
maybe they could set things up for me. I don't need to send our entire staff list, I would only send a few names and then I
could figure out the rest myself by changing the formula to match the different cells.
Here's a quick one I've been thinking about and couldn't find a way to get it done.
have a cell call 'comments', it's free text, in that cell I will write comment about what happened sales wise during the
month, then my manager will review it, then in the cell next to it is a list consisting of 3 choices, yes, yes with updates,
What it does is simply, if value is yes then the text in the comment cell switches to blue (using conditional
formatting), if the cell value is no background color switches to bright yellow.
What I'm trying to achieve is, if
the values is yes with updates, then the changes made in the comment cell would have a specific format, say bold+red text, so
it's easier to keep track of the updates made.
I am trying to enter some data into 5 columns. Excell 2007 XP Pro SP2. The first column A3 is the "Item Description" the
second column B3 is the "Yearly Total of Items" the third column C3 is "Items Issued" (or sent out) the fourth column D3 is
the "Received" the fifth column E3 is the "Items on Hand" C3 and D3 are constantly changing and E3 is an easy formula
(=B3+D3-C3) but the "Yearly Total" they want to be a running total and roll over to keep track of all the changes made to the
sheet throughout the year. I can not figure out any way to do this. Anybody have an idea?
If the I5 CELL is posting in it numbers under zero, in J5 I would like its CELL to keep track of and post the largest number
under zero being posted in I5.For example if in I5 the number is -2.25 and another number is posted there that is greater
than -2.25, for example -2.50, than the -2.50 number would be posted in the J5 CELL replacing the -2.25 number already in the
J5 cell. Any ideas on the formula for this. Thanx Much.
I need help designing a form to keep track of our church's monetary goals and
receipts for special events and special offerings to be taken on specific
calendar days throughout the year. The special emphasis/offerings will be
held around the same dates each year, but of course not the exact same dates.
I would like to include dates, the theme of the special emphasis/offering
and the biblical reference for each event. This form should show the
previous year's goal amount and the amount received, then the current church
year goal and a place to enter the amount received as they occur. This would
be a great source to use each year in planning and setting new monetary goals
for these special offerings for the coming year.
I am using the random number generator function essentially to run
a (Monte Carlo) simulation. I calculate a result (one run) of the simulation
each time that I refresh/update the data generated by the random
number generators. The calculations take up quite a bit of room, so
just copying the calculations so that the simulation is replicated on a
worksheet or multiple worksheets is impractical. I would like to refresh the
data 100,000 times or so, but keep track of the resulting output for each
I suspect this is easy but I am no expert in Excel so need your help.
I want to create a spreadsheet that keeps track of loan amounts I am making
and calculate the interest that is accruing. I want to charge interest at 1%
over UK bank rate and charge the interest on the balace outstanding at the
end of every month. So if I lend say ¬£250 to someone on the first of every
month indefinately, how do I set up a spread sheet that calculates the
interest at the end of every month. Also I may lend additional amounts during
the month which need to be added to the balance outstanding.
I keep track of my daily work hours using Excel. I enter starting time in one column and ending time in the next. I would
like for the next column to calculate the total hours worked and rounded to the next 1/10th of an hour. I know it can be
done, but I havenít figured it out yet. Any help would be very much appreciated.
I'm working on a VBA program for a design project and have hit a bump in the process. I
have a For...Next that searches through a spring catalog database and finds springs that fit withing a certain diameter.
After it finds a spring that fits it determines if it provides a required spring force, the rest is irrelevant to this
question. My problem is that as the code stands now as soon as 1 spring is found that fits, it outputs the information of the
spring and stops. What I really need to do is have it run through all the possibilities (which I can already do) and keep
track of all the springs that fit the requirements so I can have it output the BEST spring not the FIRST it finds. Any
suggestions about how I can accomplish this without needing to use a bunch of variables to assign the values to? This project
is for a private company project and I don't feel comfortable posting the code I have so far.
Sorry for the wordy
post but any help is appreciated, example code isn't really necessary just trying to figure out what process I can use. Thank
in advance for the help.
I am not Excel programmer.
I use visual basic, but my software interacts with the spreadsheet.
I have the following problem.
My code uses statements like the one below:
This works fine when user uses one spreadsheet only.
But when the user opens another spreadsheet the first one is not ACTIVE
however my code still needs to access the first sheet.
So here is my problem. How to keep track of the first sheet?
I tried to do the following:
Dim oExcelWBk As Excel.Workbook ' This is the work book
Dim oExcelWS As Excel.Worksheet ' This is the sheet
oExcelWS = oExcel.ActiveWorkbook.ActiveSheet
but there is Run time Error '91':
Object variable or With block variable not set.
How to do that properly?
Your thoughts please,
I want to be able to keep track of the highest and the lowest values in a cell and also the date and time that those values
In my example, cell C3 is the total of a number of cells. C5 is the highest value that has occurred in
C3 and B5 is the date and time that it occurred. And C6 is the lowest value that has occurred in C3 and B6 is the date and
time that it occurred.
And is there a way that I can reset C5 and C6 back to zero and start again, presuming that
there are calculations in those cells?
I am just createing a worksheet for a frien that keeps track of paymenst of
mini storage and anothre one for keeping track of rents collected. What I
would like to
do is in a cell that would be for the next month, after the 15th of the
month have something popup stating that this account is overdue. Any
suggestions. Thanks. Any suggestions as to a telplate for this is also
I am developing a simple app and this app requires keeping track of previous
value entered into a cell before dragging new value on it.
I have an external source from which I dragdrop values
into excel cell; but
some cells on my excel sheet already contains data - so I want to append this
new dragged data to my previously existing data on that cell. Which event on
excel should I use to keep track of it?
Currently I am using Workbook_SheetChange event to do this; but when I
dragdrop data on a particular cell that already contains data;
range.cells.value2 in workbook_sheetchange or workbook_SheetSelectionChange
events are giving me the dragged data and overwriting previous existing data
on that cell. How to resolve this issue?