Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Headers & Footers _auto update info from a cell in the worksheet | Excel Discussion (Misc queries) | |||
Update info from website to worksheet automatically, w/o opening s | Excel Discussion (Misc queries) | |||
drop down boxs with diff vaules | Excel Discussion (Misc queries) | |||
Update a column data with info from new worksheet | Excel Discussion (Misc queries) | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) |