Clearing Specific Cells

[jamieleeuk]

I'll try to explain the best I can. Please let me know if you're not clear on what I want.

In column A, I have listed numbers (1 to 10) which on my sheet is Row 4 to Row 13. This list is headed "Call ID".

Columns B, C, D, E, F, G, H, J & K will have data which is imported from a userform. This information is constant, ie - textbox 1 on userform will always put into same columns and will put the data into the next available empty row.

Column I contains a concatenate formula to concatenate the data in columns F, G & H (which is Day/Month/Year)

B,C,D,E,F,G,H,I,J,K = Surname, Forname, Team, Office, Day, Month, Year, Start Date, Reported By, Date Stamp

Columns "Day, Month & Year" are hidden

In range M:4, I am going to have a cell with Data Validation which will allow data ONLY from a specified range, this range being the Call IDs (A4:A13).

I then want to press a button which looks at what call ID I have selected and delete the data for that row. I then want any subsequent rows of data to move up one row.

Is this possible?

 

[onlyadrafter]

Hello and welcome,

Have I got this correct?

Sub DELETE_CALL_ID()
    For MY_ROWS = 13 To 4 Step -1
        If Range("A" & MY_ROWS).Value = Range("M4").Value Then
            Range("B" & MY_ROWS & ":K" & MY_ROWS).Delete (xlUp)
            End
        End If
    Next MY_ROWS
End Sub

post back if this isn't exactly what you require.

 

[jamieleeuk]

You are what is commonly known as "A Legend"

Thanks!