The below code
'-------------------------
Private Sub Worksheet_Change(ByVal Target As Range)
   Dim c As Range

I hope someone can help me with my problem. I have a spreadsheet with 3
columns. Column A = Date, Column B = Achieved, Column C = Average per/day to
achieve target. If the target for the month is 300 and there is 30 days then
the average is 10 per day for the month. if I was to ...

is there a way to move or copy a column of
numbers in cells into a row of cells?
thanks
Daniel

in a column with cells containing either text or numbers I have to exclude
those with text in an arithmetic formula as is runs through the whole column,
hence avoiding an error as a result when reading text cells.
A cloumn holding an intermediate result of the reading as "0" or ...

I have a spreadsheet with a few arrays in each of which there are a few
zeros. I have used a number fuctions (median stdev, var, average etc)
and now realize that I should have excluded the zeros. Is there any
quick way to do this?

       I found there's a problem in the rounding in formula "sum". I've a
cell to sum all the below figures.
$2,220,459.605
($55,511.49)

I have a chart with source data in E27:F29 (let's say Sheet 2).  
On a separate sheet (Sheet 1), the chart links to the above data.
E27 = Current Month        F27 =  $ 5,000
E28 = 31 - 60 Days        F28 = <$ 2,000>

Please forgive me - I am not great when it comes to Excel VBA.  I
believe there is an easy way to sum a column in VBA using the
forumalaR1C1= syntax.
So say I have a report which regularly has a different number of rows.

My PC Excel (2002) allows me to have many worksheets within one workbook.  I
can see the tabs at the bottom of the workbook to access each sheet.  Does it
work the same in the Mac 2004 Excel?  The MAC person I am sending my PC
workbook to says he can only see one worksheet when ...

Quisiera saber como se haya el tanto por ciento en Excel de ciertas
cantidades

I have a time sheet that includes the a row that contains the date.
What I'd like is a way to put the month in a cell, and have the dates filled in
the appropriate spots (looking like a real calendar, with spaces where there is
no date).

having installed Office 97 on Windows 2000
platform, trying to access Extras, Options,
causes Excel to crash, without exception, it seems.
Anybody has a remedy for this?

Accounting has provided me with an Excel worksheet with several columns of
data, one of which is AccountID. There is a table in SQL Sever which also
has AccountID. I need to join (using AccountID) some additional columns from
SQL Server into the worksheet as new columns, save, and ...

Can someone tell me how to do the following:
I have several worksheets of data in a file.
All the worksheets have exactly the same Columns.
I want to create a single worksheet with all the data from all the existing

I apologise if this has been inquired of previously, I wasn't able to
phrase my searches well enough (due largely to ignorance of Excel's
capabilities) to find anything useful on the web.
The Issue