Automatic Mortgage Calculation
I am running MYM2003 SE Version 11. I have set up my mortgage account as a loan with all of the information regarding rate, term, amount, etc. I pay my mortgage to the bank from my checking account online. When I prepare the transaction, I input the Category as Loan Payment:Mortgage ( name of mortgage account). The mortgage account collects the data associated with the transaction but incorrectly calculations the amount of interest vs. principal. In fact the calculation is also inconsistent. (i.e. January Payment Principle 700 vs. 1243.69, March Payment Principle (138.67). This requires monitoring the account making "Account Adjustments" monthly. Not the way the software is suppse to work. The payment is set up as a split transactions as Principal Transfer (Calculated), escrow and interest (calculated). When I first discovered the problem, I deleted the mortgage account and resestablished history and it seemed to work well with each transaction posted. But problem has continued for last 6 months. Any help. I have used this software on other loans including other mortgage payments with no problems. Thanks MLWEST
mlwest
outlook
87535 articles. 
11 followers.
1 Replies
367 Views
Try posting this in a group for your version of the program - we have no clue about MYM2003 SE nor do I even know what the program is. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, mlw asked: | I am running MYM2003 SE Version 11. | | I have set up my mortgage account as a loan with all of the | information regarding rate, term, amount, etc. I pay my mortgage to | the bank from my checking account online. When I prepare the | transaction, I input the Category as Loan Payment:Mortgage ( name of | mortgage account). | | The mortgage account collects the data associated with the | transaction but incorrectly calculations the amount of interest vs. | principal. In fact the calculation is also inconsistent. (i.e. | January Payment Principle 700 vs. 1243.69, March Payment Principle | (138.67). This requires monitoring the account making "Account | Adjustments" monthly. Not the way the software is suppse to work. | | The payment is set up as a split transactions as Principal Transfer | (Calculated), escrow and interest (calculated). When I first | discovered the problem, I deleted the mortgage account and | resestablished history and it seemed to work well with each | transaction posted. But problem has continued for last 6 months. | | Any help. I have used this software on other loans including other | mortgage payments with no problems. | | Thanks | MLWEST
MillyS9060
Similar Artilces:
Newbie problem with amortization calculations
Hello, I've just today installed Money 2006 Deluxe trial version; a full version is on the way, which I am beginning to regret. I've only gotten as far as downloading my checking account from my bank and TRYING to establish an account for my mortgage. I have entered the information five times now, but the mortgage amortization Money calculates simply will NOT match my bank's. It starts off being off by a few pennies at best, and escalates by the end of the amortization to being off by anywhere from a few dollars to fifty or more. Money also will not allow me to make the mortgage ...
Automatic incremental of records
I have a table with several records and arranged serially, i.e 1,2,3 .....25. When I delete arecod like record number 3 I would like record number 4 to become record number 3. But in my case Record number 4 still remains serial number 4 although it is actually the third record. Is there a way it can be done automatically? njogus wrote: > I have a table with several records and arranged serially, i.e 1,2,3 > .....25. When I delete arecod like record number 3 I would like > record number 4 to become record number 3. But in my case Record > number 4 still remains serial number ...
Calculate Due Date
Kindly guide me in calculating Due Date in Excel worksheet. In Column "B" there are some dates. I want to calculate due dates after adding 40 days from date mentioned in Column "B" to be displayed in Column "C" Eg: In column "B" Date is 01/06/2004 then after adding 40 days date in column "C" must be 10/07/2004 Pls guide me Ajit Ajit, In cell C5, for instance, the formula should be: =B5+40; enter the formula in your top cell in column C, copy down and format the column as date and you're done! HTH, Nikos "Ajit" <Ajit@d...
How do I stop automatic copies going to Adminstrator
SBS 2003 with Exc2003 - all current on SPs How do I stop what appears to be an automatic copy of every message sent going to the Adminstrator's account? Also, when an appointment is scheduled or altered by a user, a blank e-mail gets deposited in the Administrator's account. I don't want nor need these extra copies. Anyone have an clues what is causing this and how to stop it? -- Bruce Bruce wrote: > SBS 2003 with Exc2003 - all current on SPs > > How do I stop what appears to be an automatic copy of every message > sent going to the Adminstrator's account? &...
automatic transfers of payments and deposits
I have no problem setting up payments to be made by check but have'nt figured out how to set up pre-authorized utility payments and pension and social security deposts -- Ron AACS "Ron AACS" <Ron@cox.net> wrote in message news:F1A51290-3EA4-45BA-9463-E0638C3D4C2B@microsoft.com... >I have no problem setting up payments to be made by check but have'nt >figured > out how to set up pre-authorized utility payments and pension and > social > security deposts Record an example in your register as you'd like it categorized. Right-click it, pick ...
Calculations #5
hi all, i was wondering if anybody would know how to re-create the calculation done at this web site: http://www.americancentury.com/workshop/Retirement_calc.jsp I'm not sure what formulas to use to re-create the calculations. I'd like to know the formulas I can use in Excel to perform th calculations done in both sections of the webpage. Would all formulas be exclusive to the PV function only? Can anybody help? I would appreciate it if someone could lead me in the right direction Thanks -- vbc2 ----------------------------------------------------------------------- vbc22'...
Creating a Formula to Format Column automatically? #3
Can I record it as a macro or anything like that? I have to run it o five sheets. I've tried to conditional formatting, and it works only o one cell, unless I'm doing it wrong -- bludovic ----------------------------------------------------------------------- bludovico's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1480 View this thread: http://www.excelforum.com/showthread.php?threadid=26434 not sure what you are trying to do but conditional formating can be coped and pasted. you have also conditional format an entire column/row by selected the en...
Changing text automatically
After typing in AUGUST 2004 my text automatically changes to Aug-04. Is there something in Excel which prohibits typing the ful month? Any help gratefully received -- Message posted from http://www.ExcelForum.com Have you tried to right click the cell and click format cell. Then select Date and on the right side box select the format you want? >-----Original Message----- >After typing in AUGUST 2004 my text automatically changes to >Aug-04. Is there something in Excel which prohibits typing the full >month? Any help gratefully received. > > >--- >Message posted ...
Need SOMETHING that updates a linked spreadsheet automatically
Hello experts, I have two Excel 2000 spreadsheets, S1 and S2. S1 is linked to S2. Bot reside in a Windows 2000 server. When values in S2 are changed and saved, I need SOMETHING (a trigger program, or script, whatever) that automatically updates values in S1 without me having to open S1 and update it myself. Is there a solution to this problem? What could do it? Thanks vey much for your help -- Message posted from http://www.ExcelForum.com "kpax >" <<kpax.14fcjn@excelforum-nospam.com> wrote... >I have two Excel 2000 spreadsheets, S1 and S2. S1 is linked to S2. Bo...
Don't automatically clear my transactions
When I balance an account, all my electronically downloaded transactions are automatically marked cleared. I want to clear them myself, so I first have to unclear all of them. How do I turn off this "feature"? ...
SOP Transaction Automatic Fulfillment Occuring
My apologizes for this post ahead of time as I am a developer, not a GP guru. I have what is probably a configuration issue I am trying to resolve, but I am unsure of the settings that need to be configured. GP is configured to utilize a separate fulfillment process. When online we are submitting invoices using a SOP transaction with SOPNubmer = 3. When a customer submits an order, the order is placed in Great Plains, the pick ticket prints properly, BUT the order is AUTOMATICALLY fulfilled. Which setting in the SOP transaction needs to be set to prevent automatic fulfillment? Th...
"Special" Mortgage payment situation
Scenario: one mortgage paid with two checks from two accounts - one account tracked by Money (mine) and one not (gf's). I would like to track my mortgage payments and include my gf's contribution (easily done on a credit account). How can I set up this scenario so each of the two payments are automatically divided into P & I and entered as one or two monthly bills? I hope this explanation is clear. I used to track half of the mortgage (and home value), but need to track the total due to differences in our contributions. I think the easiest way is to just brute force the ...
MS Excel 2003 cannot auto calculate formula, need to press F9 each time
hi, I don't know why my excel 2003 new worksheet cannot auto calulate formula (eg. summation), i need to press F9 and it will refresh and show the new figure. there is "calculate" word at the left hand bottom of the screen. what is the likely reason ? it was running fine 2 weeks ago. any advise is greatly appreciated. rgds. Tools>Options>Calculation tab, check Automatic -- Kind regards, Niek Otten Microsoft MVP - Excel <sg_s123@yahoo.com.sg> wrote in message news:d5393a73-eb7d-4e08-8fab-5f4ab895f77a@e23g2000prf.googlegroups.com... | hi, | | I don't know w...
calculations 07-18-07
Hi, I have a question. I have reports and average totals now I want to build reports by week or month or whatever how do I add my totals to give me a team average or individual totals per week not just per report. example. I have a team of 10 employes each have different amount of reports and different scores now I want to get a sum total of thier dayly reports and come up with a dayly, weekly and monthly report to give me the grand total of what they have done during the week or month. Currently I have a table that has all the reports and totals, and I also have a query that separates them p...
xmlns="" automatically generated
I have the following code: XmlElement parent= m_xmlDoc.CreateElement("parent", "http://tempuri.org/myns"); parent.InnerXml = "<child1>text</child1><child2>text</child2>"; "http://tempuri.org/myns" is declared as the default namespace for this xml file. When I set InnerXml above, each <child> node gets the following extra attribute: xmlns="". I'd like child nodes to inherit the default namespace instead of the empty namespace. How can I do it? thanks, Zhenya ----------------------- Posted by a user from .N...
outlook is deleting my e-mails automatically
Everything about my outlook is working except when I open an e-mail and then close it out using the "x" the e-mail automatically is deleted. It is gone, it is not in the deleted items, it is completely gone. Can anybody help? Check View | Current View What view is selected? -- PATRICK REED [Outlook - MVP]~~~~~~ -Microsoft Certified Professional (MCP) -Have you checked http://www.slipstick.com? -Please post your Outlook version! "Ken" <anonymous@discussions.microsoft.com> wrote in message news:02ae01c3be88$a828c620$a301280a@phx.gbl... > Everything ...
Calculating the days in a month
I have a Control which is a Date field named 'NEWTOPD'. Based on the date entered in the field it calculates the days offor the whole month making amends for Leap-year as well. If I want only the number of days in that month starting from the date entered in 'NEWTOPD' - to be entered in a calculated text field (which is a number field) named 'Text361' how should I modify the following code? Text361 stores the data in (PDDAYS). 'UPDATE (PDDAYS) BASED ON NEWTOPD DATE Dim iMon As Integer Dim sDate As String ...
Stoping Excel from Calculating?
Can you stop excel from executing any formulas temporarily? Meaning while I update info in the workbook nothing will calculate till I say go? Thanks Tools/ Options/ Calculation/ Manual. -- David Biddulph "John" <John@discussions.microsoft.com> wrote in message news:079819FF-7D05-4D70-8497-65BEFD40ECB6@microsoft.com... > Can you stop excel from executing any formulas temporarily? Meaning while > I > update info in the workbook nothing will calculate till I say go? Thanks Tool > Options > Calculation > select Manual > OK out "J...
calculating percentages
I am new at excel. I have inputs done by group 1 of 5410. Inputs done by group 2 of 2420. So, I have a total of 7830 inputs. How do I calculate the percentage done by group 1 over group 2? -- Thanks - Lindamac You can use: =countif(a:a,"group1") to count the number of "Group1"'s in column A. =counta(a:a) will count the number of entries (text, numbers, formulas) in column A. So maybe something like: =countif(a:a,"group1") / counta(a:a) would give you the percentage of group1's lindamac wrote: > > I am new at exc...
How does Money calculate formulas
Hi - is there a reference doc or an FAQ somewhere that details how MS Money calculates its various investment fomulas. I have investments that show different returns in Money vs what the various investment companies are reporting. I've looked around and haven't been able to find anything. Much obliged. Ian In microsoft.public.money, Ian wrote: >Hi - is there a reference doc or an FAQ somewhere that details how MS Money >calculates its various investment fomulas. I have investments that show >different returns in Money vs what the various investment companies are &g...
Calculated Field in Extender
Hi! Is it possible to create a calculation in extender that uses fields from different tables? Thanks -- Marisol Mortera The fields have to be visible within the calculation window. "Marisol" wrote: > Hi! > > Is it possible to create a calculation in extender that uses fields from > different tables? Thanks > -- > Marisol Mortera ...
Automatically set categories on events
Hello altogether, can anyone tell me a way to automatically set categories to events by rules? Not the colorize of events, just the "real" Categories. Thanks for your help. mail@bjoern-mueller.de <mail@bjoern-mueller.de> wrote: > can anyone tell me a way to automatically set categories to events by > rules? Not the colorize of events, just the "real" Categories. I use the "assign it to the _category_ category" action. -- Brian Tillman ...
How to Select Multiple Cells Conforming to A Certain Criteria Automatically?
Dear all, I have a big table containing a lot of data in my worksheet. Within a particular column, I want to select cells whose row numbers form an arithmetic progression with a common difference 8(e.g. G6, G14, G22, ...). At the moment, I can only perform this task by selecting the cells individually while pressing "Ctrl", however, due to the large number of data in the table, this work is very tedious. Does anyone know if there is an automatic way to select these cells? Thank you. Best wishes, Alex, This code can do the job for you. Sub SelectCells() Dim rng1 As Range ...
Calculating on alphabetic cell content
Hi, A selection of 4 different letters in a column representing different values to be used in a formula shall be run through. The calculated result of each cell in the column shall be placed in the cell next to the read one that holds the letter. Thanks in advance. Hi i think you're after the COUNTIF function with your column of letters in A1:A100 and the letter you're interested in in C1 then in D1 =COUNTIF(A1:A100,C1) this will count the number of times the value in C1 occurs in your range. If this isn't what you're after, could you type out a few examples of your ...
how do I create fields in word 2007 to automatic update in excel?
Each day I create a new document that contains several patient's info which includes history, names, patient numbers, etc. At the end of the month I copy and select only data that I need, which is name, patient numbers, and date (not the entire document) and copy into a new document. How do I create a template that will mark specific text and have it automatically update in a new document? See http://gregmaxey.mvps.org/Extract_Form_Data.htm Or http://gregmaxey.mvps.org/Extract_Document_Data.htm -- Hope this helps, Doug Robbins - Word MVP Please reply only t...
Hello, I've just today installed Money 2006 Deluxe trial version; a full version is on the way, which I am beginning to regret. I've only gotten as far as downloading my checking account from my bank and TRYING to establish an account for my mortgage. I have entered the information five times now, but the mortgage amortization Money calculates simply will NOT match my bank's. It starts off being off by a few pennies at best, and escalates by the end of the amortization to being off by anywhere from a few dollars to fifty or more. Money also will not allow me to make the mortgage ...
Automatic incremental of records
I have a table with several records and arranged serially, i.e 1,2,3 .....25. When I delete arecod like record number 3 I would like record number 4 to become record number 3. But in my case Record number 4 still remains serial number 4 although it is actually the third record. Is there a way it can be done automatically? njogus wrote: > I have a table with several records and arranged serially, i.e 1,2,3 > .....25. When I delete arecod like record number 3 I would like > record number 4 to become record number 3. But in my case Record > number 4 still remains serial number ...
Calculate Due Date
Kindly guide me in calculating Due Date in Excel worksheet. In Column "B" there are some dates. I want to calculate due dates after adding 40 days from date mentioned in Column "B" to be displayed in Column "C" Eg: In column "B" Date is 01/06/2004 then after adding 40 days date in column "C" must be 10/07/2004 Pls guide me Ajit Ajit, In cell C5, for instance, the formula should be: =B5+40; enter the formula in your top cell in column C, copy down and format the column as date and you're done! HTH, Nikos "Ajit" <Ajit@d...
How do I stop automatic copies going to Adminstrator
SBS 2003 with Exc2003 - all current on SPs How do I stop what appears to be an automatic copy of every message sent going to the Adminstrator's account? Also, when an appointment is scheduled or altered by a user, a blank e-mail gets deposited in the Administrator's account. I don't want nor need these extra copies. Anyone have an clues what is causing this and how to stop it? -- Bruce Bruce wrote: > SBS 2003 with Exc2003 - all current on SPs > > How do I stop what appears to be an automatic copy of every message > sent going to the Adminstrator's account? &...
automatic transfers of payments and deposits
I have no problem setting up payments to be made by check but have'nt figured out how to set up pre-authorized utility payments and pension and social security deposts -- Ron AACS "Ron AACS" <Ron@cox.net> wrote in message news:F1A51290-3EA4-45BA-9463-E0638C3D4C2B@microsoft.com... >I have no problem setting up payments to be made by check but have'nt >figured > out how to set up pre-authorized utility payments and pension and > social > security deposts Record an example in your register as you'd like it categorized. Right-click it, pick ...
Calculations #5
hi all, i was wondering if anybody would know how to re-create the calculation done at this web site: http://www.americancentury.com/workshop/Retirement_calc.jsp I'm not sure what formulas to use to re-create the calculations. I'd like to know the formulas I can use in Excel to perform th calculations done in both sections of the webpage. Would all formulas be exclusive to the PV function only? Can anybody help? I would appreciate it if someone could lead me in the right direction Thanks -- vbc2 ----------------------------------------------------------------------- vbc22'...
Creating a Formula to Format Column automatically? #3
Can I record it as a macro or anything like that? I have to run it o five sheets. I've tried to conditional formatting, and it works only o one cell, unless I'm doing it wrong -- bludovic ----------------------------------------------------------------------- bludovico's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1480 View this thread: http://www.excelforum.com/showthread.php?threadid=26434 not sure what you are trying to do but conditional formating can be coped and pasted. you have also conditional format an entire column/row by selected the en...
Changing text automatically
After typing in AUGUST 2004 my text automatically changes to Aug-04. Is there something in Excel which prohibits typing the ful month? Any help gratefully received -- Message posted from http://www.ExcelForum.com Have you tried to right click the cell and click format cell. Then select Date and on the right side box select the format you want? >-----Original Message----- >After typing in AUGUST 2004 my text automatically changes to >Aug-04. Is there something in Excel which prohibits typing the full >month? Any help gratefully received. > > >--- >Message posted ...
Need SOMETHING that updates a linked spreadsheet automatically
Hello experts, I have two Excel 2000 spreadsheets, S1 and S2. S1 is linked to S2. Bot reside in a Windows 2000 server. When values in S2 are changed and saved, I need SOMETHING (a trigger program, or script, whatever) that automatically updates values in S1 without me having to open S1 and update it myself. Is there a solution to this problem? What could do it? Thanks vey much for your help -- Message posted from http://www.ExcelForum.com "kpax >" <<kpax.14fcjn@excelforum-nospam.com> wrote... >I have two Excel 2000 spreadsheets, S1 and S2. S1 is linked to S2. Bo...
Don't automatically clear my transactions
When I balance an account, all my electronically downloaded transactions are automatically marked cleared. I want to clear them myself, so I first have to unclear all of them. How do I turn off this "feature"? ...
SOP Transaction Automatic Fulfillment Occuring
My apologizes for this post ahead of time as I am a developer, not a GP guru. I have what is probably a configuration issue I am trying to resolve, but I am unsure of the settings that need to be configured. GP is configured to utilize a separate fulfillment process. When online we are submitting invoices using a SOP transaction with SOPNubmer = 3. When a customer submits an order, the order is placed in Great Plains, the pick ticket prints properly, BUT the order is AUTOMATICALLY fulfilled. Which setting in the SOP transaction needs to be set to prevent automatic fulfillment? Th...
"Special" Mortgage payment situation
Scenario: one mortgage paid with two checks from two accounts - one account tracked by Money (mine) and one not (gf's). I would like to track my mortgage payments and include my gf's contribution (easily done on a credit account). How can I set up this scenario so each of the two payments are automatically divided into P & I and entered as one or two monthly bills? I hope this explanation is clear. I used to track half of the mortgage (and home value), but need to track the total due to differences in our contributions. I think the easiest way is to just brute force the ...
MS Excel 2003 cannot auto calculate formula, need to press F9 each time
hi, I don't know why my excel 2003 new worksheet cannot auto calulate formula (eg. summation), i need to press F9 and it will refresh and show the new figure. there is "calculate" word at the left hand bottom of the screen. what is the likely reason ? it was running fine 2 weeks ago. any advise is greatly appreciated. rgds. Tools>Options>Calculation tab, check Automatic -- Kind regards, Niek Otten Microsoft MVP - Excel <sg_s123@yahoo.com.sg> wrote in message news:d5393a73-eb7d-4e08-8fab-5f4ab895f77a@e23g2000prf.googlegroups.com... | hi, | | I don't know w...
calculations 07-18-07
Hi, I have a question. I have reports and average totals now I want to build reports by week or month or whatever how do I add my totals to give me a team average or individual totals per week not just per report. example. I have a team of 10 employes each have different amount of reports and different scores now I want to get a sum total of thier dayly reports and come up with a dayly, weekly and monthly report to give me the grand total of what they have done during the week or month. Currently I have a table that has all the reports and totals, and I also have a query that separates them p...
xmlns="" automatically generated
I have the following code: XmlElement parent= m_xmlDoc.CreateElement("parent", "http://tempuri.org/myns"); parent.InnerXml = "<child1>text</child1><child2>text</child2>"; "http://tempuri.org/myns" is declared as the default namespace for this xml file. When I set InnerXml above, each <child> node gets the following extra attribute: xmlns="". I'd like child nodes to inherit the default namespace instead of the empty namespace. How can I do it? thanks, Zhenya ----------------------- Posted by a user from .N...
outlook is deleting my e-mails automatically
Everything about my outlook is working except when I open an e-mail and then close it out using the "x" the e-mail automatically is deleted. It is gone, it is not in the deleted items, it is completely gone. Can anybody help? Check View | Current View What view is selected? -- PATRICK REED [Outlook - MVP]~~~~~~ -Microsoft Certified Professional (MCP) -Have you checked http://www.slipstick.com? -Please post your Outlook version! "Ken" <anonymous@discussions.microsoft.com> wrote in message news:02ae01c3be88$a828c620$a301280a@phx.gbl... > Everything ...
Calculating the days in a month
I have a Control which is a Date field named 'NEWTOPD'. Based on the date entered in the field it calculates the days offor the whole month making amends for Leap-year as well. If I want only the number of days in that month starting from the date entered in 'NEWTOPD' - to be entered in a calculated text field (which is a number field) named 'Text361' how should I modify the following code? Text361 stores the data in (PDDAYS). 'UPDATE (PDDAYS) BASED ON NEWTOPD DATE Dim iMon As Integer Dim sDate As String ...
Stoping Excel from Calculating?
Can you stop excel from executing any formulas temporarily? Meaning while I update info in the workbook nothing will calculate till I say go? Thanks Tools/ Options/ Calculation/ Manual. -- David Biddulph "John" <John@discussions.microsoft.com> wrote in message news:079819FF-7D05-4D70-8497-65BEFD40ECB6@microsoft.com... > Can you stop excel from executing any formulas temporarily? Meaning while > I > update info in the workbook nothing will calculate till I say go? Thanks Tool > Options > Calculation > select Manual > OK out "J...
calculating percentages
I am new at excel. I have inputs done by group 1 of 5410. Inputs done by group 2 of 2420. So, I have a total of 7830 inputs. How do I calculate the percentage done by group 1 over group 2? -- Thanks - Lindamac You can use: =countif(a:a,"group1") to count the number of "Group1"'s in column A. =counta(a:a) will count the number of entries (text, numbers, formulas) in column A. So maybe something like: =countif(a:a,"group1") / counta(a:a) would give you the percentage of group1's lindamac wrote: > > I am new at exc...
How does Money calculate formulas
Hi - is there a reference doc or an FAQ somewhere that details how MS Money calculates its various investment fomulas. I have investments that show different returns in Money vs what the various investment companies are reporting. I've looked around and haven't been able to find anything. Much obliged. Ian In microsoft.public.money, Ian wrote: >Hi - is there a reference doc or an FAQ somewhere that details how MS Money >calculates its various investment fomulas. I have investments that show >different returns in Money vs what the various investment companies are &g...
Calculated Field in Extender
Hi! Is it possible to create a calculation in extender that uses fields from different tables? Thanks -- Marisol Mortera The fields have to be visible within the calculation window. "Marisol" wrote: > Hi! > > Is it possible to create a calculation in extender that uses fields from > different tables? Thanks > -- > Marisol Mortera ...
Automatically set categories on events
Hello altogether, can anyone tell me a way to automatically set categories to events by rules? Not the colorize of events, just the "real" Categories. Thanks for your help. mail@bjoern-mueller.de <mail@bjoern-mueller.de> wrote: > can anyone tell me a way to automatically set categories to events by > rules? Not the colorize of events, just the "real" Categories. I use the "assign it to the _category_ category" action. -- Brian Tillman ...
How to Select Multiple Cells Conforming to A Certain Criteria Automatically?
Dear all, I have a big table containing a lot of data in my worksheet. Within a particular column, I want to select cells whose row numbers form an arithmetic progression with a common difference 8(e.g. G6, G14, G22, ...). At the moment, I can only perform this task by selecting the cells individually while pressing "Ctrl", however, due to the large number of data in the table, this work is very tedious. Does anyone know if there is an automatic way to select these cells? Thank you. Best wishes, Alex, This code can do the job for you. Sub SelectCells() Dim rng1 As Range ...
Calculating on alphabetic cell content
Hi, A selection of 4 different letters in a column representing different values to be used in a formula shall be run through. The calculated result of each cell in the column shall be placed in the cell next to the read one that holds the letter. Thanks in advance. Hi i think you're after the COUNTIF function with your column of letters in A1:A100 and the letter you're interested in in C1 then in D1 =COUNTIF(A1:A100,C1) this will count the number of times the value in C1 occurs in your range. If this isn't what you're after, could you type out a few examples of your ...
how do I create fields in word 2007 to automatic update in excel?
Each day I create a new document that contains several patient's info which includes history, names, patient numbers, etc. At the end of the month I copy and select only data that I need, which is name, patient numbers, and date (not the entire document) and copy into a new document. How do I create a template that will mark specific text and have it automatically update in a new document? See http://gregmaxey.mvps.org/Extract_Form_Data.htm Or http://gregmaxey.mvps.org/Extract_Document_Data.htm -- Hope this helps, Doug Robbins - Word MVP Please reply only t...