Looking for feedback from anyone concerning this feature.  We have by
accident found that when you have two separate workbooks open, make a change
in one, do a "Save", then go to the other workbook and activate it and then
hit the Undo feature, it defaults to the first workbook ...

Hi, my first time using a discussion forum so go easy on me...
SITUATION:
I have a sheet ("weekly demand sheet") 8000 rows, 100 columns. Rows contain
various reference information i.e. unique product reference, product family,

I have a project that hides a row in the print area when a specified column
in that row equals zero.  The number of hidden rows varies depending on user
input.  I need a way to add  the same number of blank rows at the end of the
list of printed rows so that the size of my print ...

I have a pivot table with my Items in the rows, months in the colums, and my
data is sum of sales.  I want to sort by the most recent month.  I changed
the sort from using the items to using the Sum of Sales and it re-sorts but I
have no idea what month it is using to sort?

Is there a way to count the number of tabs in a worksheet?

I have a series of cells containing time spent. When I sum them up, it is >24
hours. When I format the cell with [h]:mm, I can see the total correctly. But
I want to calculate number of days by dividing this hours by 8. How do I do
it?

I know that I can inmovilize a line and a column in Excel, but I don´t know
how.

I have 2 spreadsheets with various column.  I would like to see if it's
possible tos et up a formula that will:
1.  Look at each number in a specified column in sheet 1.
2.  Attempt to find that same value somewhere in a specified column in sheet 2

Dear Sir,
Price per Each                                            Nos
a  b  c  d                                                    b  a  c  f  d
1  2  5  6                                                    5  9  7  8  6

I want to be able to protect the worksheet so that users can only enter into
the data entry cells but also allow them to use the AutoFilter feature to
quickly search through the records.
When I set the protection feature I can not click on the AutoFilter arrows.  

I maintain school database in excel.  I am entering the students attendance
using excel using the macro.  The work book contain sheets - Data, months
(Jan, Feb,..)
Sub attendance()

I want to insert the screen capture into an excel cell. I would preferrably
like to do this via .vbs Desktop.CaptureBitmap(sFile) command and then put
whats in the copybook into the cell

Here's the string I need to extract from:   Regional Sales: SMITH, E.  
(330146)
Here's what I want to end up with:   SMITH
All the rows contain the same beginning (Regional Sales: ) (:space), it's

I have a group of 10 worksheets hidden in a Workbook.  I’m looking for a
Macro to find the first empty sheet in that 10 page hidden group.  Each sheet
in the group is named “T” with a number next to the T (i.e. T1, T2,T3,
T4…….etc).

Is there a way to put in a formula for conditional formatting to say change
the color of the text if cell A1 equal any of the value in the column AA?
Column AA has about 500 rows with value. The value is the a 6 numerical
digit. Thanks