ganesh3084
07-27-2011, 02:48 AM
Hi all
Im creating a macro which consists of two excel files.
in one excel file, there are four fields named Sno,Name ,Ps ID and Case ID. The user will provide Sno,name and PS ID.
I need to run a macro of which for Each Name, i need to pick 5 CaseIDs Randomly which is presented in a another excel file which has list of CaseIDs .
I need to check the count of CaseIDs presented in the Second Excel As Well.
I knew that i need to use Rnd() function. But i dont know how to code it since im very new to excel vba.
Plz suggest me
i have posted the original thread in the following forum link
http://www.ozgrid.com/forum/showthread.php?t=156529
Ganesh. V
Im creating a macro which consists of two excel files.
in one excel file, there are four fields named Sno,Name ,Ps ID and Case ID. The user will provide Sno,name and PS ID.
I need to run a macro of which for Each Name, i need to pick 5 CaseIDs Randomly which is presented in a another excel file which has list of CaseIDs .
I need to check the count of CaseIDs presented in the Second Excel As Well.
I knew that i need to use Rnd() function. But i dont know how to code it since im very new to excel vba.
Plz suggest me
i have posted the original thread in the following forum link
http://www.ozgrid.com/forum/showthread.php?t=156529
Ganesh. V