I would like to insert a VISIO drawing into a worksheet and produce a
comprehensive file - no need to leave EXCEL.

I need to create a formula that will add the current System time to a given
cell if a given cell is greater than 0

Hi - everytime I try to run my macro I keep getting Run-time error 1004.  I
am just a new user of macros so I am not sure what is going on.

I'm amortizing 40-year notes using PPMT to calculate the principal payment.  
For each new monthly payment I have to manually change PER in the formula.  
I'm using Excel 2003.  Is there any easier way to do this?-

I got a VB program from this board, and am trying to expand the ranges to
Columns A-G and combine contents of C if all other data in row matches that
of any other row, and if so then combine contents of column C in those rows
and delete extras.  Tried to manually add in ...

I'm amortizing 40-year notes using PPMT to calculate the principal payment.  
For each monthly payment I have to manually change PER in the formula to
update the schedule.  Is there another way to do this?  I'm using Excel 2003.

Just wondering if anyone could tell me what formula I would need to use in
this instance:
If the value in one cell falls between a certain range (i.e 12-30), I would
like to transfer it to a number ranking (i.e 1) in the cell below.

I have an excel s/s and several cells contain the same formula,
"{=TABLE(E15,E9)}". How can i find out what TABLE(E15,E9) is doing? I
think it's performing some type of calculation. Is it a table array?
any help is greatly appreciated.

Excel 2003. Input in B1:
=MOD(A1*100,10)
Input in A1:
622.2 -->

I would like cells to be filled with specific colors when an IF formula
results are true.  Is this possible?

When I insert a new row, I would like to keep the formula in a cell from
moving down.  I believe I used to use the $ sign around the cell in the
formula, but this no longer works with 2003.

I have 2 worksheets and I am using the vlookup to pull data from worksheet 2
for worksheet 1. Then, on worksheet 1, I am using the sum function to add the
numbers together.
However, there are several cells on worksheet 1 that have #n/a because there

I'm referencing a range and creating an automatically-sorted list using
VLOOKUP, sorting by the highest total sold.  Here's my reference information:
Column          A               B              C               D           E
                 Name       Week 1    Week 2   Total ...

In my excel 2003 workbook, I use a lookup formula to look up a value in a
different worksheet.  The value is found in the range, but I cannot see the
value (the range is only 1 column, and 60 rows.  What is going on?  What am I
missing?

when i copy a formula to another cell it does it correctly, but it also shows
the same value from the copied cell.