I am working on a project, and there will be MANY times that there will be multiple requests. This column is a dropdown with 2 options, "Yes" or "No". If the response is "Yes" I would like the data from that row, all columns PRIOR to that column copied to the next row. If the dropdown selection is "No" nothing is done. This would NOT be indented as a child, it would be identical in every way. I reviewed automation, and could only find information copying to another sheet. This must be a part of the same sheet. This column on the RIGHT that I have circled would indicate if the row would get copied to the next row, and it would be that whole role from the left aft the number to the last column BEFORE Multiple request. Which could be Yes again (then it would be auto-copied), or it could be No.