VBA code for find data

yesterdays

Active Member
Joined
Oct 8, 2014
Messages
337
I know this question could have been asked before, but my problem is kind of more specific
-I have a workbook with 3 sheet : Part1, Part2, Part 3
-Each sheet contain 1 million line and 7 column of data ( this is why it can't be in 1 sheet)
-The order of columns as below:

FileName RollID NoClaim ClaimID FirstName LastName No

I can make sure the 1st column is unique in among of 3 mil line , the rest are none unique

So what I need is a userform where user can input either ClaimID or FirstName or LastName
and retrieve FileName (could be more than one)

P/s it would be perfect if i can get the position of them(FileName) too!

Thank in advance!( sorry for my English!)
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,913
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top