Good Day
I am trying to minimize the working for every new year, a little help needed
I have a workbookk having 175 worksheet containing data as follows
Workbook name:    Results Update

In a excel worksheet, Is it possible to move information in rows
automatically as accend sorting is being done?  If so, how do I do it.?

Can any one tell me how to sort column A by number,  and have the information
in the rows follow the sorted number?

Can you length the amount of values visible from a validation list?
How?

I'm trying to count zip codes in a dynamic fashion.  Is there a
function which will identify what zips are present assigning each 2
cells as follows:
A1             B1              C1              D1

I once knew how to generate column headings at the top of every deisplayed
sheet as I moved down through seccessive sheets of a worksheet.  But am now
unable to find it again.  Please help.
                                           Don J

I had 40 rows of data and deleted the last 20 of them using right-click
delete.  When I use the CTRL+END keyboard shortcut, it still brings me to the
40th row, even though it's blank.  I've already tried selecting the last 20
rows and clearing the contents (thinking that the ...

Hello Support,
Is it possible to use a formula across two worksheets.  The situation I have
is as follows - I have a worksheet that has been producing an average over a
column of data.  The table has now filled so rather than "tack" further rows

I was sent a spreadsheet with descriptions of product we sell.  In each cell,
displayed is a fraction, however if you click on the cell you see the decimal
equivalent behind the scenes.  I am trying to take information from several
columns to make an item description for each ...

I'm trying to setup conditional formatting in Excel and not having much
luck.
My criteria is where any cell from d3:d28 is greater than 45, than tell me
the highest value from i3:28 and color the winning cell in "i" blue.

I have a list of questions; they are not specifically ordered but some are
subordinate to others (think flow diagrams).  I want to create a link whereby
I can go to the source question (or vice versa).  This would be along the
lines of 'Go to Cell #29'.  On clicking the link I ...

in my worksheet with text data in cells, all the cell texts can be seen in
print preview, but not after printing, in some cells. other cells can be seen
as normal
Could you please advice?

This is something basic and I have only found out today.  Oh well, I am still a newbie.
Scenario 1
If I format a brand new blank cell as TEXT and key in a number say 2006, the format is text.  ISTEXT( ) returns TRUE.
Scenario 2

Hi Bob and Roger (in alphabetical order),
I just want to let you know that gradually I am detaching Boolean from SUMPRODUCT and I am learning to use Boolean outside of SUMPRODUCT.  However, I still need SUMPRODUCT as a stepping stone to write my formula.  You won't believe what I ...

i am drawing up a schedule for Jan to Jun 2007. I need to schedule a meeting
every 1st thursday of the month.
thanks
springbokiwi