Help with Select Case or Best Method

C

Christina

I have a large range of data that can be anywhere from 100 to 500
lines. This range consists of A3:D??. The information in Column B will
decide the code to be put in Column A.
ie.. IF Column B Then Column A
26 1
26.3 2
27 3
33 4
33.3 5 Continues on to 23.

I'm sure it will include a select case and a some type of looping. I
would appreciate any help that can be offered here.

Thank you,
Christina
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Case 8
Fill Color Macro 5
Select Case: Multiple Ranges? 2
Select Case "Procedure to large" Error 1
select case simplification request 7
Help!! find two number recurring numbers in row?? 1
Generate Subtotal Summary from Sheet1 into Sheet2 16
Subgroup from the Main Group of Data Consolidate 0

Top