MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Change Data of The Cell from any Place...

  Asked By: Cameron    Date: Dec 18    Category: MS Office    Views: 1778

Please can some one tell me if the following is possible and how?

I have one Workbook with 10 worksheets where the cell A3 is exchange rate
EUR/USD. How can I change the 10 cells value one I change any one of those
10 cell value?



1 Answer Found

Answer #1    Answered By: Rebekah Walker     Answered On: Dec 18

There is the easy way to do this, and the hard way. The easy way would
to be to link all 10 cells  to the same input from another cell  or a
dialog box, and make the 10 cells protected so they couldn't be
overwritten in any other way,

But if you wanted the hard way, you could put code in the Change event
on each worksheet to write the updated value to all 9 other sheets.

Didn't find what you were looking for? Find more on Change Data of The Cell from any Place... Or get search suggestion and latest updates.