This requires an event macro. Are you interested in that approach?

If so, post back (in mixed case, not ALL CAPS) with more information
about how the information should "change".

In article ,
"JOHN MORREY" <JOHN wrote:

I AM TRYING TO CREATE A FORMULA SO THAT WHEN I CHANGE INFORMATION IN ONE CELL
IT CHANGES THE INFORMATION IN OTHER CELLS THAT I HAVE SELECTED BUT THIS
INFORMATION NEEDS TO BE CHANGED IN ANY OF THE SELECTED CELLS. SO IF
INFORMATION WAS BUT IN D3 INFORMATION IN D4 WOULD CHANGE AND VISA VERSA.

PLEASE HELP