Updating a cell
I want to achieve an outcome of if someone changes either cell A3 or B3, that
share the same validation list, then cell A1 updates depending on which was most recently updated. A1: Apple Lookup Price Check Product A3:Apple B3:Apple |
Updating a cell
You need a "worksheet change event". Dave McRitchie talks about them he
http://www.mvps.org/dmcritchie/excel/event.htm **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "JonathanW" wrote in message ... I want to achieve an outcome of if someone changes either cell A3 or B3, that share the same validation list, then cell A1 updates depending on which was most recently updated. A1: Apple Lookup Price Check Product A3:Apple B3:Apple |
All times are GMT +1. The time now is 04:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com