Excel VB coding help

[ssavvidis]

I have created a list of names with a series of drop down boxes of questions in the connected rows. What I'm looking for is that in the list, there is a list of names in one column and the other columns have drop down lists with yes and now. In column F, if "yes" is selected I want the entire row to be copied to sheet 2, in a new list of all the yes answered rows.

 

[ssavvidis]

I would like to post an attachment of the actual spreadsheet for reference but for some reason it says that I'm not allowed to post attachments.

 

[ssavvidis]

Not to keep spamming my own post but one more option that might be simpler. If the value in column f is yes, then to copy row to sheet two in a new list.

 

[Juanca1080]

Well, if I understand you correctly, what you want the macro to do is to copy the entire row based on the value in column F. I also assume that sheet 2 already exists. If so you could try this (although it's not the fastest way to go)
Give it a try and tell us if you have any kind of problem or are looking for a more efficient method (It may depend on the amount of data to analyze)

Sub NewList()
Dim LastRow As Long
LastRow = Sheets(2).Range("F65536").End(xlUp).Row
Sheets(1).Activate
Range("F1").Select
Do While ActiveCell.Value <> ""
If ActiveCell.Value = "Yes" Then
ActiveCell.EntireRow.Copy Destination:=Sheets(2).Rows(LastRow)
LastRow = LastRow + 1
End If
ActiveCell.Offset(1, 0).Select
Loop
End Sub

 

[ssavvidis]

Sorry but im super new to this. How and where exactly do I put this to make it work?

 

[Juanca1080]

Ok, These are the steps you should follow in order to try the macro.
1. Open the workbook that contains the data to process.
2. Press Alt + F11
3. In the new window that appears, look the upper-right menu named VBAProject, right click inside it and select Insert - Module.
4. Note an empty page that appears in the left side (that’s the new module). You should paste the code there.
5. To execute the macro, just place the cursor in the code and press F5.

I hope this help you to try the macro.
As I said before, I’ll be glad to help in case you have any problem with the procedure.
Also remember there are other ways to complete this task, which may result more convenient for large amounts of data, so let me know if you need to speed up the macro.

 

[ssavvidis]

Doesn't work. Is there a way that I can upload my spreadsheet for you guys to look at and have a better idea of what im looking for?

 

[MARK858]

Explain exactly what you mean by

In column F, if "yes" is selected I want the entire row to be copied to sheet 2

What do you mean by "selected" that it gets moved if you click on the cell, right click the cell, click a button, something else?

 

[Juanca1080]

As far as I know you can't attach the workbook here, however I guess you could use an external uploading service and then post the link to download it.
By the way, when you say that that the macro didn't work, it's because you get an error message when running it or because it just doesn't perform the required actions?