Capturing date changes

Hi

I have an excel spreadsheet let me set up this example:
Column A                Column B
Client Name                Date Called
ABC
XYZ

Situation if I call ABC on 5/16/89 but I change the date the next day to 
6/16/90 I need to maintain in another sheet all of the dates I contacted ABC 
for purposes of reporting.

I could use your help thanks 


0
RFraizer (1)
3/16/2007 12:35:00 AM
excel 39879 articles. 2 followers. Follow

1 Replies
555 Views

Similar Articles

[PageSpeed] 33

One approach -- though awkward and CPU-intensive -- would be to tie
into the Worksheet_Change() event. You could use the 'Target'
parameter to determine if the change was in the column (and/or row)
you're interested in and, if so, copy things to another sheet. Note
you'd always be copying over the new value(s) that just got put in, or
changed, not the pre-existing values. (No functional difference here,
but possibly a conceptual one).
HTH

/ Tyla /



On Mar 15, 4:35 pm, "Work" <RFrai...@verizon.net> wrote:
> Hi
>
> I have an excel spreadsheet let me set up this example:
> Column A                Column B
> Client Name                Date Called
> ABC
> XYZ
>
> Situation if I call ABC on 5/16/89 but I change the date the next day to
> 6/16/90 I need to maintain in another sheet all of the dates I contacted ABC
> for purposes of reporting.
>
> I could use your help thanks


0
tylagusim (7)
3/16/2007 4:12:35 AM
Reply:

Similar Artilces:

404 error on change password in OWA
I'm gettting a 404 error when using the change password function in OWA: The page cannot be found The page you are looking for might have been removed, had its name changed, or is temporarily unavailable. -------------------------------------------------------------------------------- Please try the following: Make sure that the Web site address displayed in the address bar of your browser is spelled and formatted correctly. If you reached this page by clicking a link, contact the Web site administrator to alert them that the link is incorrectly formatted. Click the Back button t...

counting dates before today
I have a list of applications and their due dates (some applications are due on the 5th day and some are due on the 28th day). Here is a partial example: Case # 5th Day 28th Day 111111111 15-Jan 222222222 2-Feb 333333333 1-Feb There are up to 500 rows of applications in my list. I need to get a total of both columns that are due before today and calculate the result in a single cell in another worksheet. I also need to get a total of both columns that are due two weeks from today, also calculating the result in a single cell in the other worksh...

Updating Dates
Hi I want to create a spreadsheet that (amongst other things) shows bill payment dates. Some bills are paid on the same date each month and I want a function/ formula to update these automatically. For example Sheet 1 (January) A1: January A3:Mortgage, B3:15/01/04 Is there a way to get cell B3 in Sheet 2 (February) to show 15/02/04 etc hope this is clear Nick One way In A1 on Sheet 2 input 1/2/04 but custom format as mmmm so it shows u as February Now in B3 on Sheet 2 input =A1+14 and format it as date: dd/mm/y -- Cutte -----------------------------------------------------------...

case change
none of the selections under case change work. i.e. sentence case, upper case, etc. I am not able to get a new sentence to begin w/capital. Any suggestions? Hi Joe, Does the font you're using have upper-case characters? It would be rather strange if even the Shift & Caps Lock keys didn't allow you "to get a new sentence to begin w/capital". -- Cheers macropod [Microsoft MVP - Word] "Joe S" <Joe S@discussions.microsoft.com> wrote in message news:D977CE2A-95A8-4867-A08B-65B2FDBFFCD7@microsoft.com... > none of the selections unde...

Printing and date
Hi, I have the Letter report that will send to 50 patients. My question is when I print them off, is there a way to add the printing date on the to the database? Thanks Chi Hi Chi, You have a report you created in Access and when you print it from Access you want the current date printed on the document? If so, did you create this report with the Wizard? If so, access automatically puts that information on the report. Or am I off in another direction? "Chi" wrote: > Hi, > > I have the Letter report that will send to 50 patients. > > My question is when I...

Convert Text to Date Month and Year
Hi I have a cell for example that displays 03/07 as a text field for month and year. I want it converted to date field to display as = mar-07 or march 2007. when I use format or text function it converts to 03/07/2010. I dont want to have the current year display instead it should display 2007. Use: =date(right(a1,2),left(a1,2),1) and format as: mmm-yy or mmmm yyyy Regards, Fred "Excellency" <Excellency@discussions.microsoft.com> wrote in message news:C6CA08AE-6CB4-440C-AE9D-96EE6CB08747@microsoft.com... > Hi > > I have a cell for example that ...

