Delete the content if it has complete set of data

[ccs_1981]

hi all,

good day.

i facing a problem here how to delete a data in 1 column.
i don't know how to explain, so i attach the excel file here to explain.

Hope can solve it.

Thanks.

[stanleydgromjr]

ccs_1981,

See the attached workbook "Create Summary - Countif Match - ccs_1981 - SDG10.xls" with macro "CreateSummary".

Detach/open the workbook and run the "CreateSummary" macro.

[ccs_1981]

ccs_1981,

See the attached workbook "Create Summary - Countif Match - ccs_1981 - SDG10.xls" with macro "CreateSummary".

Detach/open the workbook and run the "CreateSummary" macro.

thanks, but you already hardcode to 3 restaurants. anyways can solve it beside hardcode? i may hv more than 10 restaurants...

[ccs_1981]

anyone can help?

[stanleydgromjr]

ccs_1981,

How about another workbook with examples of "i may hv more than 10 restaurants...".

And, what is the logic for more than 3 restautants?

[ccs_1981]

ccs_1981,

How about another workbook with examples of "i may hv more than 10 restaurants...".

And, what is the logic for more than 3 restautants?

thanks for your reply, i thought u had hardcoded to max 3 records.

 For a = 2 To LR2 Step 1
    If .Cells(a, "F").Value < 3 Then
      Hold = ""
      SR = .Cells(a, "G").Value
      For b = 1 To .Cells(a, "F").Value Step 1
        Hold = Hold & .Cells(SR, "A") & ", "
        SR = SR + 1
      Next b
      If Right(Hold, 2) = ", " Then
        Hold = Left(Hold, Len(Hold) - 2)
        .Cells(a, "D") = Hold
      End If
    End If
  Next a