Here is my dilema.
I need to work out staff commission on a sale by sale basis. Easy. What
i then want to do is for the sheet to automattically for each week
calculate what each salesperson gets, number of sales etc.

Hey, im new here and i have a problem with autocomplete. Its turned on
(box is checked) in the options in my spreadsheet. However when i am
filling out my spreadsheet i am finding that its as if its only
autocompleting my cells by its own choice. For instance i type in

We use hyperlinks on our analysis spreadsheets so that people are able to
trace back to the source data file easily.  I like to be able to combine the
hyperlink with some standard text so that the hyperlink makes more sense
(Source: Insureds File: Hyperlink for example) .  Does ...

Hi guys,
I normally copy down formulas in Excel by double klicking the buttom
right corner of a cell...
When I do this now, everything works as normal, however all cells gets

=VLOOKUP(MAX(D18:D30),A:E,2,FALSE)
I use this formula to retrive the maximun value of the D column an
display the value of respective B value.
(1) May i know how am i comparing the negative value (-3.12)?

i want do a worksheet contain:
A1 - A15 names
B1 - B15 random nos between 1-11
how can i do the random nos?

Someone who knows what g=d&ignore=.csv means in the following code?
StrURL = "URL;http://table.finance.yahoo.com/table.csv?"
StrURL = StrURL & "s=" & Aandeel & "&a=" & a & "&b=" & b
StrURL = StrURL & "&c=" & c & "&d=" & d & "&e=" & e

Howdy,
Can anyone of you excel gods help me with the following?
I have a small spreedsheet (excel 2003) set up like the following to help me
keep track of my music collection:

we like to get data from diffent sheet or work by putting in data cell and
filling the rest of the columns automatically
ex; sheet 1 = test
sheet 2 = test1

When I enter a string of text for a cell, how do I enter a CRLF? For
example, I enter:
   This is my formated paragraph.
and I want it appear in a cell (wrap text is turned on) as:

Using Excel 2003 I want to get the sum of cells containing numbers, but the
these cells also contain some text.  I only want the sum of the numbers.
Please help.  P

How can I prevent the task pane from popping up when I copy something in
excel?  I have tried everything. On the options menu on the task pane, I
have selected the option to disable the pane from popping up each time I
copy, but when I open excel up again and copy, there it is.  ...

Could Someone show me how i can create a macro to copy the activecell from,
I am only working with column 1,but up to row 60 . So if I select "a2" on
sheet 2 so the macro would need to look at sheet 1 "a2" and copy the contents
to sheet2 "a2" or whichever cell I select upto row ...

Hello specialists!
How to place a secondary y axis bar in a bar chart next to, not over, two
primary y axis bars?
Best regards,

Hope someone can help.
When downloading data from an external database into excel, if a number
is a minus figure, the download puts the minus sign at the end of the
figure rather than at the front. Therefore, excel does not recognise