I want to create 365 worksheets and name them for each day of 2006. I would
like to avoid typing each tab.
Can someone explain the method to do this?
Darrell

I have a formula to recognise if "yes" and "no" - when I copy this formula
down from say line 26 to line 1000 I get a run of FALSE
The formula I'm using is  =IF(I13="yes",SUM(C13:F13)-G13,IF(I13="no","0"))
and this works fine when I put in 'yes' or 'no' but were it is left blank I

I have a formula that totals a balance of columns C to F and I wish to copy
this formula down to line 1000. I am currently upto line 25 and lines 26 to
1000 shows the last balance, ie 1200 all the way down to line 1000.
The formula I am using is    =H24-SUM(C25:F25)+G25

I have 52 worksheets which are titled "Week Ending 12-4-05" and so on.
I would like to extract the date (text) and enter it as a date (number) in a
cell.
Is there a function or some code that can be entered to do this?

I am looking for a help how to create a drop-down list using some functions
in a source box. I am using IF function but it seems that a number of "IF"
used is limited to 6. I have tried to use instead of too much IFs (I need 11)
a table and Lookup Function but when using it I ...

When trying to change the array in a workbook, I am getting the message
"Cannot change part of array".  I do need to change the array, I beleive I
can by pass this but am not sure how to do it.  Any suggestions?

I want to use the Sales Invoice on Excel.  It says I can customize it, but I
can't get the font or size of the font to change from "Arial  10".  Can
anyone please  help me?

Data is being entered on a daily basis into Excel.  Each day the total for
the month or year needs to be summed.

How do I turn on the GETPIVOTDATA function so that my reporting automatically
reflects the underlying pivot even if the pivot changes?

how can i see if i have two records in my spreadsheet that are the same? I
have over 60,000 rows of data.

Hi - I'm having a heckuva time trying to create a formula that wil
enable me to create an employee work schedule that will alert th
manager to scheduled overtimes. The criterium are:
- if employee works 6-8 hours, they get .5 hour lunch break that doe

I saw this function in a file that was sent to me. The situation called for a
simple division formula. I dont understand what this formula is saying.

Hi all...a newbie here.
I'm okay with many Excel functions, but I don't go too deep:  Can't d
macros, lookups, that sort of thing.
Here's my dilemma:  Sheet-2 has a list of 10 aircraft, and the goal i

I need to know how toformat my spreadsheet so it will automatically give me a
new row when I reach the end of the column instead of having to hit insert
row to add one.  Is there a way to do this?  Thanks!
Cathy

I need to write a formula that does 2 functions, LEFTand UPPER. Is this
possible?
I need to "grab" the first three leeters of a word and capitalize them to
add to numbers to create a part number.