I'm doing a 5-year budget, from 1-1-08 through 12-31-12.  At various times
during this period, contracts may start (but not necessarily end before end
of year 5).  I need to know how many days a contract will be in effect during
each calendar year.  For example, a contract starts ...

I have a .xls spreadsheet with several thousand client comments.  I would
like to search specific key words/phrases that appear throughout the comments
to discover what they are saying collectively about our "customer service",
"payment plans", "support", etc.  

I would like to add the values from all rows in a column that are empty in a
different column; i.e, leave out the values that have a 'sell date'.
This must be pretty simple, but I would appreciate some help. Thanks.

I have table with month wise data for 3 years in column,s & data in row.
I have a cell out side the table were I will specifiy the date (month-year).
I want the data to be deleted from 1st month to month specified above and
move cells left and populate the right cells with "0".

I have a master summary workbook that will feed from 20 other workbooks
throughout my company's directory. Within each of the aforementioned
workbooks, I will link across hundreds of cells. That's a lot of links.  
Before I begin I would appreciate any feedback redarding ...

Does anyone have any suggestions on why I cannot import following link into
excel?
http://big5.fx168.com.cn:81/big5gate/www1.fx168.com/fxindex/index_usa.htm?0
Thanks in advance for any suggestions

Is it possible to have a particular colour for each series that will stay
the same regardless of where the series is moved to.
My problem is that as data series are updated with new data we overwrite the
existing data and save workbook with a different name so that we don't have

Can a cell be formulated to reflect a value based on the following situation?
Cell C5 is $34000.00; the first $1600.00 of that amount + the value of C7
needs to be multiplied * 2.25%. That value will be in cell C10. ALSO,
Cell C5 is $34000.00; the second $1600.00 up to $3200.00 ...

Is there a function or a simple formula that will return a date from a
week number?  For instance, a week for my company starts on a Sunday.
Week 15  on my calendar begins with 04/06/08.  I would like to enter
15 and have it return the first day of that week which is in my

I use the data filer function a lot.  Whe a filter is turned on, the drop
down arrow turns blue.  If tere are a lot of columns in the report the blue
arrow can be difficult to distinguish from the black arrows.  Is there a way
to change the color of the arrows to something more ...

I have a data base that looks like this in access:
emp#   Date      Time       In or out
Obviously multiple records for each employee, on each date
I would like to somehow import the data into excel though, so it looks

I have a data sheet that I want sales reps to fill out, I have provided them
with drop down lists to select dates and product information. When I open the
sheet the fields with the drop down boxes just look like every other cell on
the sheet. Is there a way to flag the cell to ...

Is it possible to have required fill-in cells in a preformatted form? Say,
the completer cannot leave the field or save the file unless the required
fields are completed?
Thanks in advance for any help you can give me on this one.

I'm completely new to macros and having a tough time getting this to work.  
I've got an IF statement in a merged cell of my worksheet (Cell B10).  Text
appears in the cell if a certain condition is met.  
I want to create a macro for this workbook only that will change the font in ...