Hello;
I have two data string types that I am doing a search on.
ex:1
"""ACCESS, NON-STANDARD SET-UP CLEAN"""

I have used the Amortization template but would like to adjust it so
that it automatically fills in the missing value.  If I have 3 of the 4
values (note amount, term, payment and interest rate) it would fill in
the missing value and create an amortization table.

Is there an easy way to find the location of a named cell?
If I am looking for a cell named SOMECELL.
I cannot just select it in the "Name Box" on  the formula  bar.  Because it
will change the current cell to that name.

I am trying to to do data entry for an accounting journal, and I want t
have the seperate sheets copy their respective information as the dat
is entered.  For example, if I enter a Cash transaction on the entr
page, I want the cash worksheet page to copy that information as well.

I'm trying to get the date from a form to insert in to another worksheet cell
but Excel doesn't seem to recognize the date selected from combo box
dropdowns.  Does anyone know how to get around this?  Data validation is not
an option because of the number of lines in the drop ...

Hi --
I have a user with a spreadsheet that will not display. I was able to
Hide/Unhide it the other day, but now that is not working. I saved the file
with another name with same result. I am able to open the file without a

I am looking at a excel sheet.   And see formulas suchas this
=SUM((Inventory_object_FactorName="# of acquired components -
simple")*(object_scope="In Scope")*(object_no_of_units))
I was looking for the  named cell "Inventory_object_FactorName"

Hi, heres what I have xp home xp office suite. I am using a sheet for
grocery list database with auto filter.
the headers at the top are like "quantity", "Item", "catagory".
Normally I can select cells that I want to enter data and unlock them. then

Is it possible to lock definitely a VBA project?
I already saw this code on a forum in france but I don't rediscover it.
Be clear. I do not want in any manner a code to remove the protections.
What I would like, is that nobody can't attain MY projects.

I am having some trouble opening some excel documents.
When I click on the file in windows explorer the file errors out and
does not open but when I first open Excel and then open the file
by using the "File, Open" menu options the files open

I need to test if a value is a member of an array. For example A1:A300 is an
array containing data in no particular order. B1 is a value that may or may
not be one of the entries in column A. In C1, I would like TRUE if B1 is a
member of A1:300 and false if B1 is not. I can't ...

How do you transpose every third cell in a row of data to a column on a
separate worksheet.  There should be no empty cells in the column of the
separate worksheet that this information is being copied to.

If I insert
=""
in cell A1 and
=2

I have the following macro attached to a button. With regard to the
select aspect, the range will change from time to time. So I either
need to put the range ie A1:R54, in a predetermined cell, say A1 all
the time. Otherwise I need some code as part of the macro, that will

Does anyone knows whether we can autofill alphabet characters?
ie autofill :
a
b