I have one sheet called "Date Detail" which has 6 columns:
date     month     day      Year       # Emails      Custodian
I need to create 2 pivot tables (one in sheet called "Yearly Summary"
and the other one in "Monthly Summary") programatically.

I would like to know how to write a specific macro that handles the following
format:
download a series of alpha and numbers, the alpha values are always second
in the location, example would be

I hava an excel sheet with 2 tabs ("summary" and "database")
In "summary" data from the sheet "database" is presented in a nice way.
Because it is a lot of data i want to make a multipage userform to show the
data and give the user the possibility of adding a new record to (or ...

I have just started a C++ unmanaged college course and i want to write an
object to help me read into an Excel (.XLS) file, and convert it to CSV. Im
having problems knowing where to start! I have a BIGGGGG document identifying
how Excel is saved into its various componets (i.e. ...

I am searching in a Loop through multiple lines of data and looking for
conditions.  There are at least 3 possible conditions for my fist pass
through.
1. Search finds "defeated"

Excel 2003, I am trying to format a CSV file which has data separated into 2
different rows.  I would like to look where column a is null (no text) and
column c has text and where column b from the previous row begins with "38"
for example

Hi, how can I set up a cell/group of cells so that  the data in them can be
changes but the formatting cannot. For instance if I put the number
formatting as a percentage to 5 decimal places, then even if someone
copy/pastes something from a different cell that is not in that ...

I need to copy a row of formulas in a worksheet (Report), but only if there
is a value in another worksheet (Personnel).  Right now I'm stuck at having
500 rows containing formulas like the following:
Report Last Name:  'Report'!F2 = IF('Personnel'!$A2<>"",'Personnel'!$A2,"")

Can I format a cell to autonumber everytime I enter the spreadsheet?

I wrote an addin that works fine in Excel 2003. But when loaded in Excel 2007 it
causes a crash if I try to rename a worksheet in any file I happen to have open.
If I unload the addin the problem goes away.
The addin has several thousand of lines of code and I don't have a clue ...

I need some help.  I have a userform that I have created that basically
updates the information a person inputs into an excel spreadsheet.  We have a
tracking database for emails we send and receive.  Prior to the form we would
just cut and paste everything into an excel ...

I have a spreadsheet with many children and their club dues.  (It is
not very orderly.)
Names are in range B12 to B208 and their payments are in range F12 to
F208.

This is my problem.
I have 2 years.. 2006 and 2007 we will say column A is 2006 and C is
2007. Over in Column D I want to know the actual difference and if it
was greater or less than the previous year. If it was less I want it

I am trying to set a function to run when my worksheet is open.  I
have found the workbook_open() function and if I have to I suppose I
can use this to do what I am trying to do.  I want a process to run
when the worksheet is first opened that will search a specific column

I have one excel spread sheet has sheet1 and sheet2, after I combined
together it has a lots of duplicate record, I hight light the data--> advance
filter--> check unique record only, on the left site of ColumnA, is show
random number like