Could anyone PLEASE help me with a single cell formula that would take the
difference between TWO cells containing Dates AND Times, and return the
elapsed difference in the following format:
"3 Years, 9 Months, 15 Days, 14 Hours, 8 Minutes, 16 Seconds"

All at once I've lost my scroll bar - except when maximized.
I must have changed a setting somewhere.
How can I get the scrollbar back?/
Thanks,

In a spreadsheet I'm creating sheets for each month with rows of data below.
Each day and month is listed in a row at the top of each monthly sheet with
the day and 3-letter month abbreviation, like "14 Apr" and 22 Oct."  I have
formatted these cells to display 90 degrees ...

how do create background of page no.

Good day --
I used the subtotal functions to generate the following report.
What I would to instead of having to insert page break of each group,
is have it generate a new worksheet for each group, and change to tab

Hi experts,
This is for calculation of bowling averages.
There is a variable length list of numbers in a row (score history of a
bowler, new scores appended to the end).

I found my tools bar.  It was hidden.
However, the file "excel.xlb" dated back in 11/05/2001.  I made some
changes on the tools bar in 12/06 (added in macro, removed the unused
ones....).  Should the file be dated in 2006 rather than 2001?

Greets all I'm trying to concatenate a column into one cell. Is thier
a way to have concatenate work on a range of cells in a column or a row.
Example:  I have Column C2..C45 and I want to have all those
numbers/letters joined in on cell togather on F2.

Is there any way you can copy an internet page to excel using a VBA
program?  I now manually do a select all and copy to clipboard.

My excel skills are almost nil and I have a task to do.
I need to calculate "rate" i.e [ (col1/col2)*100 ] based on a grouping
of 'Group'.
Eg.

is it possible to refer in a cell to the sheet name?

How do you put a variable into a hyperlink address?
Stock = TextBox1.Text
ActiveWorkbook.FollowHyperlink
Address:="http://finance.yahoo.com/q?s=IBM

I have created a form that when populated inputs data to the next empty
cell in a sheet Called "Sunday"
What i need to do now is create a form that recalls the data by
entering a name that the form looks up in the same sheet, thus allowing

I have some code that I got off of Ron DeBruin's site for  Creating a
new sheet for all unique values. It works great but it puts the header
at the top of each new sheet. Is there a way to modify this code to
make it so it does not add a header at the top of each new sheet? I'm

I have two columns of data and want to count the number of occurences
when one column has something and they other something else.  For
example I want to count the total number of occurences that have
Atlanta and 2.  The answer should be 3.  How do you do this?