I am having difficultly automating hyperlink insertion into a
spreadsheet. I need the value of the individual cel to be incorporated
into associated the hyperlink.
Example:

How can i add an item to an allready existing graph in excel?
the item must be added automaticly when i type another value in the table
witch my graph is based on.
if there are for example 5 items added in the graph you can't reserve space

i would like to transpfer data from an excel spreadsheet into antoher
document, but when i paste it I would like the current date to automatically
transfer next to it.

thanks again
you've made my life easier
now if I could only type

I am using Excel 2002 and have a column of numbers anywhere between 8 and
16 digits in length that may also contain spaces or dashes. What I need to
do is get the first and last 4 numbers into separate columns, (which I will
merge later).Basically I need to throw out everything ...

IS THERE A WAY TO COPY THE RESULTS IN TEXT FORMAT FROM
WINDOWS EXPLORER OR A SEARCH TO EXCEL?

You've created a monster...
is 3 the limit to the formulas in Conditional formatting?
what if I wante next months colour to change as well :rolleyes
--

I have a worksheet that has 8 columns and 105 rows. Each cell gets the data
from another sheet in the workbook.
I can't seem to be able to fill down the formula the way I need it.
The first row in the first column gets the data from 'Daily Data'!A8, the

When I am doing a Cash Flow from time to time the result in the final (Final
Balance) column is a negative one, e.g. -?500.00 To make it more noticeable
I change the colour from black to read for that one cell.
Is there a way of programming the Excel process, so that the negative

I want to just do a simple copy action using visual basic for application in
excel.
In a directory I have some file that need to be copied by time. Most of the
files have the extinction .dat (like file1.dat, file2.fat..etc...). And

Without going into unnecessary details as to why, I have written a macro
which, among other tasks, hides 10 rows. Within these rows is an Option
Button (created with the Control Toolbox under View Toolbars) which I also
wish to hide. The rows hide without any problems, but the ...

office 97.... i'm using..
i think office XP dont have this problem ..rite?.
--
tpk103

thanks alot guys
I have it working now
this will save me a ton of scanning over dates with a visual que
I have 8 pages with 6 rows of due dates on each pag

How do I sort multiple worksheets containing columns with
similar data all at the same time?  for example; if I have
10 worksheets in a workbook with the column to be sorted
containing the same type of data, I would like to sort the

I'm probably missing something
here is what I'm doing
Formula 1    =F5:F60=
Formula 2    =MONTH(TODAY())=MONTH(F5:F60)