Update info in a worksheet dinamically when a drop box change its vaules

J

Jaime Matus

Hi all.

I have a template in a worksheet (sheet_template) where I need put
info related with a single option of a drop box (let´s say, month of
the year, dropbox_months()). When I change those box option (months)
the info should change automatically.

I made a simple procedure to copy the month related info to another
sheet. Let say that procedure is copy_content()

My problem is that I don´t know how to made secuentally (assuming
that I changing from month M to month K:

1. change (dropbox_months(M))
2. copy_content (M) * in sheet Month_M *
3. retrieve content sheet K
4. copy_content (K) * in sheet_template.


Note that when I change the dropbov_months () options, there is othe
info of the sheet_template that change accordingly (update the days of
the months), so this secuence shoul occur before those cells are
updated.

Any advice ?

Thanks in advance.

jmc
 
Top