Populate cell based on other cells

[dgaller]

I am trying to organize some data given to me using excel 2007. I have a spread sheet with basically 14 columns. Store,Month,Jan,Feb,Mar,Apr,may...

What I would like to do is populate the month column based on the other columns in a row that has data. i.e If the Feb Column has data put Feb in the month column. (only one column will be populated accross the months)

On a small scale I can use an If statement that works if(c3<>"","Jan",if(c4<>"","Feb" etc. but I cannot do all 12 months this way. I am only allowed so many if statements.

Is there another formula or code I can use for this?

 

[cb12]

Hi, here is a simplistic answer to your problem. Please replace the ranges with the relevant ones. It will only return the name of the month of the first column with data in, however you can replace the i = Empty with the relevant condition and if necessary swap the action with the else action. Anyway, I hope it can be of some use and avoid having potentially thousands of formulas on your sheet. One other thing is it currently will stop when there is a break in the data in column A, you may need to readjust the looping parameters if that is an issue.

Sub get_month()
Dim i, j, k As Integer
    Range("A1").Select
k = Selection.CurrentRegion.Rows.Count
    Range("C2").Select
    j = ActiveCell.Row
        Do While Range("A" & j) <> ""
            i = ActiveCell.Value
            j = ActiveCell.Row
                If i = Empty Then
                    ActiveCell.Offset(0, 1).Select
                    Else: Range("B" & j).Value = ActiveCell.Offset(-j + 1, 0).Value
                    Range("C" & j + 1).Select
                End If
        Loop
End Sub