Displaying values from multi-select dropdown boxes from different worksheets on one worksheet

GHVDS

New Member
Joined
Nov 1, 2022
Messages
4
Office Version
  1. 2010
Platform
  1. Windows
I really hope that the thread title adequately describes the issue I currently have...

@John_w has kindly given me a very good solution for deselecting from a multi-select dropdown, which was an issue that had me puzzled for a long time.

I now have a workbook with 3 worksheet (sheet 1, sheet 2, sheet 3), that each have two multi-select dropdown fields on it. I want to have an overview worksheet that allows a user to see the scores of each worksheet next to each other.

I tried to copy the multi-select dropdown fields from each worksheet and "Paste Special - Validation" on the overview sheet. However, that doesn't seem to update as I change the values in the dropdowns on the sheet. Can anyone advise me what my best course of action would be?

I have used the VBA code from @John_w on all worksheets.

I look forward to any advise!

Thanks
Geert
 

Attachments

  • Example.png
    Example.png
    23.5 KB · Views: 9

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,213,560
Messages
6,114,306
Members
448,564
Latest member
ED38

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