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