I had submitted a previous question but it was getting confusing and I
believe head ing in the worng direction.
Here is the situation.
I have a document with 2 sheets. On the first sheet I have all of the sales

I use VLOOKUP from different WORKBOOKS to my report. when I insert or
delete rows in my report, then all my formulas get scrambled (#REF ) .
Is there anyway that I can do to prevent it from happening? Please
help- THANKS

I need a formula that, once locked, the cells in Column A will only accept
uppercase B's or S's and nothing else (no other letters, numbers, characters,
etc.).  HELP!?

I have a spreadsheet with comments entered in several cells.  On my computer
I can add, delete, edit the comments.  On the boss' spreadsheet, she can add
a comment but cannot edit existing comments in any way.  Plus, when a comment
is opened on her spreadsheet, it stays visible ...

This is the formula I have now in order to caculate the average sales price
that each salesperson has sold their item for.
=AVERAGE('R:\Sales Forcast\Current Forecast\2008 Forecast\[Randy
Customers.xls]Randy Totals'!AK4,'R:\Sales Forcast\Current Forecast\2008

I need a formula to do this: if the sale is less than $100 the commission is
15% of the sale, if the sale is less then $200 the commission is 15% on the
first hundred + 10% of the balance of the sale, and if the sale is over $200
the commission is 15% of the first $100 , 10% of ...

Based on many posts, it would appear that VLOOKUP is the answer to my delima,
but I can't quite figure it out.
What I have is two worksheets.  In SheetA, I have about 75 (A1:A75) rows of
data, each row is Unique.  In worksheet B, I have about 400 rows (A1:A400),

I'm trying to set up the below formula for a validation for a list box. If C5
is NSPS, then I want my list to only contain the values in 1 named data range
+ the values of the 2nd named data range. I keep getting error messages. What
am I missing? It's driving me crazy. Thanks ...

HI I have a list of data in column A. The data is a mix of numbers and text.
I need a way to know how often (the frequency) of each value. I tried the
frequency function without any success. A sample of data is below.
A

This seemed simple.  I need to determine if a date is in the fiscal year, and
if so, show data in a seperate column.  (i.e. if a date in column a is
between x and y, show the amount in column b in column c, or if no, show
nothing)

I have a list of numbers in columns A and C.  I will be entering dates when
information is received.  I want both cells to automatically fill with color
when I enter the date.  I can get the date cell to fill, but not both.  Does
anyone know how to do this?

After a range has calculated the answer from a formula, how can I change the
same range to the value displayed?

I have a range of data in A2:G30.
The cells in range A2:A30 have either 'yes' or 'no' as text in the cells.
The cells in range D2:D30 have either 'David', 'Andrew', 'Charles' or 'John'
as text in cells.

When copying & pasting dates in a few of my worksheets, they change to one
day and four years backwards, ie: 07/15/1979 changes to 07/14/1975.
Can anyone tell me what I am doing wrong?
Thank you,

1st need:  Shading every other row.  I have this figured out.
2nd Need: (this is where problems begin) I need to CF so that the date
in the cell becomes red if it is 320 days old.  I am using
"cell value is, less than, =TODAY()-320"