Month end report ? expansion...

[shane476]

Posted this yesterday, got a few responses that didn't really help, fro
what I could tell. I have attached a very basic sheet showing what I a
looking for......

I am looking to pull data from the 'data' tab based on the mont
selected.

In 'month report' cell f4, I want to put a pull down box with all 1
months. When a certain month is selected, lets say May, pre programme
forumlas in the 'month report' sheet pull from the correct cells on th
'data sheet'.

Ie....
May
'Month Report' cell pulls from 'Data' cell
c7 b9

c15 c25

d23 k41

Any help is greatly appreciated....just looking for at least a righ
track. Thanks

Attachment filename: report example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63335

 

[Frank Kabel]

Hi
without looking at your attachment (as I - as most other people - won't
open these attachments) is there a logic which cells should be 'pulled'
depending on your month?

 

[Raeven]

Example attached. You can revise as needed.

Stephani

Attachment filename:
Download attachment: http://www.excelforum.com/attachment.php?postid=63346

 

[Frank Kabel]

Hi
as said: please plain text -> won't open your attachment

 

[shane476]

For pivot table response, I see no attachment......

Here is as close as I can copy text. Ideally, the pull down menu woul
change the functions below to reference the corresponding cells in th
'data sheet'

'Month Report' sheet

Month: Looking for pull down menu here

Plant 1
Plan Actual
Direct INV
Indirect INV
% of sales

'data' sheet
Plant 1 Plan Actual
Direct Indirect %/sales Direct Indirect
%/sale
January
February
March
April
May
June
July
August
September
October
November
Decembe

 

[shane476]

didnt turn out to look right.....the plan and actual labels are suppose
to be tabbed over, indicating planned direct, planned indirect, etc....

 

[Raeven]

I'm not really sure what you mean by "tabbed over." I've made som
revisions, and maybe they will help. Let me know if you need anythin
else.

Stephani

Attachment filename: month end.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=64087