Without duplicating the cell contents in the current spreadsheet (call
it Template), is there anyway to have a dropdown list of items
(starting in cell T38 and going down to T45) from another file
([Price_List.xls]License_Only!C2 to C whatever row which will change).

I have a series of 15 spreadsheets, all having the same column
structure.  They all have the same filename barring first two letters
which refer to a persons initials.  The 15 files are stored in the
same directory.  In that directory I'd like to create a sixteenth file

Hello, I was woundering if this is possible and if so how. I want to "Auto
send" an email to 4 people once a month and in this email it would include
the information from two sheets from my workbook. The first sheet is named
"Years Of Service" and in the email I need to include ...

In my Workbook I have many cells with data validation settings as follows:
Allowed data: List
Source: =INDIRECT(L9)
Now, I`d like to change the source formula to the following:

how do i turn auto fill off?

I am working on a spread sheet where I have to determined the amont if parts
made per hour. The formula I need is a 12 hour work day, minus the down time
minutes to = parts per hour made.

I am trying to save a workbook in csv format so that I can upload into
another program.
The problem I have is that when I view in notebook i have many trailing
commas which have to bemanually deleted.

I recently created a *relatively large file in excel 2007 and when I tried to
save it as a 97-2003 workbook I too was notified that data had been lost. The
difference being from what I have read here so far is that the alert message
I received informed me that anything after ...

I am trying to combine information in 2 different sheets. Sheet one has a
column with numbers and a column with titles. Sheet two has a column with the
same numbers and other information I would like to use. What I would like to
do is pull the title information from sheet 1 into ...

I have two sets of data with the same information but not in the same order
and am trying to match the data.  In each data set I have 10 pools containing
100 loans.  Each pool has a unique ID and each loan within the applicable
pool has an ID of 1 to 100.  I need to look up the ...

   Can some one please help me?
Is there a formular that will take the info off cell b6 sheet 1 and put it
into cell e8 sheet 2?

I have created a report using VBA and Excel OLAP cube. Some of the
metrics on the report are currency numbers and are to be reported in
USD so I have formatted them accordingly using format ( e.g. "$
#,##0.00"). Some of the users in Germany who use decimal (.) as

On my computer at work I have the default font set for a True Type font
called Arial Terminal.  It's a fixed width Arial font that I like for
spreadsheets.  I've changed it in Tools > Options > General.  But when I
open Excel, the font is set to regular Arial, the proportional ...

Is there any way to zoom more than just 2 states (in and out) in an Excel
2003 preview? In so many programs there's a % option but not in Excel. Very
sad indeed and very frustrating. I'm wondering if there's some hidden
setting that I don't know about.

I have a cell which ontains an IF function. I want the cell to remain empty
unless the IF returns a certain value. I know how to use IF, but how do I
make a cell 'empty' ?
Thanks