I have approximately 50 different Excel files varying from 1 to 18 pages.  I
would like to print all 50 files consecutively with sequential pages numbers
on each page.  Page numbering would run from 1 to approximately 250.
Any suggestions about how I can do it?

I am trying to count how many record meet three conditions.  I have
been using a Sumproduct formula for two colums but now I need a hird it
is not working.  It is hard to descibe but if a Sumproduct formula could
work it would look like this:

I want to insert the exact time (hh:mm:ss) I entered data into another cell.  
For example when I enter data in cell C:2 I need the exact time it was
entered displayed in cell C:1.

I would like to have Excel assign a date to a specific line of records. I
would like it to assign a date to 30 records then assign the next date to the
next 30 records.  Can this be done???  
Example -

I have an IF formula which selects a date (in text format) and, if the
criteria is met, will perform a calculation.  It works fine except it returns
a value error when the date I'm looking for isn't in the field.  I'm looking
to have it return 0 instead of value.

First, thanks to Peo for helping me truncate time AND lookup all in one
formula.
Second, I'd like help with an 'intersection' formula, if possible.  For
example, I have 100 rows and 100 columns, where row 1 is dates, and

I have two lists that I need to be linked togeather.
PSI     kPa
==     ==
100    700

Let me explain better what I am trying to do.  When I enter data in cell C:1
I need the exact time (hh:mm:ss) entered in cell B:1 and when data is entered
in cell C:2 I need the exact time entered in cell B:2 and so on.

Is it possible to copy a worksheet and link it into another one - s
when I update worksheet A it automatically updates worksheet B
--
babygood

There is one crucial feature to the 2007 Excel that has been overlooked.  
Throughout all versions of Excel there has always been the feature of
converting text to table, however there is no way to do this in reverse.  
There is no way to merge two columns of data and to keep all ...

I'm working with a spreadsheet where we are tracking a few variables
that are later calculated into a mean.  Generally there are alwats 5
variables in each mean, but every so often on of the conditions is not
met so that cell returns "FALSE" or "#N/A".  In those cases excel

I have a workbook that I need to alter, parts of it are protected and I have
no password to unprotect.  Is it possible at all to get around this?

This is off topic for this group but was hoping someone could give me an
answer.
   Total tickets sold: 2000
   Chances to win:    15

I'm trying to use the function DGET and get data from another excel
worksheets and it doesn't seems to work.
Does this looks correct : DGET ('c:\tmp\[tmp_excel.xls]'!A1:D20;"ID";A1:A2)
?

Is there a formula to have the Tab name put into a cell.
I have my Tabs with a date of the end of a pay period for payroll. In the
worksheet, I have in a cell "Pay Period Ending" with the cell beside it being
the same date as the tab.