I am trying to use a Microsoft Works spreadsheet to set up class lists and
what the students have paid or owe for their class participation.  Is there a
spreadsheet template for something like this or a suggestion of how to set up
a spreadsheet to do this?

I want to learn how to use the elements (e.g. command button, option button,
combo box etc.) in the control tool box.  Can someone point me to some
articles/tutorial?  Don't seem to have much luck with help?  What is the
control tool box for anyway?

here's my problem:
I have a sheet with headers: first name, surname, address1, address2,
someotherstuff
I would like to select some rows (continous) and appropriate columns

I am trying to record a macro that would sum a column at the end of the
column.  However the number of rows will not always be the same.  How
do I get the sum to always show up at the end of the column.
TIA

This is how I have my spreadsheet set up: in Sheet 1, the leftmost row has
every date between 7-1-06 and 6-30-07 in descending order, with the
corresponding day of the week next to the dates. Columns to the right of this
have numeric information pertaining to this date/day. I ...

I wish to update the value in cell A3 from the maximum of the input update
to cell A1 or cell A2 or the previous cell A3 value .  I use the formula
=MAX(A1,A2,A3) but it is not working.  Any suggestions?
Thanks,

I am using a spreadsheet as a KPI planner.  I need to report quarterly.  Each
KPI has a day month and year assigned to it.  I would like to automate this
so that when a date is entered in a cell, the annual quarter in which that
date falls automatically appears in the adjacent ...

Is it possible to move column B fields to the row with matching content in A
From this:
 A                   B
bananas          yellow

How do I use SendMail when I have multiple addressees? The following
produces valid looking email addresses as you would type them in outlook but
the result is undeliverable.
...

I haven't worked with Excel much, but I'm guessing what I want to do is
possible.  I have two sheets in a workbook.  One lists about 100 serial
numbers.  The other lists about 5000 serial numbers with additional
information on each.  So what I want to do is filter and see only the

I am trying to convert time entries from an external source (hh/mm/ss)
to calculate in excel. What is the easiest method of doing this? I am
not sure of the properties of the external report but is seems to be
very similar to word pad.

is there a way to preserve border outlines in a pivot table after you refresh?

Looking for some help on figuring out how to do something in Excel 97.
I'm using a spreadsheet to track my expenses and spending.  Until now,
I've just been recording the date, amount, and an explanation, and
subtotalling each month.  Now I'd like to add a category and total by

I have a spreadsheet which I plan to protect all but a handful of
fields for the user to enter various money amounts. I'd like to include
a BUTTON in the spreadsheet that will force the display of any money
field to pounds, dollars, or euro. Mostly a cosmetic change, and I

I have a formula for identifying years, months, days from a past date to
now. DATEDIF(C6,NOW(),"y")&" Y, "& DATEDIF(C6,NOW(),"ym")& " M, " &
DATEDIF(C6,NOW(),"md") & " D"
I'd like a formula that can produce the same format (years, months, days)