I would like to add a new row after each row that contains the value "SHOW
MOVIE_PLAYER" in column F (that is, column F contains a number of different
values, and I just want a new row after the ones with that specific value).
I COULD just insert a new row manually, but there´s ...

I can't remember how I did it before but I add something to the now() formula
to keep the date from changing, can anyone help? If(b2="","",Now()) or some
condition as such once the date is entered it won't change.

I am using a spread sheet at work that was created by someone else who has
now moved on. My problem is that on some of the pages there are 2 lines, one
looks like a border at the bottom of some of the cells and then immediately
below it there is another line. The lines start half ...

I run excel 2000 (company policy) and I have the following in a Pivot
table:
User    Day    Duration
user1        30

i like to set up format for lottry ticket count.there is one problem -lottry
ticket start from 0.if i want sheet which count by it self i need to set up
value for 0 as 1.if any one know please help me. i am trying since morning.

I'm writing code in a module, and I want to get the value of a certain
ComboBox that I've added to Sheet1 tab.  Is that possible, or can I
only reference the combobox while writing code IN THE PRIVATE SUB for
that control?  ....as in:

While using the number keypad in excel2007, I receive symbols (or the cursor
jumps within the screen) instead of the numbers I typed.  What could be
causing this abnormality?  And how can I fix it?

i want to copy a cell on sheet 1 to a cell on sheet 2. how can i do this?

With three textboxes(1,2 and 3) in a userform1.
If I insert a date in textbox1, how do I get textbox2 to show the date
(textbox1)+90 days and textbox3 to show the date (textbox1)+120 days?
Using vb code?

=IF(A1 = 1 #OR#2,1,2)
What is the correct way to write the OR part of the formula? Thanks

I am a pure novice at pivot tables.
I have data that is organized in the following fields
Region (1 through 5)
Agency

Sorry dave to get back to you on an old question.
I have the following code you sent us last week.
Private Sub ComboBox1_Change()
   With Me.ComboBox1

I have a spreadsheet that has several columns that use data validation to
restrict the data input.  It was working until a few minutes ago. Now the
drop down arrows no longer appear.  If I go to Data > Validation the menu
appears and has the correct list and range.  But the ...

Any suggestions on how to make this shorter?
=INDEX(OFA!$DM$4:$DM$6000,MATCH(A2,OFA!$D$4:$D$6000,0),1)+INDEX(OFA!$DN$4:$DN$6000,MATCH(A2,OFA!$D$4:$D$6000,0),1)+INDEX(OFA!$DO$4:$DO$6000,MATCH(A2,OFA!$D$4:$D$6000,0),1)+INDEX(OFA!$DP$4:$DP$6000,MATCH(A2,OFA!$D$4:$D$6000,0),1)
many ...

Is it possible to get an average on the number of times a category appears
within a range.
my categories are
ENC L