Hi,
I need to insert a particular number of columns in my Excel spreadsheet according to a lookup table. Then I need those columns labeled according to that table.
The lookup table has two columns and about 8 rows. First column is comprised of text strings, such as zipcode or age. Second column is the number of columns I need created for each field in the first column. So if the first value in column two of the lookup is 2, and it is associated with "zipcode", then I need two columns created. And, those columns need to be labeled as zipcode1 and zipcode2 or zipcode and zipcode.
I'm a total novice, so if possible, please include initial steps to get this VBA code going.
Thanks!
A
I need to insert a particular number of columns in my Excel spreadsheet according to a lookup table. Then I need those columns labeled according to that table.
The lookup table has two columns and about 8 rows. First column is comprised of text strings, such as zipcode or age. Second column is the number of columns I need created for each field in the first column. So if the first value in column two of the lookup is 2, and it is associated with "zipcode", then I need two columns created. And, those columns need to be labeled as zipcode1 and zipcode2 or zipcode and zipcode.
I'm a total novice, so if possible, please include initial steps to get this VBA code going.
Thanks!
A
