I'm a fairly new user to Macros
I have a worksheet created in XL2003 that contains five buttons created from
the toolbox. Each button successfully runs its own unique macro basically
hiding and showing specific rows. The Macros are caller Sub Macro1( ) to Sub

I would like to copy conditional formatting in one cell (i.e. that says
format C1 if is isn't equal to A1) to another row - say row 2. Instead of the
conditional formatting now saying if C2 isn't equal to A@ then format, it
just keeps it referring to A1 as in the first formula.

Can anyone explain me abt the Row, Index, Match functions in detail with
various examples? I tried with help but i really cannot understand the
function.
Eagerly waiting for ur reply.

I need help with a formula...I have a quarterly report that I am
working on and I need to know the % total revenue per product.  Does
anyone know what formula to use for this?  I have been all over the
internet looking for help and I can't find any!  Thanks!

I'm looking for a macro that prompts and forces the user to import 2 files
and copy it into two different worksheets. (If possible, when user denies to
import files, Excel close)
First file is a .csv file that. when user imports the file, It should be

Can you look at the example below and provide me with the solution? Would
appreciate your help in this mater.
EXAMPLE
   A          B                 C        D              E               F

The macro below putts and stacks all worksheets together in a new sheet
called "MergeSheet" and works fine, But my problem is I don't want to add all
sheets I just want to stack Sheet1, Sheet2 and Sheet3 together in
"MergeSheet". Where do I have to make corrections?

I down load an excel calendar templet. Is their any way that when I open it ,
it can highlight the present day, like how Calendar does in office????

hi, have formula for whole cell to equal a number, but is it possible to test
only the left character to be a number.  thanks.
have:  =ISNUMBER(AD9)
sample of data:  1F

I initially posted this in the powerpoint group by mistake, so forgive
me if you've seen it already (I make the charts in Excel and then
transfer to Powerpoint, thus the mistaken posting in that group).
<<So, I've got a bar graph showing each fiscal year's spending and

I've seen some of the links here that show 1 method on how to do
dynamic charts. However, that method isn't working for me.
I want the user to select 1 from 3 drill down options - for a metric
dashboard.

I posted earlier about creating a dynamic chart, and I've found lots
of links to tutorials that show you how to move a range - like the 6
recent months, or charts that grow as you add data.
But what about a chart that can get smaller, in theory, this should

When I use the minus button on my numeric keypad, "ext" appears in the bottom
right hand corner and the minus sign is disabled.  Is this a macro?  How do I
delete this?  What does the "ext" mean?

How do I do a count in a column.  I have a column with A, B, and P in it.  I
want to count how many A's, B's, and P's.
Thanks,
Nordic

I need help setting up a formula to look at a range of data (will vary
between 4, 5, or 6 values), choose the 4 highest values and add them together
(ignoring the rest).
ie.