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

FIRST. QUIT YELLING!!!
It is considered to be very bad netiquette to type in all CAPs.
To do what you want you would need a worksheet_change event in the sheet
module.

--
Don Guillett
SalesAid Software

"JOHN MORREY" <JOHN wrote in message
...
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

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