Updating the data for a ComboBox
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Updating the data for a ComboBox

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hello,

    I have the data which would populated my combobox in Sheet2 on my workbook. They are the months of the year formatted as January-02 thru to December-02.

    Is there any way I can have these updated automatically on the first day of the proceeding years.

    Thanks

    Carol

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi Carol

    Have a look at my examples od Dynamic ranges here: http://www.ozgrid.com/Excel/DynamicRanges.htm

    They can be made to expand each day, week, month or Year.



User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com