I have Excel 2003. I have a workbook with several worksheets in it. I needed
to add two lines to all the worksheets so I selected them all and added the
lines - ok fine, that worked. But now I can't add anything to a single
worksheet without it going to them all! How do I unlink ...

I have entered several functions in my spreadsheet, however the cells
they are dependant on do not currently have data entered in them.  Is
there a way to retain the function in the cell, yet not have it show
"#VALUE" or "#DIV0"?

El Mariachi triple DVD set 6.69 post free
http://www.hmv.co.uk/hmvweb/simpleSearch.do?searchUID=&pGroupID=-1&adultFlag=fal
se&simpleSearchString=el+mariachi&primaryID=-1&btnSubmitSearch.x=0&btnSubmitSear
ch.y=0

As per title really
I am making a temporary database in excel which will also be a functional
model for one we are having made externally.
However because of the number of people using it at some point two people

When I put this in a cell:
=IF(C8="","",B7+1)
it is displayed exactly as typed rather than acting as a formula (which it
is).

I have to produce a recap that shows any store that is producing >=5%.  
For the recap, I need to return the store #, store name, actual % achieved
that is 5% or greater.
The recap is referencing another tab that has the store # in col A, store

What is the correct feature and term used to change a value of non-contiguous
cells all at once.  I would like to equate a particular number to a name
(text) and have excel automatically lookup all those numbers in the workbook
and change.

I created IF functions for both the outcome and fee columns.  Now I need to
be able to get the sum of the fees and wehen I try to use the sum function,
it gives me $0.  How do extract the value out of the cell and total the
numbers? I tried doing an a1=a2 and even though the a2 ...

I have cells C2, D2 and G2, H2 with numerical values in them. In K2 I want an
If statement that returns 'Yes' when C2, and G2's values match and also when
D2 and H2's values match and 'no' when they don't.
These numerical values are linked to employees and show if they have

I have tabulated data that has filters applied.
I have another template that create vouchers from this data.  Is there
a formula I can put into the fields in the voucher template that will
only retrieve visible cells from tabulated data.

I've been searching prior questions, but I can't find this exact situation.
I'm trying to set up a vlookup formula that looks in a different workbook,
finds the first occurrence of X after Y and returns the value some number of
column(s) to the right (the desired column will ...

I am getting an error when I do this.  Do you know what the problem is?  Or
if there is a simpler way to do this?
=IF(Sheet1!B61>0,CONCATENATE(Sheet1!A61," (",FIXED(Sheet1!B61,2)," -
",FIXED(Sheet1!D61,2),")"),IF(Sheet1!B62>0,CONCATENATE(Sheet1!A62,"

I have different worksheets entitled:  Sales Orders, Quotes, RFQ's,
etc....  and I want to input, for instance, part numbers on only one
sheet and have it copy the numbers to the remaining sheets in the
specified cells.  I know this may be a basic question, but I really am

I'm not sure how many Excel experts are out there, but I've got a question
for you. I'm creating a worksheet for a budget (New Year's resolution) and I
want to enter in a formula to add up the totals for a given category. For
example, I have categories in column B (gas, clothes, ...

Here is an example of my spreadsheet:
Review Reason           #claims
BAIR                              10   
BAMB                             15