View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mariano Mariano is offline
external usenet poster
 
Posts: 2
Default Dynamic comments

Comments is a nice way to give information to users,unfourtunately I´m not
able to make dynamic comments.

Example:
I show sales in sheet 1 cell A1 (for instance 100)
Sales is populated from the sum sheet 2 A1=Europe 50 and A2 sheet 2 =USA 50

I want a comment in sheet 1 cell A1 displaying Europe 50, USA 50

If I change sheet 2 then sheet 1 cell A1 and its comments are updated.

Thanks for you help