Search a Column for a specific Value and Place in Another sheet

[basketball2524]

Hello, I need help creating the following part of a macro. I have information that will be on sheet 1 in the following format:
Column A,Column B,Column C,Column D,Column E
File Number,Field Name,Changed From,Changed To, Modified By

I will have up to 14 sheets one for each person making a modification.
So Sheet 2 = John Doe
Sheet 3 = Jane Smith and so on....

On sheet 1 I would Like a Macro to start by searching Column E. For John Doe and if it comes along a John Doe it will then copy that row into the first empty row in column A on the sheet that corresponds with that name. So for John Smith it would be Sheet 2 and for Jane Smith it will copy to the first available row in Column A in Sheet 3. I have another step after this but this portion needs to be done before anything else and I'm just trying to get the basic of the macro started. Thanks for your help.

[trevor2524]

I hope you figure this out I'm trying something along the same nature and need help with that as well. Good Luck!

[GC Excel]

Hi basketball2524 and welcome to the forum,
If I understook correctly, this should work :

Please Login or Register  to view this content.