Is there a way to provide a particular worksheet name to a hyperlink so that
when you open a workbook using a hyperlink it goes straight to the sheet you
want or a named range?

Suppose I have a set of points, such that I can do a regression and
find a linear trendline for X versus Y.  How can I determine the X
needed to obtain a specific Y value with a certain degree of
confidence?

I was looking for someone who could help me with the following:
I have a rather large Datase (5000 records and growing). One of the data
collumns excists of 120 different categories (and still growing). How can I
make a list, in another sheet, which only contains the categories? ...

The formula below does not seem to work, can somebody please tell me that is
wrong
Cell A1 = Time  ,e.g. 12:30:00
Cell B1 is blank

This might be asking a bit much of Excel, but here goes.
I have a membership list. When you pay your membership it is good for
one year. I enter the expiration date in cell A1. In cell B1 I want to
have an If/Then formula that states Y if their membership is active, N

I have work book with 13 sheets. Sheet 1 has a custom header.
How can I use this header for the other 12 sheets without doing it manualy
for each sheet.
Is there a way?

Hi Excel Experts,
I have data which are exported from Sharepoint List to excel in the
following format:
NAME           BRANDS

I've been trying to get a macro to work. It is a macro that prints the
previous week's data on a data sheet.
When I click on the macro, I get the message to enter week number.
When I do that I get this error message. "run-time error 424"

I don't know a lot about VBA.
I need to make an Exe file with VB to give 3 buttons each button starts an
excel work book (book1, book2,book3). I am thinking of a form that appears
on the screen.

I have a workbook with 3 sheets.
how can i add a command button to sheet one to print all
three sheets
thanks

I have a color printer and preview is in color.  On-screen worksheet shows
only in black and white.  What can be done to fix this?

when i am in Excell and i put in 1.29 it always comes out as 1.  29
it does this is Word as well when ever i use a period anywhee it always puts
2 spaces in. if i go ... i get  .  .  .  

How do I create a formula based upon the summarized data in my pivot table?

If I press "Ctrl+~" I can see all the formulas on my excell.
Is there any way that I can see all the conditional
formatting and/or the validation at once?
Thank you.

I'm using Excel 2003 on XP.
Used to be when I had multiple spreadsheets open, they would all appear
individually as items on my taskbar (I have the grouping option turned
off). I seem to have inadvertantly changed a setting. Now when I open a