Find ID's that occur across Selected Sheets

rkol297

Board Regular
Joined
Nov 12, 2010
Messages
125
Hello,

I have an Excel Workbook that has five separate sheets on it, and on the sixth sheet I would like to be able to select 2 or more (3,4,5) of the sheets independently and see only the values that appear on the sheets selected in a dynamic fashion. I think I know how to do it as a one time thing but I don't know how to make it dynamic in nature so that others can select which sheets they would like to see ID's on.

Is this possible?

Any assistance would be greatly appreciated.
R
 

Forum statistics

Threads
1,077,687
Messages
5,335,662
Members
399,032
Latest member
thefinu

Some videos you may like

This Week's Hot Topics

Top