I'm thinking that you want to use a Worksheet_SelectionChange Event to do
this. You can read more about events he
http://www.cpearson.com/Excel/events.htm


"RJ Swain" wrote:

Thank you to all who look and possibly find a solution to my dilema.

I have a worksheet that I am working on that has 13 pages. 12 pages that
represent the months in the year and the 13th page is the planner page. On
the planner page there is an area where the user may select a month and on
that portion of the planner worksheet I would like for it to be able to
populate the planner work sheet with the percentages from the same month the
user is requesting. (ex: user selects april on planner and it populates on
the planner various sales figures found on the april worksheet that
correspond to that sales catergory)