....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!

Regards,

Robert

"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.
--
David Biddulph

"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)


Gord Dibben MS Excel MVP


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