insightunlimited17
New Member
- Joined
- Feb 7, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
0
I have two sheets (As Diplayed Below). Sheet 1 or INformation is where i have all of my information Stored. And Sheet 2 is where i want it displayed based on the Urgency (Tab Selection).
Please can someone help me with a VBA code which can load this data on each of the Sections on Sheet 2. Producing multiple results in separate rows if the same Urgency selection is made. I tried it with INDEX MAtch and it works but it makes the file extremely slow.
=INDEX('Information'!B8:B12, SMALL(INDEX(MATCH($A$2, 'information'!I8:I1048576, 0), ), ROWS($A$1:A1)))
Sheet 1 - INFORMATION: This sheet contains all the data.
Sheet 2 - Urgency: Where I want to display my Data.
I have two sheets (As Diplayed Below). Sheet 1 or INformation is where i have all of my information Stored. And Sheet 2 is where i want it displayed based on the Urgency (Tab Selection).
Please can someone help me with a VBA code which can load this data on each of the Sections on Sheet 2. Producing multiple results in separate rows if the same Urgency selection is made. I tried it with INDEX MAtch and it works but it makes the file extremely slow.
=INDEX('Information'!B8:B12, SMALL(INDEX(MATCH($A$2, 'information'!I8:I1048576, 0), ), ROWS($A$1:A1)))
Sheet 1 - INFORMATION: This sheet contains all the data.
Sheet 2 - Urgency: Where I want to display my Data.