What im trying to do is take a list that is populated vertically and display it in another worksheet horizontally but in a
certain range. Ive made an example here. I want to be able to copy the names and information of people with information
(skip names w/o info) and paste there info the first one in G2:I2, next J2:L2, and the last in M2:O2 by pushing a macro
button. The outer limits of the range it must fall between then is G2:O2, there are 3 spots and there will never be more
than 3 names with information out of a larger group. It would then work to where if you had another list of names you could
push the button again and the next info would fall in the row below the previous ones. There are also blank rows between the
names which cannot be removed.
For example, first button push the 3 names and info go to G2:I2, J2:L2, M2:O2, push
it again this time theres only two names with info and they go to G3:I3, J3:L3, next time you push it you might have three
again and they go to G4:I4, J4:L4, M4:O4...you get the picture...has to fall in the range and there is writing on the left
and right side of the range so you cant do last filled cell in row to keep placing them to the right.
i dont know
how to get started except that need the next available cell in column G code like this to populate down
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
any help would be greatly appreaciated in helping me start the code for this