Awhile back after looking for and finding the PowerToys for Windows, i had
also found something similar for the Office products.  They were said to be
low level tools that weren't really needed for any but the beginning users.  
However, i noticed that one of the tools offered was ...

hello guys...please help
      A      
1   max    
2   max

I am getting a file of prog. details daily in col.B contais Time Period,
col.G contains duration.  The file contains data of prog. from morning to
night and I want sum the duration within each hour.  
I put 6,7.....23 in K2:K19 and put the following formula in M2 and copied it

I would like to know when the last friday is on current month in cell A1, and
the last monday before the last friday on current month in cell B1.
For example, for current month, the last friday is 30 May, and the last
monday before the last friday on current month is 26 May.

Hi, I would like on the selection from a validation list to go to a
particular cell on another sheet [the same cell reference of each sheet for
each value in the list] is this possible.
Example

When I clik on an Excel book, the program opens but no file is shown.  I have
the option Ignore other applications unselected.

I am hoping that someone will be able to help with this one - any help would
be greatly appreciated.
I am wanting to calculate balances of leave accrued and leave taken by each
staff member with the leave taken being substracted from the oldest date of

When I use a custom format "#,", it displays 20000 as 20 (as if E-3
has been multiplied).
how to do a similar work to display 0.00002 as 20 (as if E+6 has been
multiplied) ?

In Book1, cell z1, I have a file location reference (F:\Home\Paul\Book2.xls)
which can change via vlookup depending on the name of the saleperson. I want
the data from Sheet 1 of that z1 file location to appear in Sheet 1 of Book1.
What formula or macro would I need to put in ...

Greeting,
I have the following code for showing text in textbox as follows:
On Error GoTo 10
TextBox1.SetFocus

I've got a series of spreadsheets that I need to do some work on but in order
to do it I need to consolidate all of the data into a single worksheet first.
What I'm looking for is something like a macro that that will look at my
workbook, read all of the sheets and then append the ...

here is the given :
    A            B
1  asih    234
2   aa    334

Thanks to Jim Thomlinson for the following code to move rows to another
worksheet.
This works perfectly where the value in column AV is text however what I
would like is for this column to be a formulae. This formulae is calculated

When creating a dropdown list, how can I have an item appear for choice but
output from choice an abbreviation?  Example, I have a department list in
namedrange DEPT.
ACTG (Accounting)

The standard input form in 2007 does not allow dop down boxes to allow the
inputter to choose from options defined in a range on another page.
Any ideas?