By using the following conditional formula, I am able to get the category needed based on the sales. The sales are mutually exclusive. In other words, if there is a value under CAD SALES then USD SALES & USD FX will be either zero or blank. And if the USD SALES is filled then CAD ...

My problem :
I have to design sales model called Regular, X'tra, General, Farmer or
Multipurpose.
The target is Regular min 100new, X'tra min 30new, General min 84new, Farmer

I am looking for a way to import text files into excel.  My problem is
that my company uses IBM AS400/ISeries to run certain reports each
month, and these reports come out as .txt files.  These .txt files have
headers and any number of other random lines throughout the report

I found this macro
Option Explicit
Sub testme()
   Dim wks As Worksheet

I have several Access databases and I was infomed for a quick and direty way
I can make a pre formatted workbook then use the transfer spreadsheet for my
report. I dont want the spreadsheet to lose its formatting everytime a user
runs a report. Is anyoen familiar with this ...

Got a spreadsheet that people are using to enter rates of return for bond funds.
Column 1 is the name of the fund.
Columns 2 through, say, 250 are returns for a given date (i.e. the column
headers are dates).

i would like to know what is the exact usage of this method in c#?
MICROSOFT.OFFICE.INTEROP.EXCEL.APPEVENTS_WORKBOOKBEFORECLOSEEVENTHANDLE
thanks in advance
-gop

I have a column with HH:nn data
I want excel to sum the values - is it possible ?
e.g.:
12:40

{=+SUM(IF($F$3:$F$83=$A87;$AD$3:$AD$83;0))*B87/1.25}
those brackets  disappear automaticly once i click the formula bar
if i copy formula without those brackets the return is '#value' !

I'm protecting a sheet via VBA.
There seem tb quite a few parms to control what gets allowed/disallowed, but I
can't find anything that applies to formulas.
I want the user to be able to put formulas behind some cells.

I would like to write to an event log named 'Trackers' that records a users
name and machine everytime a specific execl workbook is updated, can this be
done?  How do I go about making the event log?  Thanks
-lumpjaw

I used VBE to develop a simple program by using Microsoft Excel as its
database. However, there are some limitations such as the file is in
.xls and cannot be saved as a .exe file.
How could I get the same result by using Visual Basic Professional?

Hello Members,
I have a problem with Excel ,currently working with Cells .Where I want
to remove Div/0 value from excel cell.
Help me please,Its a production problem...

I have two different lists. List A  with three columns: name, first name,
email address and list B with 7 columns: name, first name, Street, City, Post
Code, Counrty.
The list B containes the names of list A. How do I merge these two different

What formula do I need to type in Column B cells to identify the duplicated
entry (only the second entry)
Column A         Column B
Car