Hi All,

I'm new to Excel ( and to this forum :) ) and so I hope somebody may be
able to help me.

I've got 2 questions....

QUESTION 1:
I've got a spreadsheet which takes data from one worksheet and uses it
to calculate data in a second worksheet using the following code /
formula:

=IF('4th November 2005'!B19="","nothing here dude",IF(B19<'4th November
2005'!B19,"UP",IF(B19='4th November 2005'!B19,"Same",IF(B19'4th
November 2005'!B19,"DOWN"))))

The problem is, when I create a new worksheet I have to go through and
update all of the references to the previous worksheet. I know that I
can do a "find and replace" (which isn't too much of a pain), but what
I would like to do is use some kind of a relative (rather than
absolute) formula.

So instead of saying "go to the worksheet called '4th November 2006' "
I could instead say "go to the sheet which preceeds this one"

- hopefully that makes sense! :)

QUESTION 2:
In addition to the above formula (which just tells me if a value is
higher, lower, or the same as the previous value) is it possible to
calculate what the difference is and display that in brackets?

_For_example:_
If a result in the spreadsheet for "4th November 2005" = 6 and the
result in the spreadsheet for "4th February 2006" = 1, it would show:
"UP (+5)"

Even better still, could I -also -reference an image (up arrow / down
arrow) so that I could generate a result which looks a bity like those
you get in the music charts.

Cheers!
Kessa


--
kessa
------------------------------------------------------------------------
kessa's Profile: http://www.excelforum.com/member.php...o&userid=32080
View this thread: http://www.excelforum.com/showthread...hreadid=518338