My first posting so thanks in advance for any help
I have the following formula in J12
='Summary-March2006'!$C$16
I tried the following but no go

Someone else posted a topic a while ago that is similiar to something I
would like to do - but not quite!  (Topic is now close by a moderator
as it was in 2004).
The original post was -

Our company has finally made it into the 21st century and we now have
Excel 2003.
One of the things that I have noticed missing is the equals sign to the
immediate left of the formula bar, so now I have to type either the +

Qns 1) I have a column eg. Column A. Dates are entered manually into
this column. Such as 31.01.06. I would like a pop up message box to
indicate that work is overdue after 10 days from this date. How do i do
it??

We use Excel 2003 with Win XP Pro and I hope you can help me.
I have a workbook with three worksheets - one for each team I
support.  Each team only use their own worksheet.  In the same place at
the bottom of each worksheet is a list of names (Col A) and dates (Col

Help!  I don't know what the best way to do this, I've been surfing
these postings on various sites for the past few days as well as bought
a book.  And I still not sure what I should do.
I have 6 individual workbooks for each rep that I want to consolidate

How do I merge/link (if that is the correct term) 6 individual
workbooks into one master workbook?  Each workbook including the master
has the same columns but different number of rows.  I've read through
alot of the newsgroup postings, did searches online as well as bought a

Hi this is Rajasekar Chandramohan from India. I would like to know how to
insert a executable file (eg. Flash files) to an excel files. I had seen lots
of excel files with some games etc. How come is it possible?

Hi  - New to macros so forgive what is probably a silly question.
I am experimenting with developing a macro and have used one as a template
which places data in A3:F3.
What I am trying to do is to click in the first coilumn of any row,eg A24,

We have XP professional and it has the Excel program icon. When I try t o
open it, it states that I need a disk to install it. We did not receive a
disk with Excel on it.  I contacted the company that we purchased it from and
they said that I did not purchase that program. What I ...

In SS2K , how to enable remote connections ?
For example, from my machine, within SEM I'd like to create a "New SQL
Server Registration" connection to that machine.  This has always worked for
me in the past, but today I've encountered an SS2K instance which gives me a

Hi, I have written a small VBA macro in excel (2002) which print outs a
excel sheet as a pdf file.
It used to work well until an update of acrobat was installed.
Now it stops when I try to print out the ps file with the error

I am trying to define ranges each of my ranges is characterised by an
identifier in this case "D1" then directly below it are property
descriptions. So my sheet looks like this:
D1

I have a workbook of prices and descriptions of products and would like to add
pictures (.jpg's) of the product so that when you hover over a cell the image
would open so a salesperson could show a customer what the product looks like.
If it could work like a "comment" it would be ...

I have a spreadsheet which has customer names and data about them such
as country name , state name and city name. It also has details about
type of purchases made.
In another spreadsheet i want to call certain other data about the