I have two sets of data. The one contains rainfall for everyday of the year
and the other contains the closing prices of corn on CBOT on all trading
days. How can I get the CBOT prices for a specific day to match the rainfall
for that day so that the corresponding numbers appear ...

 I want to uncheck the check box that exists a tab called "Quiz" once i
open the excel sheet,is it possible?

Is it possible to have in cell A1 the name of a sheet tab (for instance X) of
the workbook and in ceel B1 use the function hyperlink reference to cell A1
so that in B1 its created an hyperlink to sheet X?
Thanks,

I want to create a search box in Excel to search for data in another
worksheet but the same work book. Is this possible and how do I do it?

I have column with values. some of the cells are with color. i have index of
colors with % (probability) for each color.
I try to use formula that sum the column when the colored cells are multiple
with the % in the index according the color they have (blank cells will sum

I am trying to build a maintenance cntract tracking system. This workbook
contains all my infrastructure assets, maintenance start/end dates, contact
details, contract numbers, costs and other miscellaneous data. One of the
results I need to produce is a list of all maintenance ...

I'm new to office 2007 suite. I find it difficult to navigate thru the main
menus at the top since it is very different from word 2003.  Often I dont
find some of the menu items which i am used to.  Kindly explain me the
diffrences in navigating thru the menus.

I want top create a graph for 2 types of utilities. Per utility, I want it
to demonstrate on the primary axis the available # of that utility, stacked
for actual and planned.
On the secondary axis, I want it to show the Power of these utilities, again

Does anyone have any suggestions on how to determine the date?
There is a list of dates under column A
11-Aug-07
1-Sep-07

What happened to the graphics cursor that was used to select multiple objects?

Hi Team,
was wondering if you could shed some light on this for me.
I have these 3 columns... A , E and P
I use these countif statements to try and set up my Sumproduct....

I'm working with an Excel file consisting of 8 worksheets, each one having
an average rows of 6000.I'm applying many regular formulas, array formulas
but no macros or function and concequently the speed of calculation is too
low and kinda boring.THE iTERATION SETTING FOR MY EXCEL ...

Hi. Is there a way to check a range of cells within a worksheet to see if
they are null, and if so to replace it with a zero? I tried reformatting the
column, but it doesnt do anything with the nulls. It needs to be a number
because I am importing it to a linked file.

Does anyone else have Excel crash when they try to scroll with the mouse wheel?
It's very annoying, I had about 10 crash reports yesterday because I'm so
used to the scroll wheel.  I simply scroll up or down several times with the
wheel and Excel will eventually crash.

I'm wondering if Excel ignores OnKey statements at times.
I used OnKey to jump to a sub when the Esc key is pressed. I want it to work
within the context of a macro displaying a form. However, if a form is
currently visible, pressing the Esc key does nothing. Once the form is gone ...