H
HJS Consultants Ltd
I have 13 worksheets that are all linked together. My report sheet (worksheet
1) is a Year-to-date report. I want to have a combo box in one of the cell's
in worksheet 1 where you can choose the month that you want to compare to the
year to date and the information that I have on the monthly worksheets
(2-13), say if I choose January from the combo box, will appear in worksheet
1. How do I do this? How do I create a combo box with 12 monthly options and
then when I choose a month the information for that month appear on the
report worksheet?
1) is a Year-to-date report. I want to have a combo box in one of the cell's
in worksheet 1 where you can choose the month that you want to compare to the
year to date and the information that I have on the monthly worksheets
(2-13), say if I choose January from the combo box, will appear in worksheet
1. How do I do this? How do I create a combo box with 12 monthly options and
then when I choose a month the information for that month appear on the
report worksheet?