I have a Workbook with several sheets.  As you know, Excel opens the page you
were on when last saved.  I would like to have Excel open up on my Title
Sheet regardless of where I was in the Workbook when saving.
Someone mentioned the 'onopen' function.  I'd be grateful for a ...

I have an address workbook that I'd like to insert tabs for each A-Z cell?  
Can you do that??
help!

how can i set the format settings for cell alignment so that its there when i
open a new book, rather than changing it each time?

I built a function some months ago, which works perfectly.
The difficulty is that the entire text in the cell is bracketed by "curly
brackets" ( { and } ). When I modify anything in the cell, those brackets go
away and the formula, even if I haven't actually changed anything, no ...

Good day.  I am using Excel 2002 and consider myself an above average user.  
I have a worksheet that computes my pricing for my store based on the
products used to create an item for sale.  There are close to 100 items that
use a standard product price worksheet.

I have a sumproduct function with two criteria, one of which is only on
word of cells that contain several words.  I have tried using wildcard
but the result is 0.  I have also tried a countif in the secon
criteria, still to no avail.

I am trying to update an entire column (col #1) based upon specific values in
col. #2.  Column #1 has random entries, no range and no sorted order.
For example, 30, 365 & 1095 = 03; N/A or 0 = 10.

In excel, I have hyperlinks in a main worksheet that link to a secondary
worksheet. Once the user is done viewing secondary worksheet, I 'd like the
back button to return the user to the main worksheet and close the secondary
worksheet. How do I get the back button to ...

In row 1 i have a series of dates in asscending order.
In row 2 I have values coresponding to the dates in row 1.
I am hoping to pick out the value in rows 2 that corrsponds to the most
recent date in row 1 that is less than todays date [ie <now()]

I have 2 worksheet.
The first worksheet1 Cell e.g. A2 have formating such as "What a good day"
with "What" in Red color, "a good day" in Green color and entire word in Bold.
On 2nd worksheet2, I put " =worksheet1!A2 ". The result only the words but

I'd like some help with the following (which I think is quite simpl
but...) I've created the following spreadsheet:
ProductCode    PurchaseDate    Style    Clr    InvCd    SI/PQ/US   
10042S001    01/07/2004    10042S    001    SI    199   

I am using a pivot table and I need to rearrange the columns.  However,
I have come to learn that the pivot table will not allow me to simply
move one column in place of another.  As it is, Column A and Column B
need to be switched.  Is there another way to do this?

I grouped my worksheet ex.
columm A & B a C is one group
columm D & E & F is a second group
etc.

Bob Phillips Wrote:

Anybody knows how to find MATCH numbers ?
Example :
Cell A1 = 1457
Cell A2 = 2467