,Hello,
I have a workbook with multiple sheets. Each sheet has 4 columns and
depending on the amount of data, multiple rows (usually between 1 and 20).  I
would like to create a summary page that would search all of the worksheets

Is is possible to combine a copy and vlookup function?  I've created a
worksheet for others where information can be selected by drop down lists.  
Whatever they select will then call up addtional information via a vlookup.  
But, in case the information they are looking for is not ...

I'd like to open my VBA (protected by a password),
delete and replace a module (macro, courtesy of Mr. Chip Pearson's website),
protect the vba project with the same password,
save the file and exit.

I have the following worksheets:
Reconciliation
Allred, B.
Hills, C.

Can anyone tell me if this is possible. I want the text in cell A1 to appear
in cell A2 only if the check box in cell A3 is checked. If this is possible,
can you tell me how to do it?

I am useing office 2007. I would like to take info from a cell and use the if
command to change it around . In the cell it can have three numbers but all
three numbers need different outputs. exsample is
Cell   Output

I created a form with the option button feature from the forms toolbar. I
have them grouped for different questions selections,but it won't isolate for
each group it will only select one for the whole worksheet. I need them to be
able to do one selection for each question.

I am trying to calculate teh SUM of a rtange of cells which I do know how to
do.  However, I am having trouble becasue of how the some of the numbers are
entered.  For example,  soem of the numbers are listed <200.  When I add this
into the calculation it returns an odd number ...

I am trying to write a macro that opens a Microsoft word 2003 document so
that I can transfer an Excel address worksheet to it in order to make address
labels. My problem is that the macro won't "recognize" the Word format.

Why does Excel’s SUMIF formula consider cells with text data such as:
2.1 and 2.10 as equal (it sums their values) when used in the range and
criteria?

How do you remove the "FALSE" value in a cell.  The formula I'm using i
simple: =IF(I7="p",G7).  Excel returns "FALSE" if I7 does not have
"p".
Help please,

I have a large worksheet named "By Week" with H columns of data, and about
6000 rows of data. I am trying to sum a range in a column labeled "Hours"
based upon a criteria in another column. In this particular case it is easy
because the column is "Weeks" and is numbered 1-53. On ...

It must be Monday.  My brain isn't working this morning.
I have a list of states and the region that they are in.  When I have a
customer, I want to simply type in the state and it will automatically bring
up their correct region.  Currently, my region data is by row:

I need a formula that will look at one cell G7 and if it is a 1, 2,3, 4, 5,
6, 7, or a then I need it to display a 1.
The formula I am using is this:
=IF(G7="1","1",IF(G7="2","1",IF(G7="3","1",IF(G7="4","1",IF(G7="5","1",IF(G7="6","1",IF(G7="A","1","0")))))))

Good morning.  A couple of weeks ago, someone from this forum, was very
helpful in my question on how to unprotect protected worksheets, with similar
passwords, with a macro.  Below is a copy of the VB script I was given.  It
worked but then I realized, the password "hi" is now ...