Is there any way to print an entire workbook at once... if some of th
pages are to be printed landscape, while others are potrait? I jus
combined 20 different but related files into one workbook, but now I'
having trouble printing the whole batch. I really don't want to prin

First of all THANK YOU for all the great posts... has been a great hel
for me... Uptill now I have always been able to find as answer, bu
this one I cant find. Hope you can help me out
Question:

i am looking for some help
i have a spreadsheet and  i want to keep track of my patients
all of my patients are given  ID#     MR Smith =278
i would like in column "A"  input the number "278"

I'm trying to use data validation to restrict the text allowed in a cell.
I want to allow the cell to contain any combination of 7 specified
characters. If the permitted characters are for example - a,b,c,d,e,f,g then
'a' is allowed, 'gddf' is allowed, 'gga' is allowed etc etc, but ...

I have a spreadsheet with a column I would like to conditionally
format.  This column contains IF formulas.  It says, basically, this:
IF(E1<D1,LOW, IF(E1>D1,E1<C1,MEDIUM, IF(E1>C1,HIGH)))
I would like conditionally format this column so the cells with value

thanks for the help
but how do i spell the number Rs.1,55,50,500.50 (ie, One Crore fift
five lakhs
fifty thousand five hundred and fifty paise) in indian rupee

I want to merge text under the following criteria,
First issue (data in Col A in sequence)
Col A(text)   Col B(text)
a   gg

I have an Excel sheet with many lines of data.
I would like to know if there is a possibilty to create a field which will
execute an sql-statment on an MSsql Database
and will return the result. Some thing like (select name from address where

I need spellnumber  macro  to show indian rupees (like crores ,lakh
,thousand and paise ) and also to view the number as 1,50,000.00 urgen
--
Message posted from http://www.ExcelForum.com

HI to all who reads this!
I have created a schedule for my employees at work.  There are 3
sheets representing different departments (here, far, and back) with
multiple employees.  I have them set up for a 7 day work week.  I also

I am making a workbook with 6 or so sheets, it's to go on our intranet
I want to make only 5 of those visable data 1-5 and the 6th (admin)
only visable to me as the author of the workbook, data1-5 only
viewable and NOT editable by anyone except me as author.

I am working depreciation rates  , it requires to calculate the numbe
of days between The date of  purchase ie, 09/07/2003  and year endin
31/03/2003  with year as 365 days . There are hundreds of entries
--

i work in a medical center all of my patients have been given
patient   ID #    Mr Smith = 276
is there a way that all i have to do in column  "a" is put "276"
and in the same cell  in column "b"  Mr. Smith name will show.

I have a spreadsheet that
say in  B2  i have three different  inputs optinons
when i put the letter  "A" in i want the cell to turn red
when i put the letter  "B" in i  want the cell to turn blue

Is there a function that will find duplicate entries and delete them? For
example, if B7 = B8 then delete row 7 (or 8)?  Maybe a macro I could write?
Or better yet, maybe somebody has already written something I could
"borrow".