VBA Question - Multiple Combinations

[dentothep]

Hi,

I am new to this forum & hoping somebody can save my day (I also have close to zero experience with macros).

I have a macro which goes like this:


Case "TA"


Sheets("Conversion").Cells(a, 2).Value = "20100802;xxxx
Sheets("Conversion").Cells(a, 2).Value = "20100803;xxx
Sheets("Conversion").Cells(a, 2).Value = "20100804;xx
Sheets("Conversion").Cells(a, 2).Value = "20100805;xxx
Sheets("Conversion").Cells(a, 2).Value = "20100806;xxx
Sheets("Conversion").Cells(a, 2).Value = "20100807;xxx

In my data entry sheet, I want to add a column where I can enter "2" or "23456" or any combination of numbers between 2 & 8.

When the excel runs, I would like it to give values which are included in the cell.. for example if there is only a 2, I would like the result of only

Case "TA"


Sheets("Conversion").Cells(a, 2).Value = "20100802;xxxx

Any recommendations on how I can integrate this into the macro?