Insert a new row with data from previous row

G

Guest

I have a sheet that looks like this:

name number preference1 preference2 preference3
me 123 X X
you 246 X X
other 789 X

What I need to do, is:

1. Change the X to the header name which I think I can do with IF
2. For each additional X for that name, create a new row that has the name,
number and only that preference listed but in the same column it's in.
 
G

Guest

Hi Lynn,

If you know macro. Try this below. Hope this is what you are looking for.

Sub Macro()
'Select the row you want to shift and copy
Selection.Select
Selection.Copy
Selection.Insert Shift:=xlDown
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top