OWA change password option without installing certificate server
Hi ! Good ! that there is a concern about the security for changing the password using OWA (outlook web access), Is there any way out to make change password option work without installing certificate server ?. Installing and managing certificate server is another overhead for the administrators. I feel there is also complication when it comes to recovering the failed server. If any experts have solution to make the change password option work please mail it to me, It will be of a great help. Thanks in advance. Best Regards, Vivek ...

How do I change the default hyperlink folder in Outlook?
When I insert a hyperlink in an email in Outlook I'd like to be able to choose the default folder. Currently it is My Documents. ...

Read-only files
I want to email an MS Publisher 03 file. It is read-only protected, but it can still be accessed and changes made, although it has to be saved with another file name. Is it possible to make it unaccessible - so that no changes can be made at all? no. and it doesn't even have to be saved with a different name, all you have to do is change the file attributes. "secretariat" <secretariat@discussions.microsoft.com> wrote in message news:0CFB98E4-29E7-4AC6-BBB4-177EE7F5C982@microsoft.com... |I want to email an MS Publisher 03 file. It is read-only protected, but it |...

Change password from a webpage
Hi there, I have an windows/exchange 2003. All the users are only accessing email thug RPC/HTTPS (Outlook 2003) or using webmail. No one has computers on the exchange domain. How do I let the users change passwords? Does Microsoft have a web interface for this purpose? Best Regards Martin In news:44ccdcf2$0$15793$14726298@news.sunsite.dk, wee <wee@wee.co.org> typed: > Hi there, > > I have an windows/exchange 2003. > All the users are only accessing email thug RPC/HTTPS (Outlook 2003) > or using webmail. No one has computers on the exchange domain. > >...

Julian Date conversion
Hi and TIA! I posted this to another grroup but then saw this one and it looks more suited to my question. I've researched and tried many many conversion functions but none give me the results. One Example Public Function JDatetoDate(MyDate As Integer) As Date JDatetoDate = DateAdd("d", Right(MyDate, 3) - 1, "01/01/" & Left(year(Now()), 3) & Left(MyDate, 1)) End Function ?JDatetoDate(8044) returned 2/13/2018 expected 2/13/2008 ?JDatetoDate(0044) returned 2/13/2014 expected 2/13/2010 Any ideas. Basically want to convert a 4 digit ju...

The Format Date
I'm seeing the date with this format mm/dd/yy but i need ti change it to this format dd/mm/yy. How can i do it? Seba, The last time that I checked, Great Plains was still getting it's date format from the system settings in Windows. This will be a pain if you have different settings on various workstations. I always recommend that my clients adopt one date format and that all workstations stay with that setting. Lyle On Wed, 25 Aug 2004 14:12:25 -0700, "Seba" <anonymous@discussions.microsoft.com> wrote: >I'm seeing the date with this format mm/dd/yy but i...

email capture
I'm having a problem with Outlook not pulling the mail off my pop server. When I do a send and receive the mail is identified, "grabs" the messages like it's doing a download but when it reaches the end I'm getting an unknown error message. Any thoughts? 1) First, try to set up Outlook Express to download the email set. Sometimes it has better luck. 2) Another way is to clear the queue manually. This is technical, and not really recommended by anyone, but you may have a stuck message... Telnet to get it... (this method permanently deletes messages before you c...

How can I change an excel document
How can I change an excel document back a regular folder? I opened a folder with excel by mistake, it had several emails in it. Now I can't read it. what do I do to be able to change back to a folder so I can open it? Thank you. Sara gkuhL3@adelphia.net It sounds like you opened a file and actually saved it in excel (or let autosave save it). It that's what happened, do you have a backup of your original file? I don't think there's a way to go back. Depending on what that file was (plain text???), you may be able to reopen it in excel and extract some info--but I would...

Change Colours of Records
the Hi Is there a way to change the colours of screens if a different status of the record is selected? Thanks Mark Yes it is possible => onchange event: --------------------- if record is blabla then document.body.style.backgroundColor = 'red'; --------------------- -- Mutlu Erol Switch Automatisering BV Netherlands, Oldenzaal Junior CRM Consultant "Mark Braithwaite" wrote: > the Hi > > Is there a way to change the colours of screens if a different status of the > record is selected? > > Thanks > Mark Cool website with a lot of jav...

Median of Even Set; How to Capture them?
Hi everyone, Say I have a dat set such as: 4 5 6 7 The median is (5+6)/2=5.5! However, I am not interested in the answer here, but the 5 and the 6!!! Is there an excel function or way to do so? Thanks alot, Mike Do you want the output in one single cell or in 2 separate cells? Mike Wrote: > Hi everyone, > > Say I have a dat set such as: > > 4 > 5 > 6 > 7 > > The median is (5+6)/2=5.5! > > However, I am not interested in the answer here, but the 5 and the > 6!!! > > Is there an excel function or way to do so? > > Thanks alot, ...

