I hope that anyone can help me.  I have 300 excel files to process, I
don't what to have to open all these files one by one.  What I have to
do is the following: I have to modify the excel files in some simple
way, add a column and insert the filename of the corresponding file in

=NPV(After_tax_investment_rate,I14:I23)
The problem I am having is that the I14:I23 needs to vary. In one instance
it needs to be I14:I50 another time I14:I20. Is there a way to automate that
so it automatically sees the different length on the list and enters it

I'm trying to use an if statement and I'm not sure how to write it... here's
what i want to accomplish:
If cell H17 is blank or equal to 0 OR if G17-H17=0 then make cell I17 equal
to zero, OTHERWISE multiply G17-H17 by 1.5

I'm probably being stupid, but here's my dilemma! 8o)
I have a date in cell A1, say 19/3/04 and I need to fill in the next 35
dates automatically - each being incremented by exactly one month:
19/4/04

I am using ACCESS 2002 and EXCEL 2002.  I am trying to link an ACCESS query
to an EXCEL file that can be refreshed each month with new data.  I have
downloaded ACCESS LINKS but can not find any help in how to use it to
accomplish the task above.

I've got a column in my excel data that contains text whereby some of
the entries are in italics.  I'd like to somehow be able to isoloate
those items (via filtering or other means).
I'd be willing to insert a column so that if the cell to the left is

Hi, it is easy to mailmerge database items from an excel document into
a, say, data labels in a word document. Is there an easy way, other
than pasting and transposing, to do it in the opposite way? That is :
to create long lists of line items (e.g. 1st line = name; next line =

How can i make this macro check for eksample one collum to another collum.
This is a phone bill that is going to be checked agains a phone book, if some
of the numbers is equal to one of the numbers in the phonebook, it is going
to autofill the name for this nr in the phone bill.

I think my bank has been underpaying me interest on a 5 year certificate of
deposit.
How can I calculate the interest I should be getting on, say, $2,500 for a
five year term at 6.77% and show how much interest accrues at year one, year

I have Microsoft Excel 2003 and have a problem with hyperlinks. I have
cells in which I have right clicked chosen hyperlink, named it news and
then entered the hyperlink adress as www.news.com.au . When i click on
the news hyperlink i receive an error message saying "Unable to ...

I am trying to create a hyperlink in excel, that when clicked will open
another excel sheet and highlight, or direct focus to a specific
column.  Any ideas on how this can be done using basic excel
functionality or by writing a simple macro?

I have a template with a cell reserved for the page number.  I need to print
the template 200 times with the page number incrementing for each page
printed.
In other words, the first page printed to read 1, second page 2, the third

I have a sheet full of dollar and cents amounts like $22.38 and
321.14. I want to display these amounts rounded off without editing
each cell to remove the pennies and without going through and putting
each amount in the ROUND function. I understand the ROUND function

How do I display -123 as (123).  I have done the calculation  =(c32-c34) and
I want the negative number I just want it displayed with parentheses rather
then the minus symbol.  Any help would be appreciated.
Thanks

i have over 1000 duplicate numbers on one worksheet what type of formula do i
need to run in order to bring back how many  ie 2001,2002,2003, 2010 etc.
thanks