I am prepaing a worksheet where I have one column containing employee names,
with each employee name spread across 10 merged cells. The rows of those
merged cells containing information specific to each employee..so what I need
to know is whether there is a way for autofilter to ...

how can i protect my formulae in sharable xl
workbooks..so that others can't alter by mistake?
-via135

if statement" desperate insight is needed!!!!!! IF,Count, DCOUNT
AHHHGGGGGGG!
Good Evening,
I am having difficulty writing an If statement on my spreadsheet. What

When I hit ctrl S sheet will sort instead of save

I am starting a job where I will be using Pivot Tables extensively through
Excel and Access through Office 2000.  The employer offers minimal background
and training, but I would like to be able to see it in a different framework.
Any thoughts or suggestions for training sites I ...

Hi, I have a workbook, comprising several sheets, one of which is the Index
tab, and the rest a sheet/ tab for each user.
users often save the workbook while it is open on their tab, but i would
like to build in some VBA code somewhere, so that the workbook will always

I'm trying to hide/show tabs based upon a and end user's inputs.  For
example, let's say my worksheet is all about fruits and I have four tabs.
An Inputs sheet, which asks for general information on apples, oranges,
tomatoes (yes, they're a fruit) and then I have a tab for each ...

I am looking for an excel formula that would capture the counts of one column
(column A, that contains text and/or number) when the cells in another column
(column B) is blank.  Any help would be great.  Thanks!

I'm trying to come up with a formula that can reference a cell containing
date data and tell me what the 2nd friday of that month would be.
I.E.  Cell Value = 10/02/2006; formula would say Friday, October 13, 2006.

I have a sheet that has several columns that contain numbers, yeses, no's
and N/A's.
I need formulas to count how many times a specific value in one column.  For
example, how many times does the number 9 show up in column G, rows 8-516.

I have 2 columns that have the records like
Column A  Column  B
Bert             Dallas
Bert             Texas

Hello...
I have a worksheet that calculates a fortnightly payment which
includes an amount subject to foreign exchange, which I get from
xe.com.

Hello all.  I would like to insert a "-" into a column of numbers after the
5th digit each time.  The 1st 5 digits will not always be the same, obviously
and there are either 6 or 7 digits total in each number.  
I was trying to do this via find and replace, but I can't seem to ...

Hello, I'm trying to write a vlookup that is refrencing a letter for the
column index number instead of a numerical value. I keep getting the "#REF"
error when I try to do so. Does anyone have any ideas? I'd really appricate
any help I could get.

I'm currently designing a worksheet that contains all of our department
tasks. Each task may have one of the following status: Open, On-going,
For Review / Approval, Verified, Closed, Pending, Rejected. Each of
this status has its own assigned background cell color (applies to the