Update info in a worksheet dinamically when a drop box change its vaules
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
|