Creating Amortization tables in excel 2003?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel Misc
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - excel doubts i would like to know if the following 2 procedures are possible and, if possible, how to carry them out- 1) for example, if i type the name of a month, say may, and in the next cell i type a no., say 5, it should automatically fill out like this-'05-05-2008' 2) if i've prepared different sheets regarding different customers but i would like to type the whole data in 1 sheet the data pertaining to different customers should automatically transfer to their respective sheets waiting for your reply mehvish Tag: Creating Amortization tables in excel 2003? Tag: 783989
  - 2
    - Linking I am using Excel97 and want to know how to change links to another worksheet in the same workbook? For example, I have worksheet OTB DEC and OTB JAN in workbook OTB1. In a separate workbook, I have linked the values from worksheet OTB DEC in column A. In column B I need the same exact cells linked, but from the the worksheet OTB JAN. How can I do this without having to either relink column B or type over "OTB DEC" with "OTB JAN" in every cell? I cannot use change source because they are both from the same workbook, OTB1. Tag: Creating Amortization tables in excel 2003? Tag: 783970
  - 3
    - Reverse Pivot-type Data (that's not a pivot table) Data is not in an actual pivot table (so it can't be reversed to get what I want), it's just entered in a crosstab format: June July August Andy 2 3 4 Dave 3 6 2 Any easy way to convert it to this format? Name Month Sales Andy June 2 Andy July 3 Andy August 4 Dave June 3 Dave July 6 Dave August 2 TIA. Tag: Creating Amortization tables in excel 2003? Tag: 783968
  - 4
    - sum if with multiple criteria how can I use multiple criteria and the sum if function. how could I sum for "red apples"? ColA ColB ColC red apples 5 green apples 2 baby carrots 1 red apples 3 Thanks -- djk Tag: Creating Amortization tables in excel 2003? Tag: 783959
  - 5
    - Saving Formulas when addin rows I have a ss that I need to keep track of 12 weeks on information. Each week I need to add a new row either by moving the remaining rows down or deleting th lar row and insert another row. Either way I do it I lose my formulas for the new row. Example Row 2 has formulas in columns F, G, H I now move the data in row 2 down, the formulas in F, G, H are gone as well. On the bottom of the SS I have formulas to add certain rows together. Before I move row 2 all columns have correct formulas. I add the new row which no becomes Row, the formula is no longer in row 2 and I have to edit every row to include row 2. Sorry to be so wordy but I need help! Thanks Tag: Creating Amortization tables in excel 2003? Tag: 783958
  - 6
    - PivotTables and Sum/Count 2 columns I have an Excel worksheet with four columns; Relationship ID, Account Name, Summary of Market Value and Account ID: Realtionship ID Account Name Summary of Market Value Account ID SEAR Sears $3250 20010 SEAR Sears $5345 20010 PENN Pennys $3236 20011 MARS Marshalls $4444 21222 MARS Marshalls $3244 21222 What I would like is to find the total count by Account Name with their Individual and Total Revenue I have created a PivotTable using Account ID in the Data field, and the rest of the fields in the Row field, Relationship ID, Account Name, and Summary of Market Value. The PivotTable displays almost all of what I am looking for with the Relationship Code - Total, Account Name and Sum of MarketValue per Account name and then the final column contains the count of the Account ID. What I am missing is the total of the Sum of MarketValue for each Relationship ID. Is there a way of adding this? Thanks Tag: Creating Amortization tables in excel 2003? Tag: 783949
  - 7
    - HELP! In desperate need of a formula I'm working on a settlement statement that is 112 pages. Column G=the attorneys' name and Column F=rates for the different attorneys. Different attorneys have different rates. At the end of my statement, I have a section that needs to tally each attorey's fee for a total. I can't come up with a formula that will calculate this. Please help! I'm up against a hard deadline! Thanks in advance! Tag: Creating Amortization tables in excel 2003? Tag: 783945
  - 8
    - formula fill down =IF(DataInput!D3="Standard",R4+R4*19.25%,IF(DataInput!D3="Recommended",R4+R4*Q4,0)) how do i reference a cell in a formula and not have it change all down the columns? Tag: Creating Amortization tables in excel 2003? Tag: 783938
  - 9
    - Inconsistent Cell Functions I have a template that we use for financial reports. When we input data we sometimes hit enter and sometimes use the arrow keys. Although I am not aware of any template changes, all of a sudden when we hit the down arrow, EXCEL adds that line to the formula. Example. CELL B4 input 143 then hit the down arrow and B4 will read 143+B5 This is not true on every cell. We have other Excel Documents that the down arrow juts moves to the next cell. This is new and we are wondering how to make it consistent. When we hit down, it should just go to the next cell. Please advise. Tag: Creating Amortization tables in excel 2003? Tag: 783935
  - 10
    - Pivot Table question or a simpler suggestion Hello, I have a group of data. Among the data fields are the following: Name Group/Association Number of rankings The number of rankings are either 0, 1, or 2. I would like to be able to know for a given group, how many members of the group have at least 1 ranking. My first thought was a Pivot Table but if I use the count field setting, it counts all populated cells. If I leave the cell blank, that works instead of using a zero but I would prefer not to leave it blank as it may cause confusion to others I pass the sheet on to. I thought about writing something in VBA but this seems a little advanced for my vba skills. Is there a way to count only non zero values with a pivot table? Is there a simpler solution that I may be overlooking? Thanks. -Mike Tag: Creating Amortization tables in excel 2003? Tag: 783934
  - 11
    - XIRR - Function Missing Hello, I used XIRR many times in the past but today when i tried to use it, i couldn't. I checked the Data -->AddIns and the ATP is clicked so i don't understand why it's not working. I'm using Excel 2003 and as mentioned before - used XIRR many times in the past. I also tried to check and uncheck the ATP and even restart the computer, and I still can't find the XIRR.... any ideas why this is happening and how I can fix it? HELP!! Thanks! Tag: Creating Amortization tables in excel 2003? Tag: 783932
  - 12
    - Conditional Formatting for Excel 2003 D2 has start date( Goods ordered) 02/06/08 E2 has end date (Due date) 16/06/008 F2 is for order confirmation =96 either blank or Yes G2 is a date for Goods Received Please help. In F2 or G2 which ever is convenient, I don=92t even mind having helper columns. I want Color Formatting based on following criteria: If F2 & G2 are blank & its 7 days before F2, I want to show Brown color for chasing order confirmation. If F2 or G2 are blank from 2 days before due date and until the F2 or G2 are populated, I want to show red colour. I hope this makes sense. Regards, Lee Tag: Creating Amortization tables in excel 2003? Tag: 783929
  - 13
    - Sort in a Pivot Table Greetings, Need help as I can't seem to get my pivot table to Sort. Want to sort by ascending or descending based on value in total column of data. I try the Pivot Table/Sort and Top 1 but only seems to give me option to sort the first column. Any help or direction is appreciated. Thank You! Tag: Creating Amortization tables in excel 2003? Tag: 783928
  - 14
    - Protecting a sheet and keeping grouping Hi all, attached is template I am using for a VB program. I need th grouping function and filter function to remain, but need to lock dow the formatting on the doc. The VB program open and populates populate about 80 of these templates every time it runs, so I really can't d this on a one by one basis. The filter function is working, but no luc at all with the grouping. I would like to be able to password protec the file as well. I have tried little snip-its of code hear and there but nothing seems to work. Help +------------------------------------------------------------------- |Filename: FRED_111.zip |Download: http://www.excelbanter.com/attachment.php?attachmentid=115 +------------------------------------------------------------------- -- TommyD Tag: Creating Amortization tables in excel 2003? Tag: 783926
  - 15
    - Macro Dialog Box Hi, Is it possible to create a dialog box that would allow me to enter the following information in and have it placed on each tab in a workbook? Piece Name - Text Field Year Made - text field Edition - text field Picture/File - browse button to find the file to create a hyper link and a seperate option to have a screen tip Status: dropdown Notes: large text Field Mold Y/N - Radio button Location of Mold - Dropdown list Tag: Creating Amortization tables in excel 2003? Tag: 783916
  - 16
    - Unable to save modified Excel 2003 worksheets using Excel 2007 I am using Excel 2003 and have about 80 users filling out worksheets that are linked to a master workbook to collect the data. Everything has worked fine until 3 users received new laptops that are using Excel 2007. They can open their spreadsheets and enter their data but they are unable to save the changes. They tell me they receive an access denied message. Our IS director says that there shouldn't be any problem using the two different versions of Excel together. Any feedback will be greatly appreciated. -- vkeller Tag: Creating Amortization tables in excel 2003? Tag: 783913
  - 17
    - PivotTable Sums I have an Excel worksheet with three columns; Account number, Account Name and Total. The Account Number and Account Name can have a one to many relationship and so can the Total. For example: Account NumberAccount Name Total Tag: Creating Amortization tables in excel 2003? Tag: 783910
  - 18
    - how to calculate a credit card Hi all Iâ??ve got Excel 07,but am stuck . I used the PMT function to calculate to pay off a credit card by entering the APR and how long i wanted to pay and the balance that was on the card to tell me how much to pay each month. Am now want to calculate if i paid off a SET AMOUNT EACH MONTH with the APR how long this will take but i donâ??t know the function to use. Any help from you guyâ??s and galâ??s would be much appreciated. Paul. Tag: Creating Amortization tables in excel 2003? Tag: 783907
  - 19
    - Improting Excel into Outlook I have never had a problem importing excel files into Outlook. The original source is Access. Today, I keep getting the same error message and I do not know why it is doing it now or how to solve the problem. The Error message is: >>>File name has no name ranges. Use Microsoft Excel 97-2003 to name the range of data you want to import. I have never had to do this before in exporting from excel to Outlook contacts. I would like to have it so I do not have to do this everytime I import from excel. any words of wisdom would be greatly appreciated. Christine Tag: Creating Amortization tables in excel 2003? Tag: 783906
  - 20
    - Excel opens but does not open file When a try to open a Excel file the application opens but not the file until I go to Open. It just started doing this, and only Excel has the problem. -- Dianne Griffin Tag: Creating Amortization tables in excel 2003? Tag: 783903
  - 21
    - Making Lists of numbers Hello I need to fill Column aye with the numbers 0001-3000 obviously it will make me very unhappy if i have to type each number in the field. is there any way that excel just fills in the rest of the values? (and leaves the extra zeroes on the front?) thank you. Tag: Creating Amortization tables in excel 2003? Tag: 783898
  - 22
    - Referencing a cell's data & format in Excel 2004 for Mac I am referencing a cell from one worksheet to another. The formula I am using is =Sheet2!A2 The problem is, that it is referencing the data in the cell but it isn't referencing the format of the cell. Is it possible to reference both the data & the format? I don't want to do this one time, I want Sheet1 to automatically update each time the data or format on Sheet2 changes. Thanks Tag: Creating Amortization tables in excel 2003? Tag: 783897
  - 23
    - Data Validation/Cell Protection Question I distribute a worksheet to many users to supply standardized data inputs and it includes a lot of validation and cell protection to prevent creativity. Someone beat my data validation rule for a cell by simply copying & pasting another cell over it. In simple terms: Valid entries for Column A (using a list/dropdown) are odd numbers 1, 3, 5, 7, 9 Valid entries for Column B (using a list/dropdown) are even numbers 2, 4, 6, 8 Copying and pasting cell A1 into B1 allowed someone to get an odd number into B1. Additional cell protection in A&B keeps jumping into my mind, but each time I think about it, I realize protection runs contrary to allowing data input. Or does it ? Any suggestions for keeping copy/pasters from getting invalid data into Column B? TIA. Tag: Creating Amortization tables in excel 2003? Tag: 783896
  - 24
    - Conditional Format I would like to make a conditional format for column B, I would like the cell to turn red if it is todayâ??s date and yellow if it is 3 days from today. Tag: Creating Amortization tables in excel 2003? Tag: 783894
  - 25
    - games on excel 2003 program I have several games that were loaded to excel 2003 that functioned properly. now none woek at all. iI can open the file but they will not load up. i have also tried having a file sent by email attachment but those will only have a line of small boxes accross the top. What has happened to my files and how do I fix them?? I originally recieved them all as a email attachment, if that makes any difference. Tag: Creating Amortization tables in excel 2003? Tag: 783892
