I have more than 100 worksheet in a sheet and i want to save this worksheet
as workbook at once. I can do I one by one. Please help me on this.
Jai

does a formula exist so if i colour a cell on page one the contents,
including the colour, will be instantly copied onto page 2

I have used a combination of locking certain cells and then protecting
worksheet in order to prevent accidentally overwriting cells with formulae in
them. This works fine for what I want but occasionally I need to change a
formula so have to unprotect the sheet. Again, no problem ...

I have a number, say 3,450, that I want to subdivide into groups of 1,000
like this:
1000
1000

I want to create a macro that automatically runs solver when a button is
pushed.  I went ahead and recorded it, however every time I run it a dialogue
box pops up asking me if I want to keep the solver solution.  I always want
to keep the solution and I don't want to have to hit ...

I stole the bulk of the following code from one of Dave Peterson's many
helpful postings on this site. I have  a number of named lists on the sheet
called "Feed Data." The lists are named "list1," list2," list3," etc. Each
one is defined with an OFFSET function.

Hello group. I have something I've been working on for some time and
I'm stuck. Let me describe the situation.
I track my fitness in a spreadsheet. One measure of fitness is the
waist / hip ratio. This is waist divided by hip. I have a range

using the Loan Calculator template in Excel, I am trying to calculate loan
payments with optional extra payments, over 5 years.  However, every time I
input the optional extra payments, Excel shortens the loan term instead of
reducing the monthly payment amount (which is what I ...

EXCEL 2003 When trying 2 link 2 pages from different workbooks I can only get
cell A1 to come to the destination workbook.  Help.  Ema

I am using the Now() function within a function, to enter a timestamp
as a spreadsheet is populated. Here's the function:
   =IF(AND(LEN(D63)<>0,MOD(B62,12)=0),NOW(),"")
The function works fine, however, the timestamp continues to update,

Could anyone help me?   I am taking and Excel 07 class at my college, but the
computer that I use has Excel 03 (and also is not capable of downloading any
new software or trial versions).  If I do spreadsheets in Exel 03, will it
convert correctly to 07 and vice versa?

I have to work out the following problem and I can't figure out how.
A bonus formula that addresses the following requirements:
A sales person needs to sell more than 260 units per quarter to qualify for
a bonus. Create a cell that is labeled "Bonus Quantity" and put the value ...

Excel2003 ... Range A6:G6 contains Formula's
Cell A6 contains a Name (returned by formula)
Range B6:G6 contains values 0 to 7 (returned by formula & may repeat)
I wish to set conditional formatting in Cell A6

I have an array of cells, B3:J34 on sheet2.
On sheet, 1, column, I have a range of values that can be found in the
array on sheet2. I'd like to put a function on column b, sheet1 to
return the value in row 2, above the searched value from sheet1 ,

how can i auto insert a line between different blocks of data in a single
column?
for example, in a year to date export of shipments, i need a total count of
shipments for each month based on the outbound shipping numbers (BOL's).