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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,095,380
Messages
5,444,113
Members
405,268
Latest member
JLEMS

This Week's Hot Topics

Top