I would like to create an excel file from another program, without using
Excel Interop.
I have created files like that before using tab separated text files with
the .xls-extension. Works fine, but....

I need to have a script in Excel that would allow the sorting of
columns from column "D" to the column before the last column with data.
I do not want the last column sorted.  The criteria for the sort is in
row 1 (Name of an employee).  Additional columns will be inserted

Ok, I have a wierd one.
I have a user that when she sometimes opens excel files from either an
attachment or her desktop, excel pops up with several errors before actually
opening the file.  This doesn't happen all the time, but when she showed it

I want the use the filtering feature but am not sure how to use it.
I want to use two criteria in my filter ... is this an option.  The auto
filter allows for one criteria, but need two.
Would appreciate detailed help.

I have over 30 excel worksheets that are:
1.  Password protected
2.  The sheet is also password protected
3.  Each worksheet contains only one tab call "All" and this tab is in

Let's say I want the current worksheet to save when the value changes in cell
b15 or b45 or e15, etc.  How can I get this done.
Thanks.

Once again, I need the help of the clever people on this group in
parsing a formula. Here's the setup:
Cell A1 is the cell the formula goes in.
If cell AA7 equals the text value "YES" (itself the result of a

Unfortunately I dont know enough about the basic language of a macro, I can
record  a short macro and make some edits in VB but thats about it.
How do I run a looping macro that at each change in cost centre (col A) I
input the code on each line beneath until I come to a blank ...

I would like cells G5,H5,I5, J5, K5, L5, M5, and N5 to be locked until
the sum of E5+F5 is greater than 0. I would like to do this for all rows
in the worksheet.

I wasn't able to find a solution in this group, but it may be because
I'm not quite sure how to search for it.
Here's the issue:
In cells E9:E58, I have input cells for the month.  In cells F9:F58, I

I have a list of 200 or so cells which are each hyperlinked to individual
web pages.
I would like to generate a list of the actual hyperlink addresses rather
than the visible cell content. The only way I seem to be able to do it is to

I have a set of date that needs to be summarized by week.  I am using
weeknum to figure out appropriate week for each value and them using
sumif to roll those up week by week.  My one remaining problem is
getting dates to display for each week based on the week number.  In

I have a really big table with date as heading :
People  11/07     12/07     13/07
john        1          2           5
wolf         5          4           7

I would greatly appreciate it if someone could assist me with this.  I
have a file with massive amounts of data:
STATE    INVOICE         AMOUNT
NY          123             $100

I am trying to add up the value of the numbers in a range of cells in
which some cells contain numbers and others contain text. In the sum
cell, I typed the formula "=SUMIF(A1:C9,ISNUMBER(A1:C9),A1:C9)". The
result should have been 434.5, but actually came out to zero. Can