Glad to have been able to help.
--
David Biddulph

"ThunderStorm Studio" wrote
in message ...
...and there from the heavens angel fall upon those in need. THANK YOU ALL
for your help. And the kicker was the fact that I DID have the sheets
grouped. Imagine that! Can't say how it ever happened, but I now know what
to
look for when it does happen again. Once again, thank you all!

"David Biddulph" wrote:

If you've got the same formula on both sheets, it sounds as if you may
have
inadvertantly grouped the sheets before you put the formula in. Ungroup
the
sheets and try again. Note that while your sheets were grouped, anything
you did on one sheet will have affected the others, so you may want to go
back to a backup from before you did this.

"ThunderStorm Studio"
wrote
in message ...
These formulae seemed to be viable, but when performed, I get the same
300
on
the other sheet. This is what I did:
taking the first formula you gave me, I substituted Sheet1 for my
sheet's
name, in this case it being PAY. I then substituted the cell to which I
wanted to reference, minding that all cell numbers on the input sheet
are
the
same as the output sheet.
Once I hit ENTER, the formula shows up in the cell itself. I then go to
the
PAY sheet and the formula is also there, which is a good sign...the
second
sheet, named PAY AFTER DEDUCTIONS, is communicating with the PAY sheet.
But
inputting 300 also gives me 300 on the DEDUCTIONS sheet. Is there
something
wrong with my substitutions? Following this format, I did the same
thing
with
the second formula and it didn't fare any better. Please help if you
can!

"Gord Dibben" wrote:

In a cell on sheet2 enter this formula.

=Sheet1!A1*.85

OR =IF(Sheet1!A1="","",Sheet1!A1*.85)

On Sun, 17 Feb 2008 19:42:01 -0800, ThunderStorm Studio <ThunderStorm
wrote:

I'm trying to connect two worksheets together whereas the input into
a
cell
of one will influence the outcome in the cell of another.

EX: Inputting 300 in a cell of the first sheet will give me an answer
in
a
cell of the second sheet, less 15%.

Is this at all possible? The sheets are in the same workbook. and the
value
of one must impact the second.

Many thanks for any information.

Regards,
Robert