What i have is a spreadsheet with 13 worksheets (one for each month of the year) and one sheet with a drop down list box with the months of the year. what i want to do is link the month in the drop down list box with the corresponding sheet, so that when i select January in the drop down list box it will take me to the January worksheet etc. How do i do it??

Try posting to the Excel forum.

I don't think there is an Excel Forum here. :) I would create a Macro that ties into each month...Like an Go To statement that takes you to the corresponding worksheet for the month selected.

That's my point Jennifer. This is supposed to be a W2k forum not an application help desk.