A. Below is the code that work perfectly when i run it through macro but not
working through command button, i have refer to other post but cant change it
as per my need, help required.
B. after running whole macro print area left the grand total out of the

How do I get XL to report the value of a cell if a (text) value in another
cell is NOT true?

it asks to reate a CVP chart of sub-type "scatter with data points connected
by lines without markers" enter "cost-volume-profit" as the chart title,
enter" customers per day " as the category(X) axis title, and then place the
chart as a new sheet.....

i have a real proble I need to sort a large data base of files using the
client file number. Problem is I need to list all file ending in 0,1,2 etc.
is there away to list the files numerically using the last digit?
Any assistance would be greatly appreciated

Okay, so I've got an XLS I've written to handle interview data for a
project I'm working on.  One of the aspects of this is that I need to
take a group of cells defined in one location, concatenate them
together on different lines in the same cell, and insert that in

I am trying to come up with a formula that will accomplish the following.....
I have 2 columns that compare the current year weekly data to prior year's
weekly data.  I need a formula that will sum Column D to same week in Column
B.  Each week, the next row will be updated in ...

Thank you in helping me to resolved this excel problem. I need to use
VLOOKUP then give me the sum results in separate sheet.
in separate sheet, VLOOKUP need to be used, the Look up value is 1, the
return value is $35 which sum of ($25 + $10)

I have few serial numbers where in I need to connet for some of the line
items I have in my spreadsheet.
For Eg: If I have 123 as serial numbers and I have 3 items to connect.
Three items are a.5685 b. 9000 c. abcd.

In one column I have like 2000 email addresses my potential clients
and some of them do not want to receive any emails at all. So I have
about 10 email address that I can not send to. Can someone please help
me with a formula that will eliminate all of those restricted (10

For example...
=INDIRECT("'"&$C$3&"'!d4")
How can I have the user define the column (by replacing D)
$c$3 references the dropdown value (user preferred worksheet)

I want to select from a column that contains a list of titles that I have
imput.
I want the selection to be placed in a differing column such as employee name.
Essentially enter the name of the employee by choosing it from the column I

I need to sum the data in column A that meets criteria in column B "=J".  
I've settled on SUMIF, but it returns zero.  Also, now I need to include the
criteria "blank".  Am I using the right function?  If so, where have I gone
wrong?

I can't seem to unravel the following formula from Quattro Pro so that they
will work in Excel.
    Quattro Pro
Cell “L8”:  @IF(D8>0,(D8*J8)+K8,””)

In Column L, I have a persons first name and last name eg:  John Smith.  In
column N, I just want the persons last name to appear.  I know this must be
an easy formula, but I just cannot figure it out.
I appreciate your help.