Free Microsoft Excel 2013 Quick Reference

Keep track of previous entires

Hello, I am really hoping you can help me. I have pretty good knowledge of Excel but hardly any of VBA. I have a database of information dealing with details of the production of a customer's product that is used as a daily status report. In the beginning, the customer is given a promise date. During the process of production, this date can change, depending on availability of parts. I am trying to find a way of retaining this information (what the initial promise date was and changed dates have been through out the last month) I would have ten columns at the end to allow for 10 changes but I need to find a formula that stops calculating once a change in the initial promise date cell is made. I would need to have charts to show the changes (i.e. how many times the date was changed, how many days difference between the actual and the initial date.

I know of the option to share the workbook but it wouldn't allow of automatic updates for charting the data. I have very very basic knowledge of VBA programming but I have a feeling it might be the only way to go. Any help in this matter would be greatly appreciated.
Many thanks,
Jessica


Post your answer or comment

comments powered by Disqus
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?

Any help is really appreciated!!

Thank You!!

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.

Thanks for your time and consideration!

email/msn:

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.

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.

Thanks for your time and consideration!

email/msn: spanky_mcfarland28@hotmail.com

I need help writing a macro that upon closing excel (current file name = file1.xl) would prompt the user to "enter changes made", and then the macro would add this text along with the name of the person who entered the change, to a page in excel and save the file as file2.xl.

This way I could keep track of the changes made, as well as have different file names to go back to previous work.

Is this possible in VBA? If so could someone point me in the right direction.

Hey guys,I have a file where we write monthly comments, they are written by analyst then approved by the managers and then the director.

The excel is used in shared mode, once a comment is approved it's flagged as "yes" until all comments have been approved by all parties,
the file is saving itself automaticaly every 10 minutes.

I would like to keep track of updates by using a pop-up window that will inform user about the changes, here's a simple example:

In the example Paul, John, Sam are the analyst writing the comments, next to it is the number of comments approved by them, then the manager and the director.

So let's say this is the status before save:

Analyst Manager Director
Paul 15 10 5
John 20 12 7
Sam 12 5 4
And after:

Analyst Manager Director
Paul 17 15 8

Let's look only at Paul, since the last change he approved 2 (17-15) more comments, manager approved 5 (15-10) more and director 3 (8-5).

The macro should be executed after each save, be it automatic or manual, once it's saving it should compare the old values with the new one and return a pop-up windows with changes.

I can take care of the formula to get the text I want in the pop up,.

I need the part where macro will be executed at each save and will keep track on update history.

If any question please PM me, 20$ by paypal.

thanks

Hi Everyone,

Here's a quick one I've been thinking about and couldn't find a way to get it done.

So I 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, no.

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.

Anyone has an idea if it can be done?

Thanks a lot

Is there a way to keep track of when a particular sheet within a workbook was modified? Can this be done within a user defined function? (If so, please let me know how?)

I would find this to be useful in an 'index' worksheet so to list a workbook's tabs/sheets with a link to their location in one column and show the date they were last modified.

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

I need an easy way to keep track of / log incoming phone calls. I have to
write it all down now and I do not want to do that anymore. Please help me

Hello.

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

Does anyone have an idea of how to do this?

Thank you for your time.
vitaleca

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

Hello all, first post.

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.

Hello,
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:
oExcel.ActiveWorkbook.ActiveSheet.Cells(oExcel.ActiveCell.Row,
oExLast).Value

This works fine when user uses one spreadsheet only.
But when the user opens another spreadsheet the first one is not ACTIVE
anymore,
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,
Jack

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

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?

http://i198.photobucket.com/albums/a...nHunter_90.jpg

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

Im in property management. How can I keep track of all the bills I pay for
all my buildings. e.g. Peoples Energy, Com Ed, etc

Is there a way similar to Word where you can keep track of different versions
of the same workbook?

I sell cookie lee jewelry it is like mary kay or avon and i need to keep
track of milage and inventory sales and a few other things what should i use?

I am trying to setup a database to track sales for the sales team. However I only want to keep track of the first 40 accounts that they sign up. How can this be accomplished. I am attaching the raw data file, this is how i would recieve the weekly data. The account numbers is the shipto column. So i wanna know the first 40 account numbers by date for each rep . If someone can point me in the right direction. I am not very good with using date functions. Really appreciate the help. Thanks

can someone help me by supplying code that will use cell A1 as an entry cell. And when you change A1's value, it moves the original value to A2. and when you do it again it moves A2 to A3 and then A1 to A2....indefinately

I just need to enter new data and keep track of the old

thanks!!!

Is it possible somehow to keep track of the last line of code that was run
before a handled error occured without
adding line numbers or without adding a public variable that gets
incremented before every line?
I was thinking of perhaps a class handling VBE events, but I think I will
need the public variable.
I am not keen to add line numbers.

RBS


No luck finding an answer? You could always try Google.