Excel VBA Basics #32 Create Sample Database Almost Instantly

📊 Free Workbooks: https://www.excelvbaisfun.com/links?utm_source=youtube&utm_medium=desc&utm_content=_UxBrF1_fx0 🥷Join Excel Ninja Pro: https://www.excelvbaisfun.com/ninjapro🔥(2 Months FREE On Annual Plan Auto Applied) 🥷Excel Ninjas FB Group: https://www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more) In this lesson, we show some methods of making "mock" or sample data in a flash. A lot of it can be done using simple vlookups in combination with the Randbetween function. So if the random number was 1, it would find number 1 and vlookup column 2 of that table and grab that result, but if the random number was 2 or 3 or 4 etc, it would grab different items from your small (or large) table or list. This is much better than typing a fake database up yourself. Check it out! Fantastic Developer Tools: 🔒 Transform Any Excel File Into A Locked EXE: https://www.excelvbaisfun.com/secure-excel-files (25% off with code ‘25OFF’) 🟡 Create Custom Installers: https://www.excelvbaisfun.com/custom-installers 👋 Business Inquiries, Consulting, Comments, etc: https://www.excelvbaisfun.com/contact/