CELLS HAVING SAME NUMBER BY CHANGING ANY CELL
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 |
All times are GMT +1. The time now is 06:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com