Here in attached sheets i want to find unique value comparing a master sheets with there multiple slave sheets .Requesting to help on it .
Here in attached sheets i want to find unique value comparing a master sheets with there multiple slave sheets .Requesting to help on it .
FAR too little information.
If a value occurs in the slave sheets, does it only occur once, or can it occur multiple times?
If multiple times, can it appear more than once on a single sheet?
What cell range is to be checked on the slave sheets?
How many slave sheets are there?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
If a value occurs in the slave sheets, does it only occur once, or can it occur multiple times?>>>>>> yes it occur multiple times.
If multiple times, can it appear more than once on a single sheet?>>>>>>yes it appear more then once on a single sheets
What cell range is to be checked on the slave sheets? >>>>>>>>>any whole column at slave sheets.
How many slave sheets are there?>>>I have at 10 slave sheet.
Any formula checking 10 different sheets, in their entirety, will be VERY VERY slow. You will really need VBA. Is that acceptable for you? If so, I will move your thread.
sorry for my late reply .kindly request you to proceed with VBA .thankyou
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks