Macro Nightmare (for me anyway!!!)

**jsb1976** · 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** · 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** · 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** · 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** · 10-14-2008, 12:08 PM

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** · 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** · 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** · 10-14-2008, 12:21 PM

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** · 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-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** · 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** · 10-14-2008, 01:13 PM

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** · 10-15-2008, 10:02 AM

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** · 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** · 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

**ge0rge** · 10-16-2008, 09:20 AM

I kinda figured that. Thanks for the reply.

**Rick_Stanich** · 10-16-2008, 09:46 AM

:popcorn:
Whens the next episode?

**royUK** · 10-16-2008, 09:55 AM

Moved to Comments Forum, the original question is no longer relevant as the OP has not bothered to return & amend the question

**Stuie** · 10-16-2008, 09:56 AM

Lol,

i think we have all learned a valuable lesson about infractions today

**Simon Lloyd** · 10-20-2008, 04:00 PM

I have just been reading through this thread, while some people may find it offensive to see a red post and know that the OP hasn't bothered to read the forum rules (Rule 1 with regards to informative titles), but the truth is that it is an infraction, a warning, it's nothing more than that, its the red post colour that makes it seem all that much more worse, using this method allows the user to make changes and still have his post active and then consequently answered, prior to us using this system the op's post would be locked....no chance of it ever being answered.

I agree there is a flaw with the system which i'm working on and that is when an op has made the changes the red backround is removed....but its a little while coming.

It really isn't meant to be offensive in any way, before devising and generally agreeing on rules and how we deal with them the forum was unkempt, unruly and no where near as popular as it is now, since making these changes (April) we have picked up over 12,000 members.

We would ask that you are all patient with us while we work out the bugs and useages of our system, it's concept is sound, its useage is sound but there are some finer points that need a little work to make it just right.

The real point is, pay a little attention to how and what you post, your question will be answered quickly and everyone will be happy.