Hi, I would like to write a formula that would automatically write the
current month, by name, in a cell.  thanks in advance.  Mike

I make a DARTS scoring workbook with 26 Teams, each Teams as is own sheet,
So every week i enter the scores on each sheet, then using a namecell, i
copy to the master sheet....
What i need to do, since i have many teams and many week to enter.

This should be pretty straight forward, but I can't find it for the life of
me. I have a document with a bunch of properties, and I want these properties
to be displayed in certain cells on my spreadsheet. What formula can I use to
retrieve the document property??

Interesting one. I have a calculation subroutine that goes row by row to see
if there are any matching records that have three same fields of information
in them. If they do then it tries to replace the value of the last record
with a formula that will calcuate a difference ...

I have a program that exports data to excel arranged like the following:
                                  Property 1               Property 2      
      Property 3
Person1   Code1           10 (Hours)

I have 2 spreadsheets.
Spreadsheet "A" I have Raw Data with a unique ID code in column A.
I have made a pivot table with this data which is in column D on the Pivot
Table.

I have a single column in SQL query analyzer data. I copy the one column to a
single column into Excel and it creates a new column for ever space...
so "client without insurance" become A Client, B Without, C insurance.
It didn't used to do this.

I'm having a problem which led to another problem.  I'll tell you about both
because either solution would get me to where I wasnt to be.
1.  I created an excel workbook which is serving as a template.  In its base
case version there are four tabs with the titles: bond 1 present, ...

I have a data base with multiple small cities, they each have only one zip
code, and I would like it if there is a formula that would auto populate the
zip i.e. If C4=Montrose then C5=84070.
Thanks for the help

I am trying to add one more criteria to the below formula and cannot figure
it out.
Need to locate how many "C" with "GTS".   Both are in different rows.
This is what I did..but it doesn't work and have been working on this for

Hi,  I have a spreadsheet, which uses the colour of the first cell in a
column, to indicate the team that the column belongs to.
I would like to be able to select multiple columns (between B and AB)
based on the colorindex of this first cell.

I have 20+ worksheets in a single workbook - I want to protect only one of
those worksheets with a password.  (I don't want anyone to be able to view
that specific worksheet unless they have the password.)  How can I do this?

I made a small code in VBA. But when my colleague open the spreadsheet
he can´t use my  code. Where do I want to save my code, if I want
everybody to have access?
Thanks in advance

I have a spreadsheet with a column that must have a specific code inserted.  
I have a separate spreadsheet with the code and correlated info.  How can I
created a lookup field in that one column that allows me to choose from the
codes in the second spreadsheet as well as see the ...

I have a table that is similar to a multiplication table.
I would like to write a formula in a single cell (example A3) that retrieves
data from a table by matching values typed in cells A1 and A2
(Example1:  A1 has the number 5 typed in and A2 has the number 10 typed in).