I posted this question earlier in the execl.worksheet.functions group,
but did not get an answer. I apologize for the repost.
I need some help referencing certain cells from one worksheet in
another. Here is an example of what I am trying to accomplish:

I'm trying to generate a report and am having trouble with the formula.
Any help would be greatly appreciated.
Here is what I need to be able to do.
I have 6 worksheets in the same workbook, worksheets 1 - 5 are

I've never got the hang of pivot tables.
It's as if there's just one fundamental concept that I've missed.
Can anyone recommend a good intro on the internet.
Thanks.

I was wondering if there is a way to link workbooks in excel using
cells in the filename path.  In otherwords if you wanted to create a
summary sheet from multiple workbooks, would there be a way to use a
cell reference in the name instead of an explicit reference. ie:

 Is there a way for excel to extract a snippet of data from a text string?
For the following string,
Form:FOUR:OL_FRYEN:00:Text:ON
I want to extract the data between the 2nd and 3rd colons, so the result

Drawing Revisions are tracked first "in house" with a Letter.  Then
when issued to a client they are issued with a Number.  For Example:
blank line
blank line etc.

I have an excel spreadsheet in which I need to sort row with column headings
that are mixed between merged and unmerged cells.  In other words, I have
merged columns for employee name, project number, id and then have additional
columns that have beginning date range and ending ...

Help - I have a column in excel that contains names, such as:
Joe Smith
Joe E. Smith
Joe Edward Smith, esq.

 Is there a way for a Macro to open a text file, then copy it's contents to
a spreadsheet and name the tab so it matches the name of the text file?
Then repeat this for 200+ text files in the same folder?  I thought I saw a
solution here a while ago but I couldn't find it.

I need a function that simply counts the number of cells in a range.  Not
based on a condtion, simply the number of cells in a range.
Obviously if I'm doing this once I can simply put in a constant.  (It's easy
to see that the range A1:A50 has 50 cells.)  But I need a formula that ...

Is there any way to exclude a cell from a range.
For example, in Cell F10, I'd like to calculate the sum of all OTHER cells
in that row, excluding F10 itself.  But SUM(A10:Z10) includes the cell F10,
and therefore generates a circular reference.  

I have some VBA code as this:
rrows=lastrow/4
if lastrow is 138 then rrows should be 34.5 but I always get 34(no decimal)
How do I fix that

I'm trying to do something that seems like it should be simple.
In Cell A10, I want conditional formatting that says:  if Cell A10 is not
blank AND Cell C5 = 1, then apply conditional formatting.
I can use the Cell Value Is for the A10 check (applying one format), and the

Worksheet 1
Column B           Column K
Delivery x                 Allocation A
Delivery x                 Allocation A

Excel 2003
I am working on a spreadsheet at work and would like to be able to change
the sorting order easily. There are two columns I'd like to switch around.
Column 1 is a list of part designators. They can begin with 1W, 2W, or 3W