Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Headers & Footers _auto update info from a cell in the worksheet N Walton Excel Discussion (Misc queries) 4 July 17th 09 02:36 PM
Update info from website to worksheet automatically, w/o opening s Juliana Excel Discussion (Misc queries) 0 March 5th 08 02:54 PM
drop down boxs with diff vaules rl71066 Excel Discussion (Misc queries) 0 November 21st 07 06:46 PM
Update a column data with info from new worksheet BRB Excel Discussion (Misc queries) 3 November 21st 06 01:57 PM
change info in other cells when i change a number in a drop list? macbr549 Excel Discussion (Misc queries) 2 September 11th 05 02:07 AM


All times are GMT +1. The time now is 01:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright Đ2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"