Auto populating data from Drop Down while referencing other sheets in the Workbook

Vai2217

New Member
Joined
Oct 26, 2015
Messages
1
We have data pertaining to the amount and order we have recieved segregated based on location and mediums like Website and Facebook. I am building a summary sheets that will display selected information from the other sheet for a particular location. I tried using VlookUp but that does not working with drop downs.

Drop-down list:
Website - Whitefield
Mobile - Whitefield

I want specific data from another sheet to populate on the summary sheet once a value is selected from the drop-down.

Below is a reference to the data.

Website - Location

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Total Orders[/TD]
[TD]Amount Spent[/TD]
[TD]Cost Per Conversion[/TD]
[TD]Const Per Acquisition[/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]15[/TD]
[TD]1800[/TD]
[TD]1800/15[/TD]
[TD]1800/New Orders[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What I want is when some one selects Website - Location in the drop down on the summary sheet, the above table should appear. Similarly, it should repeat for other options in the drop down with same headers.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Forum statistics

Threads
1,223,228
Messages
6,170,874
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top