Recently I wiped and reinstall Win XP and Office XP on my
computer.  Since then, an excel report that utilized odbc
to pull data from an accounting program into an excel file
can no longer find the souce data.  The messages I get are:

I have a wrksheet that I fill out, one column has the amount spent and
the second has the GL code associated with that. I would like at the
end of the page to show a sum of the amount spent in each GL code.
(I.e.)

Good evening to all,
Can you please help me make a formula for my percentage
column.
    A         B          C       D        E

Hope some one can help me. this is not a particuarly
difficult one.
Range - C4:D24
What i want is that if the two cells C4 and D4 have the

I am trying to create a macro that will select a cell, format it with
function like =proper and then autofill the range.
Example is I have a list of customer names that I want to make prope
case.  I want the macro to format the entire list for me.  

I would like to refresh a dde link in a vba macro. I did not have a succesfull solutions.
One remark is that the information needed from a dde link is every time different and this is programmed by the macro.
The funtion calculate does not work
Please help me

I need to be able to substract a value in cell's D11 if the value in D11 is greater than 0/null,  if D11's value is = X from the Value listed in cell H2, and the value of cell D12 is to be substracted from the value in cell C11 if the value in D12 is also  =x, if not, plug in a ...

I am having a problem with a macro I recorded...... it runs an auto filter.
The macro works fine until I protect the sheet.... then I get  'runtime
error  1004'
if i run the de-bugger the following shows up; .

Please see attached file.
Comparing timecard records to an IT Contractor salary rates file.
date range is the stated period of time a particular salary rate i
paid to a contractor. There are many thousands of timecard records t

When I paste a picture into a worksheet the file size
drastically increases. how can I control the size of the
file?

This may be an easy question...
I have an error log spreadsheet that is used to log what
kind of error has been made and by what department of the
company the error was generated. For example... Columb A

Here's my goal.  Whether tis possible remains an open
question.   I have two lists, (each list can be on a
separate excel worksheet or separate file) one with
account numbers and amounts, sorted in order by the

I am doing a Lunch Detention spreadsheet for my
school and I have included 18 different classes on 18
different sheets, with all of the students from the
different classes  on their respective class rosters. I

What I have is I enter a value in say A1.  
Cell B1 takes this value and does a calculation and the result i
placed in B1.  
What I am trying to do is create a data validation that when thi

I know how use CONCATENATE function, but I would like to know is there a reverse of this function, without havingb to export to text file, and then import data back into Excel. For instance, If I have cell value of "10.20.14.256", how can I extrapolate values  separated by ".". ...