| Thread | Last Post | Replies |
|
| Is this an active group | 20 Jan 2007 23:11 GMT | 5 |
Please tell me if this is an active group
|
| formula to calculate savings from paying loan off sooner | 20 Jan 2007 22:41 GMT | 1 |
a formula to calculate the amount of money saved in interest payments if the loan was paid off after one year, two years, etc..
|
| PV of a single payment at the end of 10 years | 20 Jan 2007 21:33 GMT | 7 |
How can I calculate the PV of a payment of, say, $100,000 payable in full at the end of 10 years? There are no periodic payments. The annual % rate is 5%? Any help would be appreciated.
|
| Code Interferes with other Worksheet Change Events. | 20 Jan 2007 20:52 GMT | 1 |
I obtained code from a thread "Automatically fill down formulas when adding a record" and modified it because I had more formulas in more columns to carry down to new records. It works but it also interferes with other Worksheet_Change events.
|
| Excel Data Record | 20 Jan 2007 16:38 GMT | 1 |
Please can someone help me. I use EXCEL 2003 at the moment I creat a new invoce from a template on my PC then once printed the customers copy I then save the whole invoice as a file which is taking up alot of space. I use have it set up that everytime I
|
| Non standard protection requirement | 20 Jan 2007 14:25 GMT | 2 |
If I have three people who share a worksheet, can I implement worksheet protection so the Person 1 can only edit cells in range1, Person 2 can edit in range2 only, and likewise Person 3 only has rights to edit cells in range3. This will be most useful to me if it can be done. If ...
|
| Summing number in one cell and code in another cell | 20 Jan 2007 11:09 GMT | 4 |
Hi all, the problem is, A B C D E F 10 Z7DN 3 ZAPO
|
| summing calls (numbers) in category | 20 Jan 2007 09:37 GMT | 2 |
Hi all summing calls (numbers) in category ? My problem is I want to sum the amount of calls. 3 columns A E G
|
| Column Lengths | 20 Jan 2007 08:01 GMT | 2 |
Got one range "Data" and one range "Calculations." Each separated by a blank column. I write a formula into the top column of "Calculation." I then have to ask,"I wonder how far down I have to paste this formula?" The answer is, of course, the same number of rows as are in
|
| Keyboard shortcut | 20 Jan 2007 07:55 GMT | 1 |
Can anyone tell me if there is a keyboard shortcut to change the contents of a cell from positive to negative and vv. Eg. +2134 to -2134. Especally for monetary values. TIA
|
| Chart Automation | 20 Jan 2007 05:04 GMT | 1 |
I am currently creating Excel charts manually. I have been extracting data from a data warehouse (flat file), using a pivot table I slice the data and cut and paste it into the appropriate Excel chart. I have almost 100 charts at this time. This process is extremely time
|
| How Excel converts % sign in a cell and use in formula | 20 Jan 2007 03:47 GMT | 7 |
I am trying to figure out a formula in Excel that I know is simple, but it's been years.... =(B3+(B3*$F$8))*(1+$F$9) I understand about the order of operations and what has to happen first and
|
| Excel to Run a Batch File?!? | 20 Jan 2007 02:32 GMT | 2 |
I am running Office 2003. I have designed an excel spreadsheet using various macros. I now need a macro designed that can run a batch file. Is this possible? Hope you guys can help!
|
| Organizing excel worksheet tabs | 20 Jan 2007 01:37 GMT | 3 |
My user has at least 20 different worksheet tabs, he told me that he's seen an ex-coworker organize the worksheets so that sheet 1-5 are in one column in the work book and the others tabs are in another column. Is it possible to do this? Because I do not see anyway in organizing ...
|
| Excel 2003 slow after Print Preview | 19 Jan 2007 23:54 GMT | 1 |
I'm finding Excel 2003 is slow after using Print Preview. Searches of the web and newsgroups reveal that a few people have experienced this over the years but I haven't seen any responses that give a solution to the problem. Does anyone know what would cause this and how to fix ...
|