So I have data like this:
Year Month #start #end
2001 1        4       2
2001 2        6       5

I am using excel as a magazine order data base. I would like to place all the
rows in alphabetical order base on collumm A, the first collumm.  I am using
excel 2000.
I know how to do this using Excel 2003, so i dont know what the difference

I don't know how to give a better title, unfortunately.  I want to
create a spreadsheet that I can mine for data.  But my knowledge of
pivot tables leads me to think that the sheet that I have created won't
work.  I have data in rows and columns.  Each column is information

In a pivot table database I have a column that contains text that we use for
comments or expatiations. Can this information be transferred to a pivot
table like the data can? If so can you help me to configure it properly?
Thank You

Hey,
Can someone explain an iteration to me in layman's terms?  
I built a financial model that is circular (net income --) cash t
service debt --) interest expense --) net income), which I understan

I'm a teacher with a class of 30+ children. I want to keep an individual
worksheet for each child but don't want to have to type in their names to
each tab. I would like to either 1) have a simple class list on the first
tab and then each subsequent tab named from that list, or ...

I recall a command that would allow you to break off the filename from a
fullpath filename?
example= c:\cad\cadinput\41873100.DBF
How do I make iexample=41873100.DBF

At the address
http://phhs80.googlepages.com/filter.xls
is an Excel file to show a problem with an advanced filter (with
criterion in F1:F2. My question is why does not the filter work?

Hi Experts;
I have different tables of data, which gets updated on daily basis. I
need to keep a record of tablewise data status. with updated date.
As Example:-

Normally there is a group of three boxes in the upper right corner that
allow one to "minimize", "maximize", and close the application. Last
night when I had unrelated problems, something changed.  Now they do not
show. What did I change?

I have a long table of contents for a large excel model.  I'd like to have a
button next to certain items, that when the user clicks the button, Excel
will take the user to that named Cell.  Can anyone tell me what VB code
would go in a command button to allow me to do this?

Hello microsoft.public.excel.charting my name is Zig I am trying hard
to find out how I can use a input application to input data into a
specified excel sheet. I have learned how to input the data into the
excel sheet although I need to prevent the inputs from being

Hello microsoft.public.excel my name is Zig I am trying hard to find
out how I can use a input application to input data into a specified
excel sheet. I have learned how to input the data into the excel sheet
although I need to prevent the inputs from being duplicated. I have

I'm a "casual" user of Excel 2002. I have a single-column spreadsheet
containing about 900 entries, many of them duplicates. I've sorted the list
alphabetically. Is there any good, automated procedure for eliminating
duplicate entries, or is that strictly a long, boring manual ...

I am trying to set up a form that allows a user to choose a Customer Group
first in a Combo Box.  Then, in a second box the user will choose a SIC code.
The issue is that there are hundreds of potential SIC codes for each Cust
Group.  Is there a way to allow the SIC code input ...