- Next
  - 1
    - Rounding Problem?? I am copying and pasting account numbers from one document in to excel. It is automatically changing the last number to zero on almost all of these numbers. Excel 2002. Format set to Number, Zero decimal points. I have looked in the Function under Math & Trig for the rounding feature to see if that could be my problem but I am not sure what to look for to determine if this is the root of my problem. Any guidance would be appreciated!! Tag: Creating Amortization tables in excel 2003? Tag: 783891
  - 2
    - Find and Replace I have approximately 10 names wrapping in an Excel cell throughout a spreadsheet. Some of the names are misspelled or inverted. When I attempt to find and replace a name, Excel gives me an error message that states: "MS excel cannot find any data to replace. Check if your seach formatting and criteria are defined correctly. If you are sure that matching data exists in this workbook, it may be on a protected sheet. Excel cannot replace data on a protected worksheet." These names were copied into Excel from another application (iPro). Anyone have any ideas how to get around this situation? Thanks in advance for any assistance that can provided. Tag: Creating Amortization tables in excel 2003? Tag: 783889
  - 3
    - games on excell 2003 program Dana_Gonzales@BCBSTX.COM Tag: Creating Amortization tables in excel 2003? Tag: 783888
  - 4
    - SpellNumber function for Percentages? I am trying to convert three decimal place percentages into words. I have the script for converting currency (two decimal places), but I'm new to scripting and unsure how to modify the script. Ex: 0.983% = Nine hundred eighty three thousandths of one percent Ex: 1.1% = One and one tenths of one percent Any suggestions or sample scripts would be very much appreciated!!! Thanks!! Tag: Creating Amortization tables in excel 2003? Tag: 783884
  - 5
    - Moving data I am attempting to combine information from one sheet into another and I do not have a clue how to do this for almost a thousand contacts. Any suggestions? Thanks in advance for any assistance. Below is an example of what sheet 1 and sheet 2 look like: Sheet 1 Co. Name Address City Zip ABC 123 Oak Abe 91456 Sheet 2 Co Name ABC Address 123 Oak City Abe Zip 91456 Tag: Creating Amortization tables in excel 2003? Tag: 783882
  - 6
    - Border Problem Excel2003 How can I find the last used row, then select cells "A:F" & Lastrow +2 and apply bottom border. I tried this code but no go. Sheets("Debrief Report").Activate LWriteRow = Cells(65536, 2).End(xlUp).Row LBorderRow = LWriteRow + 2 Range("A:F" & LBorderRow).Select Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone Selection.Borders(xlEdgeLeft).LineStyle = xlNone Selection.Borders(xlEdgeTop).LineStyle = xlNone With Selection.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With Selection.Borders(xlEdgeRight).LineStyle = xlNone Selection.Borders(xlInsideVertical).LineStyle = xlNone Tag: Creating Amortization tables in excel 2003? Tag: 783881
  - 7
    - Autofiltering limitations and rules I know that there is a maximum number of records you can filter. We have a spreadsheet that has data in columns C - R. Columns A & B, however, do not have headings and are more of a "reminder note" to the creator of the workbook. Column C also has merged cells in some of the rows. We have noted that in row 9 columns A & B do not contain information. If I do the autofilter in row 7 and I click on the down arrows in any of the columns, all I see in the column c grouping is "All, Custom, Top 10" and Athletic/HS. Is there a limitation as to blank cells (either in rows or columns)? Thanks, Jane Tag: Creating Amortization tables in excel 2003? Tag: 783873
  - 8
    - Copying a cell down a column For years I have clicked the bottom right corner of a formula cell and dragged down the cell and it copies fine. Today I received a spreadsheet from another person and tried to work on it. I calculated a formula in a cell. Then I dragged it down the spreadsheet. The result was that all cells down the page had the same answer as the first cell I had copied. But each cell had the correct formula in it. The drag changed the formula, which should have changed the result in the cell, but it kept the same value as the first cell. Any help ?? Thanks. Tag: Creating Amortization tables in excel 2003? Tag: 783869
  - 9
    - Excel numbering in a workbook Hi I currently have a excel workbook that has about 600 individual sheets. I would like to hardcode a page number of each page. I don't really want to enter the page numbers manually and was hoping that someone may have a macro for this. Any help will be greatly appreciated. Tag: Creating Amortization tables in excel 2003? Tag: 783866
  - 10
    - Printing Functionalities Hi, I have a excel document with very large spreadsheets. I am trying to make it more 'printable'. The users of my document will be adding rows to the spreadsheets so if I organise it to print friendly now, it will be changed in the future and will not print well. How do I fix this problem? Or is there a way I can set it so it prints well? Thank you for your help. Orla Tag: Creating Amortization tables in excel 2003? Tag: 783860
  - 11
    - Removing empty cells A colleague has a ss with all possible (20) academic subjects across the top row and pupils' names down the first column. Inevitably there are blanks as Sally only does French German and English whereas Amy does Physics Chemistry and Biology. How can my colleague remove the blank cells? I know there's a solution to this, but cannot remember what it is - I had a disk crash and lost the file with the solution!!! (I now have proper back-ups...) Thanks, Richard Tag: Creating Amortization tables in excel 2003? Tag: 783853
  - 12
    - Combining Cell Content Good Morning: I have two cells that contain address information, one is mailing and the other is street address. I want to create a formula to compare both cell and to let me know if the address if the same, if the address is not the same I want to combine them. I know that to combine a cell I use the formula: =A2&B2 How do a enter a paragraph mark in between them? meaning how to lines instead of one long address without breaks? example: A2 = 109 Vine Hill & B2 = 3023 Leight Avenue Result: 109 Vine Hill 3023 Leight Avenue NOT: 109 Vine Hill 3023 Leight Avenue But if A2 and B2 are the same, I want to show the address only once. Example: A2 = 109 Vine Hill & B2 = 109 Vine Hill Result: 109 Vine Hill NOT: 109 Vine Hill 109 Vine Hill One more variable than I didn't think about, if cell B2 is empty how can I make sure that only A2 is populated and that I don't have a blank line on the bottom? Example: A2 = 109 Vine Hill & B2 = (Empty) Result: 109 Vine Hill NOT: 109 Vine Hill (Empty Line) Thank you for your help. Sincerely, PaolaAndrea Tag: Creating Amortization tables in excel 2003? Tag: 783841
  - 13
    - Transferring data from one wksht to another (detail and summary) I have a total of 3 wksht: Staff, Detail and Summary In staff wksht I have formula in cell 'N' that returns Past due accounts; when past due returns I need the whole row to transfer to detail wksht and I need #'s in cell F or K (there's #'s in either F or K, not both)to be added and tranfer to Summary in cell F6 Please help. Thanks -- Elena Tag: Creating Amortization tables in excel 2003? Tag: 783824
  - 14
    - How do I keep numbers formatted within a concatinated cell? I'm trying to to a number's formatting withing a concatinated cell that contains both numbers and text from other cells. This is the formula that I'm currently using with it's result. ="Procurement of "&'Pricing Sheet'!B10&" timbers totaling approximately "&'Pricing Sheet'!E52&" board feet of "&'Pricing Sheet'!B6 What's being shown: "Procurement of 100 timbers totaling approximately 5555.55555555555556 board feet of Southern Yellow Pine" What's desired: "Procurement of 100 timbers totaling approximately 5,555 board feet of Southern Yellow Pine" Please Help!! It would make my life a lot easier!!!! Tag: Creating Amortization tables in excel 2003? Tag: 783822
  - 15
    - opening excel 2007 files from desktop There is one laptop that has excel files saved on the desktop and when we double click to open them excel 2007 does open but the file does not appear in excel until we go to open and select another file and then both files will open. I have tried to reinstall and that did not help. If we open Excel first and then double click the file from the desk top the file opens right away in Excel. I am at a loss on what to do with this machine. Any ideas???? Tag: Creating Amortization tables in excel 2003? Tag: 783818
  - 16
    - Comparing and inserting cell from two files into third file Hi, I am trying to merge the data of two files into one file. say I am to read from file A and file B and store it in file C. A and B have department numbers, project number and entity and some other data. A and B will have the same project, dept and entity numbers. but ether of them may be missing some data. so for that i need to get them into a 3rd file. the third file should have the project dept and entity numbers from both the files and their corresponding data but they should not be douplicated in file C. can any one help me with this. thanks Tag: Creating Amortization tables in excel 2003? Tag: 783816
  - 17
    - Combining Cell Contents (Part 2) Hello, Thank you for your previous reply, it was great. One more variable than I didn't think about, if cell B2 is empty how can I make sure that only A2 is populated and that I don't have a blank line on the bottom? Example: A2 = 109 Vine Hill & B2 = (Empty) Result: 109 Vine Hill NOT: 109 Vine Hill (Empty Line) Thank you. Sincerely, PaolaAndrea Tag: Creating Amortization tables in excel 2003? Tag: 783813
  - 18
    - Sharing a Workbook But Restricting Access to Certain Sheets Here is what I am trying to create: A workbook with 10 seperate sheets. Each sheet will be for a different employee to enter certain information. I would like to make the workbook accessible to each employee, but I want them to only be able to view their sheet. I don't want them to view "Sally's" sheet and see her information. And I want only certain cells within each sheet to be able to be edited by that person. Does that make sense? Is this doable?? Thanks, Brandy Tag: Creating Amortization tables in excel 2003? Tag: 783811
  - 19
    - Howto: Align print-out to the right side of paper Normally Excel will align the data to the top-left of the page when printing. Is there an option to align it to the right, or bottom? Tag: Creating Amortization tables in excel 2003? Tag: 783809
  - 20
    - Combining Cell Contents Good Morning: I have two cells that contain address information, one is mailing and the other is street address. I want to create a formula to compare both cell and to let me know if the address if the same, if the address is not the same I want to combine them. I know that to combine a cell I use the formula: =A2&B2 How do a enter a paragraph mark in between them? meaning how to lines instead of one long address without breaks? example: A2 = 109 Vine Hill & B2 = 3023 Leight Avenue Result: 109 Vine Hill 3023 Leight Avenue NOT: 109 Vine Hill 3023 Leight Avenue But if A2 and B2 are the same, I want to show the address only once. Example: A2 = 109 Vine Hill & B2 = 109 Vine Hill Result: 109 Vine Hill NOT: 109 Vine Hill 109 Vine Hill Thank you for your help. Sincerely, PaolaAndrea Tag: Creating Amortization tables in excel 2003? Tag: 783796
  - 21
    - Simple formula question I'm trying to add up numbers in a column. It should be very simple, but I keep getting a zero result. The formula is =sum(J5:J113). I thought that the problem was maybe in the formatting of the numbers in column J since they were exported from another program, so I went into the Format menu and made sure they were formatted as currency. I'm still getting a zero result. Any other suggestions? Tag: Creating Amortization tables in excel 2003? Tag: 783793
  - 22
    - Excel 2003 SP2 / SP3 Save / Save As over a WAN Can any body Help !! Some of our Bermuda clients (not all of them) are unable to save to various Shares (Rights are set by groups - clients in NY in the same groups as our Bermuda clients are not having this issue) on our NY Servers. Example - a mapping to \\Server1\vol1 - then drill down to Finance then to Closing - they're unable to save a new file using Save / Save As in the Finance or Closing directories. They are able to open a file in either directory that already exits and do Save but not Save As. If they map a drive to \\Server1\vol1\Finance - Save / Save As works. If they map another drive to \\Server1\vol1\Finance\Closing - Save / Save As works. Same issue is happing on another share on the same Server. Mapping to lower directories solves the problem. This Issue just started happening. We show no errors on our WAN equipment (Routers / Switches) or accelerators. Tag: Creating Amortization tables in excel 2003? Tag: 783791
  - 23
    - Use formula to populate cells Hello All, I have a Workbook with 3 worksheets Sheet1 called quote form Sheet2 called Help Sheet3 called Data In Sheet1 I have the following information... Cell A4 - To: B4 Imnot Kim Cell A5 - E-mail: B5 "Populate" Cell A6 - Phone: B6 "Populate" Cell A7 - Fax: B7 "Populate" in Sheet2 I have non related data to what I'm trying to accomplish Sheet3 I have the following information... Name Contact Tel Fax Email Address Imnot Kim Ron 905.123.4567 905.123.4567 123@4567.ca Yournot Kim Paul 416.123.4567 905.123.4568 123@4568.ca Whose Kim Sandy 604.123.4567 905.123.4569 123@4569.ca Wheres Kim Antonie 780.123.4567 905.123.4570 123@4570.ca Hi Kim Sheldon 403.123.4567 905.123.4571 123@4571.ca By Kim Rose 205.123.4567 905.123.4572 123@4572.ca Here's my dilemma, when I type in Imnot Kim in cell B4 I would like Cell B5-B7 to retrieve and populate the corresponding information from the data sheet. Once again Thnx, Badrasta Tag: Creating Amortization tables in excel 2003? Tag: 783790
  - 24
    - Any sample to connect a remoted database through Excel Does anyone have any sample to connect a remoted database through Excel? I need to make a connection with a database in China, and I locate in HK. Could anyone give me any suggestions on what I need to retrieve any data from a database? What I can think of is URL, username, password, ... Does anyone have any suggestions? Thanks in advance for any suggestions Eric Tag: Creating Amortization tables in excel 2003? Tag: 783789
  - 25
    - Excel Workbook I saved a doc to Excel Workbook; how can I find it? Tag: Creating Amortization tables in excel 2003? Tag: 783784

how do I create amortization tables in excel 2003

RE: Creating Amortization tables in excel 2003? by GarysStudent

GarysStudent
Sat May 10 05:38:00 CDT 2008

Start with a good template:

http://office.microsoft.com/en-us/templates/results.aspx?qu=amortization&av=TPL000
--
Gary''s Student - gsnu200785

"Mpho" wrote:

> how do I create amortization tables in excel 2003

Top