How to generate random strings in Excel automatically using a macro: www.exceltrainingvideos.com/generate-random-strings-in-excel-automatically/

Very very intersting your all videos, thank you so much sir.

@Exceltrainingvideos

2 жыл бұрын

Thanks 👍

Thanks for your uploading useful information

@Exceltrainingvideos

2 жыл бұрын

Thanks and welcome

HI Sir Dinesh, Thank you for the Awesome tutorial, Can you do a tutorial that generates a name of person pulling from an excel list list?

Nice sir 👍

@Exceltrainingvideos

2 жыл бұрын

👍

How could we use countaA for P=countaA(A:A)-1 as For i = 2 To P

hi, why are you using the formula for 15 times using concatenate function to generate 15 character sting? just write 15 instead of 1 as the last argument of the Mid Function?

Nice Explained. Sir, How we can generate random words ?

@Exceltrainingvideos

2 жыл бұрын

Create random strings and compare the random strings with all words in an English dictionary. If it matches, place it in an appropriate cell.

sir , have you made any videos to send the data from master wb to closed multiple workbook based on the workbook name & specific column ranges.

@Exceltrainingvideos

2 жыл бұрын

This VBA lesson in Excel will help: www.exceltrainingvideos.com/how-to-copy-column-data-into-another-workbook/

@aryklanees5373

2 жыл бұрын

@@Exceltrainingvideos thank u sir

Hello sir. Your videos helped me a lot in building industry level applications and i am really thankful for that. Can you please show us, ho we can show the shapes on a userform selected from a listbox. Like, suppose there is a listbox consisting shape names like square, circle, triangle etc. And when I select any shape, it would show me that perticular shape on userform. Can you please help me with that?

@Exceltrainingvideos

2 жыл бұрын

OK

If you would like to help me sir with a job I have to do. It is a question of randomly dispatching a group of supervisors 2 by 2, from a list, over a number of rooms with the following conditions: Each pair should only meet once Each supervisor must pass only once in a room leave 20% of supervisors as replacements

@Exceltrainingvideos

2 жыл бұрын

This link will guide: www.exceltrainingvideos.com/staff-scheduling-solutions-using-solver-in-excel/

@mbarekmakhfi1635

2 жыл бұрын

Thank you very match sir