CELLS HAVING SAME NUMBER BY CHANGING ANY CELL

J

JOHN MORREY

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
 
D

Don Guillett

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

JE McGimpsey

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".
 
Top