I have an excel 2000 file that has several different worksheets. A few
I need to sort occasionally. One of them has no problem, I can just go
to data->sort and it remembers what I sorted by last time. A couple of
others I have to re-choose the columns each time; it doesn't even

Good Day.
I hope someone can help me with this little problem.
Source data is a list of Names (col A) with corresponding numerical values
(cols B to F). Each Name can have multiple, varying occurrences within this

I created a spread sheet to track capital gains/losses.  If my cost basis is
say A1  and sold is B1 what formula would work for the capital gains cell
C1.  Keep in mind it's a plus or minus.
Thanks.

Ok, this is kinda difficult to explain but i will try to. I have a
workbook with 7 sheets inside. Each sheet accounts for one big category
for example Air, Noise, Pollution. Take the "Noise" active sheet for
example, it has a Row named Procedure/Training in which i want to

While trying things out on ecxel version 2000 (I normaly use officeXP) I had
the following Problem.
When a Validation List is applied and the whole sheet is protected Excel
Version 2000 will not protect the cell and further editing using the list

iam using a vlookup formula.
i have 2 sheet, in one sheet i have database in second sheet i type the
entry but in some entry i have to use comment, but this comment does not
reflect in the sheet 1 (original data base) only the entries reflect pls help.

I'm after to form a "single column serie" using manually enetered (or
automatically changed) values in a "single cell". Lets say that the value in
A1 is changed daily and each value is written to the next row, so I have
A2:A32 serie for values from A1 in December

I wrote a loop to skip through some data (with the idea of selecting and
copying it).   For some reason, when i=44 and the ActiveCell = HM2, a
1004 error is thrown on the .Offset(0,i).Select method.
    Dim i

The online help in Excel 2007 states that the TAB key moves one cell to
the right in a worksheet. Well, on mine, it jumps one screen to the right. I
cannot find anywhere to set this option. Is the help file wrong? This option
could be set in previous versions - is it no longer an ...

Can anyone provide me with an example of a macro that acts like a function.  It will be formatted like this.
Function(Array_1,Array_2,Array_3,Data_Array_1,Data_Array_2,Data_Array_3)
Outputs True/False
Thanks

Please help debug this.  I'm trying to turn a text string deliminated with | into an array.
Option Compare Text
Function Txt_Ary(Txt As String) As Range 'Turns the string value to a multi value range
   Dim Cnt As Integer

i'll try to explain the best i can here:
i have 3 sheets, 1. table with my quantity info, 2. (source data) table
1 transposed, 3. many "mini tables" referencing sheet 2
i first setup my pivot tables and got the "mini tables" setup the way i

I am using the following macro to identify invalid data entries in
cells with data validation applied.
Sub CheckOrder()
'   Application.CommandBars("Formula Auditing").Visible = True

Crossword Puzzle and Lottery Ticket.. Excel 2002.  How to Do? Templates
Available? Thanks  Barry

Is it possible to join or merge data in multiple sheets to form a results
sheet. eg.
Sheet1 contains indeterminate number of records (variable unknown number of
records) in column A, and an indeterminate number of similar records on