I have a date in  cell M3 02/07/2007 (format dd/mm/yyyy) and a date in cell
P3 07/08/2007 (format dd/mm/yyyy).
In E3 I have the formula
   =IF(AND(M3<>"",P3<>""),CONCATENATE(">",M3),M3)

I am completing an estimate on a recent job that i have done. the last three
columns I have are Amount (which is the amount of money a company has payed
us), % completed (which is the amount of work that my company has completed),
and finally the balance (which is the amount that ...

Good morning -
I've found countless examles (e.g. http://www.rondebruin.nl/tips.htm)
on how to extract data from a closed workbook.  I'm trying to select a
group of worksheets and send them to a closed workbook.  Can anyone

Good morning - My title is working quite right.  While font size is
correct (18 and 14 pt), the entire title is bold and I have no idea
why.  I greatly appreciate it if you could take a look and see if you
see anything out of place.  I don't want it bold.

I think I remember being able to take a pivot table view of data and
"double-click" on something (like the column headings or the whole
sheet) and a new sheet would be created showing all the background
data used to form the pivot table.  If you know how to do this, could

I am using Excel 2003, trying to load Palisade software, specifically @RISK.  
It is an add-in for excel.  The installation process proceeds fine.  but when
I try to open the program, excel opens and shows the error message "Could not
load athlib32.dll".

I would like to print a Worksheet from another active worksheet. Example:
From Sheet1: (clicking a cell, button??)
If condition 2=true print Sheet2
If condition 3=true print Sheet3 etc

A friend aske me to post the following query regarding Lotus 123::
From time to time I have a shaded dash line that appears and encloses some
portion of the spreadsheet in a rectangle.
I do not know what I do to invoke the box and cannot seem to get rid of it.

This is probably very simple but i am struggling with this. I have a
workbook where one sheet will be updated on a monthly basis and i want the
sheet preceding it to capture its outputs. A few things i need it to capture
is to check if Col B has a specific value and if yes check ...

I have a program on my computer that is using an Excel workbook.
I'm using VB6 and need to modify this excel workbook.
How can I make changes to this excel workbook without saving it first to the
hard drive and afterward reopen it.

I have a program on my computer that is using an Excel workbook.
I'm using VB6 and need to modify this excel workbook.
How can I make changes to this excel workbook without saving it first to the
hard drive and afterward reopen it.

I have  Office 2007 on my Win/XP workstation.  I have apparently (in
error) changed a setting.  
For one specific worksheet, Excel no longer automatically recalculates
when I change cell contents.

I am using an Offset forumula to bring back data in a rank ordered format.
I am using the following formula, which is working fine:
=OFFSET($V$1,MATCH(ROW()-1,LocationRankList,0),-2)
However, the file that this is in is going to be used as a template, for an

Hello all...
I have a chart where I am taking a column of data and creating a chart...
along that column certain cells have Comments inserted with the little red
arrow in corner to designate a comment is in that cell.

Does anyone know any easy way to calculate the value of an investment where
you put for example, $1000 per week into an account that has 6% interest for
12 months. Also, similar scenario where you put $4000 per month into an
account @ 6% interest. How do you calculate it's value ...