Survey Response - Listing responders, not counting number of responses

[tmaxwell83]

Hello,

Long time lurker, first time poster here.

I'm trying to create a data management system and having trouble with this one last forumla – which is the difference between me being able to sleep at night and staying up ripping my hair out.


The below screenshot is a crude replication of what I want to do.

On the front end, the respondents will give their responses, but on the back end I want to see who gave what response and add that data to a separate table.

If anybody can help I would be extremely grateful.

Thanks,

Tim

 

[footoo]

Assuming there are only 3 possible responses and the headings are already in F2:H2, then :

Dim rng As Range
Set rng = Range([E3], Cells(Rows.Count, "B").End(xlUp)(1, 6))
Range([E3], Cells(Rows.Count, "G")).ClearContents
Application.ScreenUpdating = False
With rng
    .Formula = "=IF($C3=E$2,$B3,#N/A)"
    .Value = .Value
    .SpecialCells(xlCellTypeConstants, 16).Delete Shift:=xlUp
End With
Application.ScreenUpdating = True

 

[tmaxwell83]

Wonderful!

Thanks a lot.

Macros are well above my capability so that is much appreciated!