Please help me with the following.  This is in Excel 2003.
The actual business process revolves around loan funding and setting loan
advance amounts.  Below A1 is borrowing limit, A2 is loan advance, A3 is loan
balance, A4 is advance availability

Good day,
I am making the sum of a range that varies in length.  For example
Cell(1, B) = SUM(A1:A10)
The cells A1 to A10 are a database that is updated daily, and the number of

I use formula to calculate numbe rof elapsed months between 2 dates..
=datedif(a1,b1,"m")....
but then want to round up to 1 month, in case the time elapsed is actually
less than 1 month within the =dated calcs.

I have an excel table which contains a list of products.
One of the columns contains a list of hyperlinks to each product's picture,
on a certain website.
I need a solution to get/import the actual pictures from the website to my

Hi all, I'm sure there is a simple function I'm overlooking:
Here is my desired result:  I have about 400 rows of data.   In column G, I
want to add "for the purposes of" in front of every name that is already in
column G.   So, I inserted a column F with the words "for the ...

Is it possible to search more than one word in excel.
Let say that I want to use find or another alternative to search for
more than 25 words in an excel sheet.
Best regards

I have a cell that is in date format. However it is in the wrong format. What
shows as 7/11/2001 really is supposed to be 2007/11/01. What shows as
7/12/2005 really should be 2007/12/05. Is there a formula I can use to
convert these. I dont care if the result is a date, text or ...

I know a range has CopyFromRecordset method to dump data onto a sheet, I am
wondering how to save data back into database.
Clara

I'm running a Pivot Table to show all duplicate entries in my spreadsheet.  
Is there a way for me to automatically remove those dupicate entries without
manually going back in and removing them one at a time?

I have 2 different products with 7 options each and I was trying to put them
into 6 categories.  The products are "TOP HINGE" and "OFFSET TOP HINGE" and
they each have an option of "O EXT", "12 EXT", "18 EXT", "24 EXT", "30 EXT",
"36 EXT", "48 EXT".  Now I am trying to give "TOP ...

I have a user and every time she saves a excel file it make a copy of the
file but used letters and numbers but no ext..  Is this a setting on her
computer or in excel itself..
Can any one help .. Thanks.

trying to import data from Sage but cant get a proper connection, new to all
this so following instructions in sage handbook, but none of it looks the
same as the onscreen instructions, and now i just have a single line of
address across the top of my excel sheet.  please ...

I have a question relating to the CountIF function. I have a need for a
function which uses countIF but the value meets a criteria from 2 columns (or
alternatively has two sets of criteria)
I can get it to work for one column but not two

I have used conditional formatting in a certain coloumn so colour changes
depending on input I now need rest of row to change to same colour ??

Is it possible change the default location of where PERSONAL.XLS is stored?
I want to put it on a network drive to have my macros available on all
machines(The C disc is not syncronized or backed up...)