How to use a drop down menu/list and option button to populate a worksheet.

twinny

New member
Joined
Jul 1, 2011
Messages
7
Reaction score
0
Points
0
Hello All,

Please i need help (macros) with this presentation i am working on. I have two worksheets(presentation and data) in my workbook(sample sheet). The data worksheet contains the all the data needed by the presentation worksheet. I need help to use the option button and dropdown menu to populate the presentation worksheet.
Please find attached the sample sheet for better understanding of this.

Any assistance rendered will be highly appreciated.

Thank you


twinny
 

Attachments

  • sample sheet.xlsx
    19 KB · Views: 52

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Try this formula

=INDEX(Data!$4:$9,MATCH(Presentation!$C$4,Data!$A$4:$A$9,0),($D$1-1)*8+COLUMN(A$1)+1)
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Just noticed, you don't need the MATCH

=INDEX(Data!$4:$9,$C$1,($D$1-1)*8+COLUMN(A$1)+1)
 
Top