| Thread | Last Post | Replies |
|
| How to calculate my mortgage payments interest part? | 18 Mar 2008 19:55 GMT | 5 |
I'd like to know how much of my mortgage payment is interest and how much is principle. I know my interest rate and how much I borrowed (ofcourse!) and how much I pay each month but am wondering how to figure out what part goes on the interest.
|
| VBA macros | 18 Mar 2008 19:17 GMT | 1 |
I have a project that has 6 macros defined with only 1 sheet which is named PTS08. I would like to run one of the macros. They all open text files. Let's suppose one of them is ADPS08.TXT. I want this file to go into a sheet called ADP. The sheet doesn't exist. How do I do this?
|
| Lock Cells with a Forumlae | 18 Mar 2008 18:19 GMT | 3 |
How can I lock cells in an Excel 2003 template such that cells with formulae cannot be edited or have data entered into them? Thanks!
|
| Document issues | 18 Mar 2008 18:08 GMT | 5 |
I have a document where we have multiple issues. When we go to resize a "box" with text in it, it will not make the box big to fit all the characters in it, just the last few lines. Also when we print this document on 11x17 it prints it on the right paper just makes the text
|
| Payroll calculating | 18 Mar 2008 17:33 GMT | 3 |
With a rang of cells equaling 90,(a1,b1,c1 and so), how do you get the calculating to stop at 40. Useing Excel 2000
|
| Paste Formula that skips a cell. | 18 Mar 2008 16:49 GMT | 2 |
I have a user that has received a file from a client that must not be altered apart from the required edits. The user has already discounted VLookup. The list from the client has two rows per "site".
|
| Possible to access macro in 1 workbook from any open workbook? | 18 Mar 2008 15:26 GMT | 2 |
I have a macro that I run by hitting Ctrl-M. It's in Workbook A. I'd like it to be able to be run from any open workbook. Is there a way to do this?
|
| VBA type mismatch error | 18 Mar 2008 13:26 GMT | 5 |
The following line is in an Excel function: j = Application.Find(v, Cells(cnt, 1).Value) When watched, v has a value of "s" with type variant/string. cells(cnt,1).value has a value of 2 with a type of variant/double.
|
| format dddd | 18 Mar 2008 12:54 GMT | 1 |
if I apply the format custom - dddd The cell returns the name of the days in Dutch. How can I make that this name will be returned in French?
|
| Reassigning keyboard shortcuts | 18 Mar 2008 11:58 GMT | 2 |
I tried to do this in Tools -> Customize -> Commands, but Modify Selection is gray. Can anyone help?
|
| Writing programs for the manipulation of data cells? | 18 Mar 2008 11:51 GMT | 1 |
I'm new to Excel and I think I can do this with macros. In that case, where can I find a list of Excel functions?
|
| How can I | 18 Mar 2008 09:13 GMT | 3 |
Could anyone please tell me how to delete values from a cell automatically every time a work book is opened. What I need to do is:- On everyday from last year 2007 each cell could contain a value. In 2008
|
| How to unhide rows....when they won't unhide | 18 Mar 2008 06:00 GMT | 4 |
I am having a repeated problem. I receive files that has hidden rows. When I Rclick and select unhide, they are still hidden. When I select Format, Row, Unhide, they are still hidden.
|
| where can I find a nurse staffing templatew for excel 2000 | 18 Mar 2008 04:56 GMT | 1 |
I need an excel template for excel 2000 that would allow me to staff nurses
|
| How to ask whether a value is in a range of values, and produce a YES/NO answer | 18 Mar 2008 04:38 GMT | 2 |
I know there is a way to do this, but I can't quite come up with it. I have a table in which I am trying to match one of the fields to anothter table (i.e., to check to see if it exists in that table). I need a yes or no result.
|