I have a summary worksheet with several others as back up data - ie company
budget summary with branch budget worksheets.  I need to add various totals
(expense headings) from each worksheet and consolidate on summary worksheet.  
Regret I am a basic user of Excel.  Hopefully ...

Hi.  I am using MS Excel 2003, and I am very new to the program, so if you
can help me, please explain everything in very easy English.  
I need to fill many blank (empty) cells that are located in various places
(there are five columns) throughout a worksheet.  I want to fill the ...

Hi I have a 24 month spreadsheet, and would like to make 2 new calculated
columns, for dates adding 12 months together each, is this possible thanks
tim
the spreadsheet is date, customer product dollars

I have chosen to print comments at the bottom of my spreadsheet the problems
is it only gives the cell reference number.  If I am looking at a printed
version I would not know what cell it is refering to.  I then labeled
(reference) each cell but it still does not print out the ...

I am trying to establish group positions for competitors based on
penalty points and group. The catch being that equal times are
considered as a single placing as illustrated below. I'm used to
working what I will call normal ranking, using array formulas, to

Hello excel pivot table experts,
I have the following question.
Usually all the results depending how many data-variables you defined
are at the bottom below each other. is it possible to move the result-

I have a cell format of dd-mm-yyyy hh:mm that I have applied to "call open
date and time" and a "call closed data and time" columns.
I'd like to have a further column that calculates the difference in days and
hours, or just hours, between these two date/time values.

I'm using Excel 97 and am experience the below problem.
I have a list of retailers on row N and in row R I have the below
formula:
=SUMIF('TOTAL DATA'!$G$4:$G$60000,N12,'TOTAL DATA'!$X$4:$X$60000)

The bar at the top of Exel 97 dose not display the icons for minimizing,
maximizing and closing.
What must be done to correct this.
Thanks

I have the following formula to count the number of instances of the month
January in a column of dates.
{=SUM(IF(ISNUMBER(C$3:C$512),IF(MONTH(C$3:C$512)=1,1,0)))}
I want to add an extra condition where the year is less than 2002 and have

Hi      I am working on a large spreadsheet of customers with sales figures
etc.
Several customers have several records due to change of names of companies,
mergers etc.

A cell contains a very complicated formula that is written to return a
number, text, or an empty string. How to I test for an empty string?
None of the logical tests seem to be any good.
IsBlank, IsText, IsNumber, IsNonText... none of these will work.

When I press Ctrl + End the cursor goes way past the last used cell in the
sheet.
How do I get rid of the blank cells so that this takes me to the last cell
used.

I wish to define my default printing option as 'Draft" for all instances of
Excel  that I might use.  I have tried to do this via
File/Print/Properties/Draft, but this only works for the instances of
Excel  in the current session.  When Excel  is closed out and reopened, the

Code:
Dim oXL As Excel.Application
       Dim oWB As Excel.Workbook
       oWB = oXL.Workbooks.Open("C:\data.xls") '---> Exception thrown here