|
|
Loan Calculator for more than 30 years by
Ray_Johnson
I'm using the Loan Calculator (Amortization Schedule) that comes with
Microsoft Excel (I'm running Excel XP).
I need to change it so that it will allow more...
|
|
1 |
144 |
|
|
|
March 30th, 2005 08:31 PM
by C&S
|
2 |
152 |
|
|
data entry from two cells across worksheets by
sp-googling
I'm wanting to have cells take the value of the last one updated across
worksheets. I've found the code that accomplishs this within one
worksheet, but not...
|
|
7 |
165 |
|
|
|
|
2 |
258 |
|
|
|
|
1 |
247 |
|
|
long formula obscures cell view by
KG
I have a workbook with very long formulas (basically external links to
several other workbooks). As a result, when I point to a cell containing such
a formula,...
|
|
5 |
123 |
|
|
User name in Footer by
Brian Allen - McKEOWN INC.
I'm trying to put the user name in a footer and can't figure it out.
I want "This file was prepared by 'username' on &.". But I
can't get the username in...
|
|
8 |
119 |
|
|
Capitalizing selected area by
J.E
Is the correct verb 'to capitalize' ? :D
Anyway, how do I make letters in selected
area go CAPS? Its a workbook that is going
to be filled up in daily basis...
|
|
3 |
78 |
|
|
Display Worksheet in Excel File by
Rowf
I want to Display the worksheet name on the Excel Spreadsheet itself.
ie. On Worksheet1, Cell A1 = Worksheet1
How do I do this without having...
|
|
2 |
118 |
|
|
Moving columns into rows by
jim314
I'm constantly getting e-mails at work that require me to make a spreadsheet
of the names the e-mail was sent to.
The text looks something like this (and it's...
|
|
1 |
187 |
|
|
soft-coding lines in a macro by
GJR3599
I am trying to get a macro to find the last line of data (Ctrl+Shift+Down)
and then go down one line...this keystroking hard-codes the line i have
selected but...
|
|
1 |
70 |
|
|
Formula to Text to Formula by
Bonnie
Hi there! Using E02 on XP. Have zillions of formulas to
create and if I can get my template going, it will be much
easier. Only problem is this: I used Replace...
( 1 2)
|
March 30th, 2005 10:57 PM
by RagDyer
|
13 |
190 |
|
|
|
March 30th, 2005 11:11 PM
by retman
|
5 |
73 |
|
|
sumproduct and even numbered rows by
Jack Sons
Hi all,
In column C I have amounts (e.g. 2345,89) in even numbered rows beginning
with C4 up to C98 and corresponding codenumbers (integers 1 to 46) in...
|
|
6 |
72 |
|
|
|
|
3 |
117 |
|
|
|
|
1 |
248 |
|
|
|
|
1 |
349 |
|
|
|
|
1 |
92 |
|
|
|
March 31st, 2005 12:15 AM
by jont
|
4 |
118 |
|
|
|
|
2 |
283 |