I have a report which i would like to email to colleagues on a daily
basis but I only need to send certain Cells, is this possible? I've
only seen code which sends the whole sheet.
If anyone knows I would appreciate some help.

We want to have a cell show just the numerica value of the percentage. I.e.
if it is .07 and displays as 7%, we just want the 7 to display.  How do we
format the cell to do that?  We've tried all of the format choices that would
apply to numbers.

My goal is to have a cell that if a person enters 1500 or higher it uses this
formual: =(J19-N19)*50%*E19*65% and if they enter less then 1500 it uses this
formula =(J19-N19)*50%*E19 does anyone know if this is possible?

I need to copy a worksheet from one workbook to another similar one with the
same worksheets, and I have a formula inside this worksheet that references
to cells in other worksheets of the workbook;
So I need that the formula points the same cells of the new workbook.

The lines in Excel are purple and I can't change them back to Black

How can I count, in hours; time elapsed in the form dd/mm/yyy hh:mm between
two dates and times and not include none working days?
i.e 08/06/2007  10:00   to   11/06/2007 09:00   should be 23 hours.
I use NETWORKDAYS frequently and am tring to figure something out along

I need a function that compare text in two cells for a specific text
and if exists make edit the second cell as the first one.
For example my function willl:
1. Look for the text "#" in cell A1.

i have a worksheet with about 30 spreadsheets.   In every spreadsheet i have
cells that i want to delete automatically (the cells contain different
numbers in table formats). Can i have a formula that automatically deletes
only the cells i specify from every spreadsheet..

I want to test if BST and GMT rollover dates over the next 3 years fall
between two specified dates using an IF condition.
e.g
date 1 - 01-Feb-07

In a privious post I asked the following question;
Column A has hundreds of item numbers.
Most are NOT duplicated, but I could have as many as 10 to 15 item
numbers with duplications and each number could be duplicated 3 to 10

I have a worksheet with two columns each containing thousands of UPC codes.
I'm trying to line up the data so that I can find matching UPCs between the 2
columns(I'd like my matching UPCs to appear in the same row). Here's a more
visual description.

I have a big worksheet containing last names with all capitol letters.  I
would like to convert the case of the names so that SMITH will become Smith
and JONES will become Jones.  How can I accomplish this?  I will appreciate
advice.

I have a start date of  2 Jan 07 in A1 - the 1st Tuesday of the month.
How can I get the cells below populated with the dates of the 1st, 3rd
and 5th Tuesdays of every month?
Tks, Ricky

I create a Pivot Table every month on one network drive and I link various
cells of the Pivot table into another worksheet on a different network drive.
I've been doing this for several years and this month my formulas are not
working properly.

Column A has hundreds of item numbers.
Most are NOT duplicated, but I could have as many as 10 to 15 item
numbers with duplications and each number could be duplicated 3 to 10
times or more.