Is it possible to add the values in a column which are in
a particular font colour? If so, what would the formula be?

Is there a method to clear (delete) values from a
worksheet without disturbing other functions thereon?  
Can this be done easily to change an old worksheet into
another ready for the input of numeric data?

I have addresses in going down a column, wiht the street
number and name (ie. 68 E Main St.). Is there a function
that would pull out just the text into another cell? I
want to lose the house number, but not all addresses will

How can I work out the hourly productivity e.g. the
number of pieces of work processed within a given time.
If a member of staff works 06:30:00 hours on shift and
process 130 pieces of work the hourly productivty would

I am trying to create a function that will calculate
information within a date range.
IE:  How many new entries made between 1/1/04 - 3/31/04;
How many ____ entries made between 1/1/04 - 3/31/04 (the

I'm a Silk Screen Printer and when I do fund raisers I spend hours organizing the orders. For instance, a football team sells t-shirts, long sleeved t-shirts, sweatshirts, and hooded sweatshirts. There are always two different prints to choose from. One about the school and the ...

Help!  I work for a behavioral health company, and with
the implementation of HIPPA, we need to round our service
units down to the nearest 15 minute unit.  Any ideas on
how to do this?  Seems like I need set a marker on the

I am trying to program a macro that will take what has
been entered in a textbox on a user form and place it in
cell A3.
Can anybody help please

I am making a user form in visual basic on excel, I have
put a combo box on the form but am unsure how to programe
it so that when the arrow is selected it will reveal all
the options available for the user to choose.

Is there a way to have excel "print" the document last modified dat
into the spreadsheet
--
Message posted from http://www.ExcelForum.com

i am tring to creat a macro that when i log in it will track the time
that i am loged in and once i log out it will display the time i was
loged into the excel feild. I am hoping to use this as an effective
punch clock for my work please help if you can or just point me in the

I have a series of excel spreadsheets that contain data
and formulae to record production information for each
month of the year.
These spreadsheets are linked to a another that selects

Help.  If anyone could point me in the right direction to have Excel
append a serial number based on every time I open a file (i.e. a quote
sheet so each time I open it I get a DIFFERENT serial number) I would
be eternally greatful.

i have several cells in 1 row which are formatted as a
time (eg. 8:00) which denotes the hours worked in a day.
(the spreadsheet is a roster).
i want to put in a formula which will add the total hours

Working at a helpdesk, I've got another "weird" request from a user.
I think this should be solved with a macro... But you may change m
mind!
User has data that is exported daily into Excel.