Macro Nightmare (for me anyway!!!)

jsb1976 · #1 10-14-2008, 07:16 AM

I have a worksheet that I've been struggling with the past couple of days...

As an example, I've detailed the following:
Forename, Pet Type, Pet1, Pet2, Pet3, etc
John, Dog, , , ,
John, Cat, , , ,
Karen, Rabbit, , , ,
Bob, Horse, , , ,
Bob, Pony, , , ,
Mark, Dog, , , ,
Mark, Dog, , , ,
Mark, Bird, , , ,

What I want to be able to do is run down column A to find the forename and then populate the "Pet1", "Pet2", "Pet3" (etc - max of 10) with the relevant values from Column B and then delete the duplicate row (after the "original") to show a single row for each forename.

Example Wanted Result:
Forename, Pet Type, Pet1, Pet2, Pet3, etc
John, Dog, Cat, , ,
Karen, Rabbit, , , ,
Bob, Horse, Pony, , ,
Mark, Dog, Dog, Bird, ,

Please, can anyone help?

**royUK** · #2 10-14-2008, 11:23 AM

antoka05

Please do not answer questions until the OP has dealt with the reason that they have received the Infraction warning

**arthurbr** · #3 10-14-2008, 12:01 PM

xld
Please do not answer questions until the OP has dealt with the reason that they have received the Infraction warning

xld · #4 10-14-2008, 12:03 PM

Time to give me an infraction mate, this is as silly as OzGrid got, not allowing people to help when a guy asks a question.

**royUK** · #5 10-14-2008, 12:08 PM

Quote:

Originally Posted by xld

Time to give me an infraction mate, this is as silly as OzGrid got, not allowing people to help when a guy asks a question.

We are trying to keep the Forum orderly, you are welcome to stick to ozgrid but I suspect you would have been banned there. We have no intention of getting as heavy handed as DH but we do expect members to follow our rules.

xld · #6 10-14-2008, 12:12 PM

No Roy I haven't been banned there, unlike you. But I do think the propensity to smack our bottoms and ban us is petty and childish. I understand you have to have rules, but it can be taken too far. You experienced that at Ozgrid, and this forum seems overly heavy-handed.

**royUK** · #7 10-14-2008, 12:17 PM

I was banned for disagreeing with Dave about his heavy handed treatment of members. I didn't say you were banned, I said I think DH would have banned you for your actions here if it was Oz. The rules are there and have been put together after much discussion between the Moderators.

shg · #8 10-14-2008, 12:21 PM

Quote:

I understand you have to have rules, but it can be taken too far.

We actively discuss among ourselves what consititutes reasonable enforcement, and think we have it about right. The wonderful thing is that you are free to choose a forum that suits your own interpretation, from monarchy to anarchy.

xld · #9 10-14-2008, 12:22 PM

I know exactly why you were banned Roy, and it was ridiculous (what sort of forum bans their own administrators?). And you are probably right, Dave would ban me if OzGrid was actually active enough for me to spend any time there, he has threatened it a couple of times but never actually done it, but therein lies the rub. OzGrid is dying because of that attitude. I understand people should not be rude, be offensive, and might even concede that there are some things off-topic (MIGHT!), but what did this guy get one for, a poor subject? Who cares about the subject in reality, very few people search the archive, they repeat the question - that's a fact of life. That is how Dave started.

**royUK** · #10 10-14-2008, 12:30 PM

It boils down to the fact that the admin here want to keep a tidy but friendly approach. As a result we need rules & we expect everyone to follow them. As shg says it's your choice.

xld · #11 10-14-2008, 12:33 PM

But you should all remember that you are supposed to be doing it for the benefit of the community, not so that you can all feel good and powerful. I hope you guys all treat your kids a bit more like grown-ups.

I think I have made my views clear so I will sign off, pity the poor OP lost his answer for what was a reasonable request.

VBA Noob · #12 10-14-2008, 01:13 PM

Quote:

Originally Posted by xld

I think I have made my views clear so I will sign off, pity the poor OP lost his answer for what was a reasonable request.

xld,

FYI

The answer has being soft deleted and will be restored once jsb1976 contacts a mod.

VBA Noob

**royUK** · #13 10-15-2008, 10:02 AM

Quote:

Originally Posted by VBA Noob

xld,

FYI

The answer has being soft deleted and will be restored once jsb1976 contacts a mod.

VBA Noob

Which he obviously cannot be bothered to do.

ge0rge · #14 10-16-2008, 09:03 AM

I would like to suggest something. Here we have a poor thread title, an abandoned thread (sort of), meaning if they really wanted the help they would keep a constant eye on it, and a bit of opinions on the handling of it. Why don't the forum have an area where they move such posts and that only the mods and op can access it. Once the infraction has been dealt with, the mods could restore it back with changes included. Just a suggestion...

I am glad this forum did not follow the ozgrid road. I would have to believe his forum is going to slowly decline and this one pick up, thus the need for fair but stern rules.

**royUK** · #15 10-16-2008, 09:07 AM

Hi George

I don't think we can set up such a Forum, it would not be possible to limit access to the OP & mods only.

The Infractions system is just a way to help us maintain the Forum and make it an easy and useful Excel resource. We do not want to get heavy handed

Welcome to the Excel Forum

Forum Statistics