I am hoping its possible to build a function that will allow me to loo
through a matrix and find a data point.  I am currently using
combination of sumproduct formulas to find a reference in a column an
row and then return the data point.  I would like to be able to seac

How can I configure Excel so that when it opens ANY file (EXCEL), and save,  
it will 'Always Create Backups'.  That is,  want the default behavior for
Excel to save a back of any file it saves; not just new ons, and not want to
have to check every file before saving, please.  ...

I have a sheet that I created that contains an Excel object (small
spreadsheet)  that when double clicked, will open up and allow it to be
populated. After they populate it, and close it,...the data is
automatically reflected in the object on the original sheet.

When I go into Excel VBA (Alt+F11) and click the object browser, then
right-click any function and select help, the top-most links (i.e. Example,
See Also, Applies to etc.) are broken!
I have Excel 2000 with the latest SP3.  I have completely removed MSoffice

is it possible to run another macro when one completes.
Sub Test()
...
Run macro()

Is it possible to merge workbooks so that I can take data from them all to
make a chart? If so how is this done? I have a workbook for every month and
need many numbers from each workbook to make some charts to see what progress
we are having.

I have a very large spreadsheet.   I want to rotate all the data in it
90 degrees, as in, I want row 1 to become the 60th column, and row 2 to
be the 59th column, etc... all the way to the last row becoming the
first column...

JE McGimpsey
The solution you gave to me is working. Thanks for that. You have actually
given me code in VBA. IS it possible for you to guide me to use same function
using macro and achieveing same result.

I am trying to put dates into the workbook, but as soon as I hit endet after
typing "3/14/2005" I get #### all in the ccell and no date.  What in the
world is that?
-- What do you do when the only one that can make you laugh is the one who

Hullo,
I asked this question before but perhaps I was less than specific.
I want to  place a currency symbol, by itself ,in a separate cell or column
when using Microsoft Excel.

I want to change how this works, I messed around a little but no joy.
In cells C6,D6,E6  I have words date, month, year,   In cells G6,H6,I6 I
have words date, month, year,
In cells C7,D7,E7  Date is entered dd/mm/yy,           In cells G7,H7,I7

I am having to convert all files from Quattro Pro to Excel.  When I open a
document in Quattro Pro which has several other documents linked, the program
will automatically open all the linked documents.  
How do I do this in Excel?  

For a column of an Excel that contains the date of inspection (I_DATE)
Is it possible for me to use filtering to find the I_DATE between "Start
Date" and "End Date" (For instance, 1 Jan 2005 and 31 Mar 2005) OR those
records with I_DATE is null ?  If yes, how ?  This is because I ...

Ok Fellas here's one for you to get your teeth into! - I'm exporting an
Excel template from Microsoft great plains (back office) into excel, the
template is for address labels so all the formatting is set up in macros,
the template is a centrally stored file so that all our ...

I wonder if anyone can help me on this. I'm working on something which
will help me to monitor inputs. e.g. A system will send a heartbeat
every minute which I will be able capture as input to my excel
spresheet, say cell C3. Now, this are the requirement for the output: