How to expand table to include all 52 weeks.

[Eloise T]

Please see picture below. I have a table that needs to go 52 weeks. Currently it only goes to 12 weeks. How do I expand the drop-down arrow/button to include all 52 weeks?




etc....

 

[Chihiro]

That will depend on your set up. How is drop down populated? Is it Data Validation list, ActiveX Combobox, or something else?

 

[Eloise T]

Please see attached file.

 

[KenU]

Eloise T,

You need only select the cell B2 and go to Data Validation (Data > Data Validation) to update the source range to include the full list of all 52 weeks (i.e., Source: =$A$7:$A$58).

Hope that helps.

Regards,
Ken

 

[Eloise T]

Eloise T,

You need only select the cell B2 and go to Data Validation (Data > Data Validation) to update the source range to include the full list of all 52 weeks (i.e., Source: =$A$7:$A$58).

Hope that helps.

Regards,
Ken

THANK YOU! I knew it had to be simple!