Lookup information from another sheet using VBA

[mamady]

Hi All,

I have a list of information in sheet 1, like the following table

Country	Month	Subject	Item

and in sheet 2, I created a layout with a drop list for Country and Month attributes

I want a VBA code that will retrieve/lookup the subject and item based on select Country and Month attributes and assign that macro to a button

the layout in sheet 2 looks like the following

Country	[drop list]	Month	[drop list]
Subject
Item
Item
Subject
Item
Item

given that for each country and month, there is a maximum of 6 subjects and 4 items under each subject.

I would appreciate any support,

thank you in advance

 

[Darren Bartrup]

Cross-posted: ​

Lookup information from another sheet using VBA

I have a list of information in sheet 1, like the following table headings County - Month - Subject - Item and in sheet 2, I created a layout with a drop list for Country and Month attributes I ...

stackoverflow.com

Please take a minute to re-read the forum rules on cross-posting and follow them in future. Thanks. ​

 

[mamady]

Cross-posted:

Lookup information from another sheet using VBA

I have a list of information in sheet 1, like the following table headings County - Month - Subject - Item and in sheet 2, I created a layout with a drop list for Country and Month attributes I ...

stackoverflow.com

Please take a minute to re-read the forum rules on cross-posting and follow them in future. Thanks.

Thanks for bringing this matter to my attention

 

[mamady]

anyone can help me, please!