copy a row of info to another worksheet based on a pull down menu

**jrlafrance** · 08-01-2012, 01:38 PM

I'm trying to copy info from sheet "Perstat" to sheet "Status Change" only if the info on sheet "Perstat", column "H" is:

AWOL
CONFINEMENT
CON LEAVE
HOSPITAL / QUARTERS
ORDINARY LEAVE
PTDY
SPECIAL DUTY
TDY
LOCAL SCHOOL/OTHER
PASS / OFF
IN/OUT PROCESSING

And the info that I need copied is in columns "B", "C", "D", "E", "F" and "G".

Any help would be greatly appreciated, thanks in advance!

James

**xladept** · 08-01-2012, 07:08 PM

Hi jrlafrance,

Try this:

Please Login or Register  to view this content.

**jrlafrance** · 08-02-2012, 05:05 PM

figured it out.

**xladept** · 08-02-2012, 06:24 PM

Great - but did you try my code?

**Cutter** · 08-02-2012, 07:37 PM

@ jrlafrance

Based on your last post it seems that you have found a solution to your problem but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

BTW - the polite thing to do (and rule #6 requires it) would be to acknowledge the help you were given (even if you didn't use it) and to show the solution you used so that it may benefit others who come across this thread.

**jrlafrance** · 08-02-2012, 08:53 PM

Yes, the solution did work, but I still wanted to put it through a few tests. I hadn't marked it as "solved" for that exact reason. My appologies for not being quick enough.

Thanks to xladept for the solution!