Conditional Row Copy/Consolidate

Closed
Posts
3
Registration date
Friday July 14, 2017
Status
Member
Last seen
July 16, 2017
-
 Blocked Profile -
Hello,

I am working with a database that deals with student scheduling in schools. I am getting repeated lines for each class a student is enrolled in and need to consolidate them into 1 line per student. I prefer to do this by copying to a second sheet in the workbook so I have the master to go back to if needed.

The way the spreadsheet is set up, if the values in columns A & B (last name & first name) are the same from row to row, then I need the information in columns H-R to be repeated starting in column S for as many courses as the student is enrolled in. This number will vary for every student.

1 reply


Are you stuck on something, or just sharing with us? If you are stuck, then post some code, and we can help.

Take a look at this and see if any of it will assist you with what you are trying to achieve:
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba
Posts
3
Registration date
Friday July 14, 2017
Status
Member
Last seen
July 16, 2017

I am not a coder so have nothing to share for that. I saw other posts on this forum where people were supporting one another with Excel. I am wondering whether something like the Consolidate or a Macro would do what I need it to. I am happy to teach myself what I need to know but I don't even know which functions of Excel will do the above task.
Blocked Profile
Start with this idea: Record a MACRO doing what you want. Then edit the Macro, and see how you can change hard coded stuff into variables!