is there a way I can protect and unprotect more than one sheet at a
time. I have 40 sheets in a workbook and would like to
protect/unprotect 16 at one time. I know I can do it one at a time but
I find this time consuming. Thank you, Wally

I am trying to setup a spreadsheet that will display information stored on a
network server for a simplified report.  I have found how to access and link
to another workbook stored on a network drive.  The file that I will be
accessing is replaced daily with the new report.

When skipping around in a table of data to update certain cells, its quite
common for some to click into the cell, enter the new data, and then click
the next cell where data must be updated. I have found that when Validating
data at these cells, validation does not work unless ...

I have a spreadsheet with 300 rows and colums up to IR.
The columns repeat- #, description, size. I need to convert the spreadsheet
sp that it is 3 colums wide only with the title above and have all of the
information drop down into these.

I have a worksheet from which I want to extract certain values from each row
depending whether certain condition has met or not. The details are as
follows:
1.    Column N has an "IF STATEMENT FORMULA" which puts an "X" if it does

I posted a question the other day about the COUNTBLANK function because when
I used it to count the blank cells returned by the formula =IF(a1="","",a1)
it didn't work unless I deleted the contents of a1 twice.
I have now tried this on my home PC running Excel97 and I get exactly ...

In Column A I have Branch Code, Column B sales person, and C to G are
various sales types.
Can anyone point me to a macro which will take all the data for one branch,
and save it to a file called branchname.

I am trying to find a form which I can put outgoings and income which will
auto add showing me the totals in both colums any one out there can help
please, it rather urgent, all I am looking for is a straight forward who its
paid to and where its come from

I have about 6 columns of data, but only 3 are important in what I'm
trying to find.  Here is an example of my spreadsheet:
Score   FY      Awarded
131     2001     1

I discovered that if you click on the Borders icon on the Formatting
toolbar, after you have created your Conditioning Formatting, click on
Draw Borders . . . you can change the borders as thick as you want. Use
the slide bar and scroll down to select the border you want. You ...

When I go to use conditional formatting I find I can only use a subset of the
normal border line thicknesses.  Is there any way to select a thicker border
when using conditional formatting?

I have a worksheet containing the total of each invoice & then that gets
divided by two and placed into two seperate columns. I would like to retrieve
the total of a given number of invoices by entering a start inv.# & a finish
inv.# on a different sheet. Can anyone help me?

I have a master or primary spreadsheet lising purchase orders along with many
details of the POs. This master spreadsheet is used by our manufacturing
partners in China who update the spreadsheet weekly with the current status
of each PO.  I need to create a separate spreadsheet ...

I have several sheets that includes information on several parts that were
measured and I would like to create a summary sheet that aranges the data
from the part sheets and into the summary sheet while putting them into a
column, there I can do some analysis on them.  I can hand ...

I closed something in the toolbars and the edit bar went missing, how do I
get it back... in case that isn't what it is called, it is the bar that shows
the contents of a cell when you click into the cell.
Thanks