what do I enter into a cell to take two times away for each other, say
20:30:00 take 06:10:00 I know what to enter when its in a 24 hour period but
its only a problem when it goes into the second day, in the help section it
says to enter date first if so please me how, if pos ...

Is it possible to have a row of cells for instance A1:A8 and whenever A1's
data shows in another location, for instance Sheet2 C1, that it
automatically can populate A2:A8's data into C2:C8?  In other words, linking
1 cell but have it drag the others along with it.

I want the end user to select items from a table (such as a row) using a
list box, check box, or whatever works best, and only have those selections
put into another sheet in a workbook.  I've run into a problem where if I
use multiple list boxes or check boxes, they all interact ...

Is there any to put leader dots in fields (between the text and the end
of the field; useful where gridlines are not shown)? Thanks.

I'm creating a macro where in my original workbook I put a
formula where it uses another file in another drive. So I
open the second workbook first, but now I need to get back
to my original workbook to put my formula in. I don't want

I need some help, I wanted to make a condition so when a item is less
then what it suppost to be I wanted it to turn red and at the end I
would like a print out of all the item that are in red, or when the
condition is met I would like a print out. Could someone help me out

Can someone help? The following formula will not work.  I'm trying to get the
result to appear in C40
=IF(B35-C37-C38-C39-C40-C41=0,B94,IF(AND(B35-C37-C38-C39-C40-C41>0,B35-C37-C38-C39-C40-C41>B94),0,IF(AND(B35-C37-C38-C39-C40-C41>0,B35-C37-C38-C39-C40-C41<B94) ...

Hi. I'm looking for a way to replace some variable names in an HTML
file with row data from an Excel spreadsheet. I would like to create
one HTML file per row of data.
I tried doing this using the mail merge feature of Microsoft Word and

When I set "data validation" for a cell to "list" it only allows me
to use cells from the same worksheet.
How can I create a dropdown list with a range of cells located
in a different worksheet?

One of the excel file I use at work has a feature that I never seen before
and don't know what it is. It lets me display the only the data I want to
see.Cell B1 has the name of the data that is in column B. (The data's from
B2 To AH2 and is numerical) In the bottom right corner ...

I am several worksheets into a project and in naming a tab I put an invalid
character on the tab name.  Now, any touch of the keybord or mouse just gets
me an error message and nothing is active....what to do?

First off all, Merry Christmas everyone.  I woke up early to see if Santa
had brought me Office 2003 Professional but still not sure as everyone is
still sleeping.  So I figured I'd log on and learn something as I always do
in these forums.  Anyway, I have a few questions I'd ...

In match set of five games I want to keep track of the
wins and loses of the matches. Example; if the number  
entered in cell b5 is greater than the number entered in
b6 then a 1 (for one win) is entered in cell v5. If not,

I am trying to select multiple text boxes for formatting the font but seem
unable to select all of them other than to click on each one individually.  
Is there an easy way to select all of the text boxes at once?

I just installed Microsoft Office Professional.
I have been using Open Office for spreadsheets.
I can copy and paste my files into Excel but what is the best format to save
them in that carries all the formatting?