I have been trying to sum from a column after it meets three conditions. I
have tried three things now and I can't get any of them to work.
The first thing I tried was to take it through a conditional sum wizard, and
my formula looks like this:

I have a macro that needs either Workdays or networkdays to determine the
number of workdays in a month.
I have installed the "Analysis Tool Pack" and "Analysis Took Pack - VBA"
into Excel.

I'm trying to get a cell in Colimn V to change colour if the value 5 i
found in a particular row....so if cell D2 contained value 5 then V
must turn yellow (or some such colour) if F2 contained 5 then cell V
will be yellow etc. every other column from D up to column U for aroun

How would I create a macro that runs 4 different macros in the same
workbook. Assume the names of those 4 macros as Step1, Step2, Step3,
Step4.
So how would i create another macro (say, name it as StepAll) that

hi.  I'm still trying to use xll files to be able to use c++ code for custom
excel functions.  No one seems to be fielding these questions, but I thought
I'd try again.  I'm trying to use the xllregister method in vba to call
functions in an xll file.  here is the code:

Is there a way to prohibit another excel file opening up in the same window
as the program that I have created?
Jason

I have read thru several articles on this site to get started writing Macros.
To get started I thought I would read some lines and paste them at the
bottom of the existing sheet to test my understanding (which is obviously
zip)  I can't even get started.  Here is what I wrote ...

I am asking people to fill out a questionairre, which their responses
are saved in a shared folder. Their responses are saved as
theirname.xls. Is it possible, if I have an excel sheet with all the
names in one column, to have excel put a "YES" in the adjacent column

I am very experienced with Excel VBA...so, don't hold back on any VBA coding
responses ;-)
What I am NOT familiar with, is connecting to Oracle. In particular, I want
to use a value in a Cell in Excel to query an Oracle Database.

I have a workbook that has 4 macros. Macros are named as "Step1",
"Step2", "Step3", "Step4".
How can I create a macro in the same file that would run Step1 to Step
4 in consecutive order?

I need to activate a workbook through a cell reference. the workook
name is stored in cell A1 as "pnlreport_060321.xls". This name
automatically changes daily based on the date. This is how I wrote the
code to activate the workbook:

Hello.  I am trying to make a simple function that will automatically fill in
data if a few Cells are not blank.  I'd very much like to do this with a
function but if need be I'll struggle with working with Sub Code.  I am
trying to keep this very readable in Microsoft Excel and ...

I have this code, where upon in B1 and C1 are  numbers entered such as
1, 1
Line code:
--->  Sheet1.Range("B1").Value = Sheet1.Range("B1").Value + 1

i was wondering if the following could be achieved?
i have approx 600 excel books all created from a master template. originally
they were named indiviually as 1234 (job number) & "Quotes & Orders".xls
where later i renamed the template to Quote book giving me job number and

Hello...
I have a dilemma that I may be making harder than it needs to be.  I
have a spreadsheet with 3 columns, contain 3 specific dates.  What I
need to do is to compare these columns, and calculate the NETWORKDAYS