title: Auto Generate Excel Table Using VBA
body: <p>I should preface this question by stating that I have 0 experience using any of the advanced features of Excel, and now that I need to use them, I have no idea what I am doing. </p>
  
  <p>I need to generate an excel table with the following columns: ID, firstname, lastname, password, and phone in each column. I need N entries in each column, where ID, firstname, and lastname are just random characters, up to X characters, password is random upper case, lower case, and alphanumeric characters, up to Y characters, and phone is a random 10 digit int. I can generate the random strings easy enough, its checking to make sure the content is unique to anything else already in the table and adding it that I have no clue about. I am on a Mac, so this could also be done in bash, creating a csv file, another area I know very little about, but I figured since it is Excel specific, and I am going to need similar skills going forward, I should start learning VBA.</p>