pdeshazier
05-15-2014, 10:51 AM
how do i loop thru all records and use a select case statement to populate a cell based on an existing cell's value?
for instance, i have a workbook containing company name, but i want to populate a cell on the same row with the company ID number which would be set in my select case statement.
in the attached sample file, i need column A read and based on the contents of each A cell, need the following numeric values populated in the next available column.
col A value new column value
SUMNER REG MED CTR 16750
TROUSDALE MED CTR 16751
RIVERVIEW REG MED CTR 16753
FAMILY PHYSICIAN PRACTIC 16754
HIGHPOINT CORP OFFICE 16755
HIGHPOINT HOMECARE 16756
HIGHPOINT HOSPICE 16767
for instance, i have a workbook containing company name, but i want to populate a cell on the same row with the company ID number which would be set in my select case statement.
in the attached sample file, i need column A read and based on the contents of each A cell, need the following numeric values populated in the next available column.
col A value new column value
SUMNER REG MED CTR 16750
TROUSDALE MED CTR 16751
RIVERVIEW REG MED CTR 16753
FAMILY PHYSICIAN PRACTIC 16754
HIGHPOINT CORP OFFICE 16755
HIGHPOINT HOMECARE 16756
HIGHPOINT HOSPICE 16767