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
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,089,228
Messages
5,407,005
Members
403,117
Latest member
redblasko

This Week's Hot Topics

Top