Pls correct me on this formula: something wrong on opening file.
Sub openreport()
myPWD = Application.InputBox("Password Protected! Please Enter Authorized
Password to Continue!")

in sheet SOURCE in a column A I have 268 nubers, which have dependents
to the sheet CODE. In sheet SOURCE in column B I need to get
information, what are dependents of the value in column A (their
addresses). I tried to use some info functions, but it was not good...

I want to create a heirarchial drop down lists in excel.How do I do it.
For Ex-
Column A has the following drop down elements- Animals,Birds,Continents
Column B should have the following drop down elements depending upon the

I hope this is the correct place to ask my question...
What I want is to create a 'conditional formatting' of two colums.
Example:
1|..a..|..b..|

Firstly, let me mention that i am relativley unfamiliar with excel :(
My current project is based around the analysis of soccer playe
statistics. I have a worksheet (lets call it worksheet 1) which has
drop down menu where you can select the player, and then anothe

Hi,
I would like to see any excel formula (vlookup/ index & match) can help to
return the desired value:
See below -

I would apprecaite providing me a solution to copy and paste the Subtotals
in Excel. Generally if we copy and paste subtotals it will come with all the
details of the Subtotals. I don't want details I need only the Subtotal to
come when I paste. Please help me to solve this issue ...

I am trying to use this if statement:
IF((J8*J25-J10*J25)<=0,"0",IF(J8*J25-J10*J25>0,"J8*J25-J10*J25")), the
problem is I can not figure out how to tell it if the answer is greater than
0, put in the number and not J8*J25-J10*J25, can anyone help?

Looking for a formula that will give the value of the leftmost cell (column
A), 1 row up from a cell containing the maximum value in a table of values
contained in the range $B$5:$AF$97, named rng.
I can find the address of the max value via the array formula:

Somehow, the highlight feature has become locked and whenever I move the
curser about the spreadsheet, all I achieve is to highlight the cells.  I
cannot enter any date.
Hor do I correct this problem and how do I prevent it from reoccuring?

My equation calculates an interest rate
A1*C1^B1 + A2*C1^B2 + ... + A11*C1^B11 = D1
Columns A, B and D are given. The only unknown is C1 which I want to solve
for. I can do this using solver but I would like something that updates when

I have Microsoft Excel 2003.  We are collecting mortage payments on a sale of
property.  I need to know how to set up formulas for the spreadsheet to
reflect simple interest and irregular payments.  I found the answers
separately but don't  know how to do both in the same ...

Hello,
I receive a URL from Web ( an external report) and I need to export it to
Excel file in full report.
The web contains of 800 row of records and each time i only get the 1st 20

=IF(K7=1,
IF(AND(A7=51),M7/1000*$N$2,M7/1000*$O$2),
IF(AND(A7=52),M7/1000*$N$3,M7/1000*$O$3),
IF(AND(A7=53),M7/1000*$N$4,M7/1000*$O$4),

I have a very large database where I want to filter out numbers that do
not have certain two digits as their last two. For example, the column
based on which I want to filter out data contains numbers like
197301310153. I want to filter out anything that does not end in 53.