Capture user selection of font
If I put a font combo box on a Ribbonbar is there a way for me to capture the user's font choice? I need to capture that choice and use it in a macro. Whate *exactly* are you trying to achieve with your macro? -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> "dplaut"...

Charts don't update when data is changed, why not?
Can someone help? My Excel has somehow ended up in a weird mode where the charts don't change when the underlying data changes. The only way to get a current chart is to close Excel and reopen it. For example, if I were to construct a chart using two columns of numbers, it will plot correctly. But if I go back and place a negative sign in front of every y-axis datum, the chart won't change until I close the file and reopen it. I assume I have a config issue somewhere, but I can't find it. Can anyone help? Thanks in advance. /frank I suppose it would be helpful if I mention...

Date to years
Is there anyway of converting a date to the amount of years. I have employees years started posted and I want to convert to years worked with the company. Thanks Kevin Use the DATEDIF command. =DATEDIF(start_date, TODAY(),"y") See www.cpearson.com/excel/datedif.htm for more info about DATEDIF. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Savage" <Savage@discussions.microsoft.com> wrote in message news:9DF024D3-0544-41C7-9BA8-7659C8B5C4A3@microsoft.com... > Is there anyway of converting a date to...

Date formats in Office vX & 2004
In Word vX and 2004 when I try to insert a date, the dates that are listed are the US mm/dd/yy formatted dates. The problem I have is that I want dd/mm/yy to be the format of the date inserted. The same goes for Excel vX and 2004, when I try to format a cell/column/row to a date format, the only formats listed are again the mm/dd format and dd/mm is not even listed under the date section. I have to go down to custom to get the dd/mm formats. I am currently using 10.3.4 and my International System Preference is set to Australian. On 8/4/04 5:34 PM, in article news_-359624.12345605082...

Changing Functional Currency #2
with transaction already entered, can the Functional Currency be changed say from SGD to USD or to any other currency? or any 3rd Party tools can provide above functionality... this is required as a local based company may be brought over and become a foreign owned company, hence the functional currency for ALL historcial and open trx need to be changed. thks in advance. Once you have chosen the functional currency and entered a transaction, it cannot be changed. I have not seen any third-party tools that will change this. "HFLo" wrote: > with transaction already enter...

Date Conversion Solar date to Gregorian
Dear all, It would be very kind of you guys, if you could help me to set a date conversion in a textbox. I have two fields in a form. The first one stores date in Solar type date (01/01/1388) I want to set such a coding to covert that date to Gregorian date. Example: Today is 14-10-1388 which is 04-Jan-2010. Thanks a lot. On Sun, 3 Jan 2010 22:32:01 -0800, Mohammad Mobin <mobin.net@gmail.com> wrote: >Dear all, > >It would be very kind of you guys, if you could help me to set a date >conversion in a textbox. > >I have two fields in a form. T...

How do I check which cells in column are date format?
Hi A few weeks ago I located the answer to this but now I can't find it anywhere. I have a formula that adds 10 years to a date in the cell next to it. My problem is, if one of the dates is not formatted correctly, the formula returns an error. I am sure all I had to do was something along the lines of =(CELL)ISDATE or something like that. It just said TRUE or FALSE........ I may be miles wrong here but I hope someone can help. I just need to see if all the cells in the column are formatted correctly. Kind regards Malcolm Malcolm. A quick look at the CELL function in help wou...

changing the color of a single bar on a graph
I am creating a bar graph that, for example, list a class full of students and their grades on an assignment. I want to be able to graph all of the results, have the graph all in the same color, and then enter in a cell the student ID I am reviewing, then have the graph update to change the color of that student's grade on the chart. As this is going to be a lookup tool, I need this to be like a macro that changes the graph automatically versus clicking on it and doing it manually. Anyone able to help? Hi, You can do this with 2 data series and some worksheet formula. Example d...

Date and Time setup
I work at a 24 hour job we take readings every hour. I want to have the date autofill a cell as the current date but our sheet changes at 0700 every day. So if the sheet is worked on at 0100 the date needs to be for the past day starting at 0700, if the time for the current day changes to 0800 the cell will display the new date. ie: 0100hrs = 4/18/06 0600hrs = 4/18/06 0800hrs = 4/19/06 etc... =TODAY()-(A1<=TIME(7,0,0))*1 HTH -- AP "Joe" <jdbarnes63@earthlink.net> a �crit dans le message de news:28db731403ef4144bf9b3800591a428e@ureader.com... > I work at a 24 ho...