View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BigPig
 
Posts: n/a
Default How do I link mulitple drop down boxes together?

Hi Misty,

Did you sort the '1-11', '12-24' and so on? A way to do it is:

1. Make sure that the cells that hold the 'No of Sheets', are formatted as
text.

2. Highlight the range minus the 'WoodTypes' Column.

3. Go to 'Data', 'Sort', 'Options', 'Sort Left to Right'.

Let me know if this works.