How do I code a program that will create drop down lists from input and populate columns in another sheet with drop downs : <p>I am new to VBA and currently know how to create Macros using the "Record Macro" option. I need to code something that does multiple steps in VBA.</p>

<p>I will have an unknown number of columns that I need the program to go through and check if the second row has a value in it.(These columns and rows will be input from a user so the number of columns or entries per row is unknown). </p>

<p>The values under each column are the possible categories a user will later choose from for that specific variable. So in Sheet 1 there is a variable "Sex" there will be one row under it saying "female" and another row under that saying "male". These have to be made into a drop down list and pasted under another sheet (Sheet2) in which the same column names (Sex) will now have drop downs under them.</p>

<p>Steps to take: </p>

<p>1) IF Column(i)'s Row 2 is not empty</p>

<p>2) Then define all rows below it as a list and make a drop down of this list</p>

<p>3) Then paste this drop down under a column that matches the name of the Column(i) in another sheet</p>

<h1>SHEET 1 (what i have)</h1>

<pre><code>Age      | Sex    | Race   | Height 
------------------------------------
[EMPTY]  |Female  |Asian   |[EMPTY]     
[EMPTY]  |Male    |Black   |[EMPTY]          
[EMPTY]  |[EMPTY] |Hispanic|[EMPTY]          
[EMPTY]  |[EMPTY] |Native A|[EMPTY]          
[EMPTY]  |[EMPTY] |White   |[EMPTY] 
[EMPTY]  |[EMPTY] |Other   |[EMPTY] 
</code></pre>

<hr>

<h1>SHEET 2 (what I want)</h1>

<pre><code>AGE      | Sex               | Race                | Height
------------------------------------------------------------
[EMPTY]  | [dropdown of sex] | [dropdown of race]  |[EMPTY]
</code></pre>
