I wrote a vba function that should return data to the excel spreadshee
after querying the Oracle database. I have installed and created
Microsoft ODBC connection for Oracle on my workstation.
If I manually open excel workbook and navigate to Data, Get Externa

How to transfer the total of multiple of multiple entries in a sheet to
another shet in the same file.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!

Thank you to BrianB who assisted with a starting point for copying cell
data to a new workbook. I have now had a number of coffees, taken a
deep breath (thank you for this excellent advice, Brian!) and started
at the beginning. I have performed the steps manually and recorded this

Does anyone know of any design conventions that dictate the correct
orientation (i.e. row-column or column-row) of data within a spreadsheet?
Where I wish to display an independent variable (e.g. the months of a year)
against a dependent variable (e.g. company profits), there is a ...

I wrote a macro which have to delete some rows in a sheet.
The sheet contains many sum formulas. When I start the
macro, it work very well but after 10 deletes it needs
more time than before and after 20 deletes it needs over

I heard that there is an Office package that includes "developer tools" to
create executable win applications from standard office packs (Access, Word,
Excel, Powerpoint). I wonder if there is an add-in or a utility for Excel
only...

Assume that I have the following data:
(Column A)     (Column B)         (Column C)
LNAME              FNAME               CODE
Smith                John                  123

I am currently taking a class to learn how to use Excel. For some reason the
goal seek command on my tool menu is grayed out. My teacher can't fiqure out
why either.
I hope someone here might have an idea why.

I am trying to create a pivot table from two worksheets.  Each workshee
represents different accounts from which I am tracking expenses.  I hav
these columns on both sheets:  Type of Expense (labeled A, B, C, D)
Date, Description, and Amount.  

Could someone help me with a formula for winning percentages?
Example:
Cell A   10 (Wins)
Cell B    4  (Losses)

hello
I'm a new  and thankyou for this site
I'm work on the graphic the part( x,y scater)
and I want to draw this

I have 300 excel files.Now i want them to be maintained as database. I have
tried to import them but my first COLUMN A in excel are the headers not the
first ROW.
how do i transfer the data into access. or if there is any other database

I want to know how to protect the cell at the very moment data i
keyed in and entered without using the protection option in the tool'
bar! I would like the process to be automatic!! for example: in cell B
if i type in the word "king" and press ENTER! after this i must not b

I am using excel 2003.  And wondering about the options dialog windows in
taskbar checkbox.  I thought this would group all open excel documents in
the taskbar, to one button (whatever you want to call it?)
however it does not seem to do anything?

My current default row height is 7 so it cuts off the tops of the data
characters making it difficult to read.
How do I set up the row height to always come in at 12.75?