Excel Program Question

[Guest]

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)

 

[Guest]

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

 

[Guest]

Ok, that is really way over my head. Is there anyone who might be able to
give me an idea or help with this small project. Here are some more details:
A43 is where the user can select the month from a drop down list.
A45 is where the results should show from pulling from the sheet labeled
matching the month the user has selected.
C3 is the cell on the sheet of the selected month of the user.

Thanks

 

[Roger Govier]

Hi

Try
=INDIRECT("'"&A43&"'!&A1)
where A1 represents the cell on the relevant sheet that you wish to pick
up.

Note that there are single quotes inside the double quotes
( " ' " & A43 & " ' ! " &A1)

With A1 relative, as you copy across it will change to B1 etc, and as
you copy down it will change to A2.

Adjust to suit your needs.

 

[MyVeryOwnSelf]

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.

... A43 is where the user can select the month from a drop down
list. A45 is where the results should show from pulling from the sheet
labeled matching the month the user has selected.
C3 is the cell on the sheet of the selected month of the user.

Here's one way.

In the A43 drop-down list use the same names that are the tab names;
maybe, Jan, ..., Dec.

Then in A45 put
=INDIRECT(A43&"!C3")

 

[Guest]

Awesome! Thank you all very much!

Here's one way.

In the A43 drop-down list use the same names that are the tab names;
maybe, Jan, ..., Dec.

Then in A45 put
=INDIRECT(A43&"!C3")