Macro help

[VBABEGINER]

Hi All, Long back again..

need help in terms of vba code.

I've created one column with the help of Rank formula. Now I want any 2 records of every rank number on another sheet. Randomly. any code can I get please..

 

[Fuji]

Do you just want 2 random for eacn rank from the rows marked "Consider" in col.BP?
If so,
try change
1)

    a = Range("bm2", Range("bm" & Rows.Count).End(xlUp)(1, 2)).Value

to

    a = Range("bm2", Range("bp" & Rows.Count).End(xlUp)(1, 4)).Value

2)

    For i = 1 To UBound(a, 1)
        dic(a(i, 2)) = Trim$(dic(a(i, 2)) & " " & i)
    Next

to

    For i = 1 To UBound(a, 1)
        If LCase$(a(i, 4)) = "consider" Then dic(a(i, 2)) = Trim$(dic(a(i, 2)) & " " & i)
    Next

 

[VBABEGINER]

Do you just want 2 random for eacn rank from the rows marked "Consider" in col.BP?
If so,
try change
1)

    a = Range("bm2", Range("bm" & Rows.Count).End(xlUp)(1, 2)).Value

to

    a = Range("bm2", Range("bp" & Rows.Count).End(xlUp)(1, 4)).Value

2)

    For i = 1 To UBound(a, 1)
        dic(a(i, 2)) = Trim$(dic(a(i, 2)) & " " & i)
    Next

to

    For i = 1 To UBound(a, 1)
        If LCase$(a(i, 4)) = "consider" Then dic(a(i, 2)) = Trim$(dic(a(i, 2)) & " " & i)
    Next

Hi Fuji, I appreciate once again for your valuable time and effort for sharing solution with me. But not getting as per my expectation. I've attached one more screenshot, it will help you to understand what my expectation output is.

 

[Fuji]

Can you share the list via XL2BB?

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

 

[VBABEGINER]

Can you share the list via XL2BB?

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

options are disabled..

 

[Fuji]

Does this help?

XL2BB Disappears when Excel is Reopened

If this happens to you, try one of these options: Option A: Close Excel Find the Add-In file in Windows File Explorer Right click - Properties On the 'General' tab, is there an 'Unblock' box at the bottom? If so, tick that box then click OK Reopen Excel Option B: An alternative to the above...

www.mrexcel.com

 

[MARK858]

XL2BB Icons greyed out

Hi Team, i am unable to copy the data throught Xl2bb as buttom got disable please see the screen shot can anyone hlep me this. Regards Sanjeev

www.mrexcel.com

 

[VBABEGINER]

Thank You Experts for your valuable time and sharing me options to get XL2BB but it is get blocked by IT and hence disable macro dosent work. I've to post this from my personal laptop. Let me try that

 

[Fuji]

OK,
I will be off line soon, so my next response will be sometime tomorrow. (it's close to midnight here)
Please, the sheet should contain row data(should be dummy) and the result that you want, so that I can see what you are really trying to achieve.

 

[VBABEGINER]

Now I've tried from my personal laptop but Im getting attached error msg when i try to add xl2bb add in

 

[MARK858]

What is Protected View? - Microsoft Support

See what Protected View is and how it can help protect you from potentially malicious software.

support.microsoft.com