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 ...

Is it possible to transfer data from several workbooks in to a single
workbook when the workbook the data will end up in has a different template.
for example the second workbook has 26 fields, but the all the other
workbooks have only 21 fields and I only need the data from 19 ...

I have created a series of Macros in excel, and have alocated them to a
custom toolbar I have made.  Is there a way which I can save the toolbar and
macros with the excel spreadsheet, so tht the whole set-up can be used on a
seperate computer?