Hi all,
I have a list of data (A1 to G20 containing ID, First_Name, Last_Name, etc..). I need a function or a procedure in VBA to randomaly select one record at a time (only the cells that contain the First_Name and Last_Name). And output the results on another sheet without having the random cells repeat themselves, i.e, the employee will be chosen just once. I managed to write the code in VBA Access but somehow I can't do it in Excel. I could link the code to a command button.
Thanks fo your help.
I have a list of data (A1 to G20 containing ID, First_Name, Last_Name, etc..). I need a function or a procedure in VBA to randomaly select one record at a time (only the cells that contain the First_Name and Last_Name). And output the results on another sheet without having the random cells repeat themselves, i.e, the employee will be chosen just once. I managed to write the code in VBA Access but somehow I can't do it in Excel. I could link the code to a command button.
Thanks fo your help.