Macro to identify specific rows in many sheets and consolidate onto one sheet

Hello -

I am needing help with creating a macro that will take the information identified ONLY in columns A - W on selected rows throughout the attached workbook, and copy itself onto the sheet labeled "Appeals" (Columns A-W are the only columns that are consistent throughout each sheet, columns after W are customized to each sheet). My goal is to have those that have a "Y" for "yes" placed in column "A - Appealed" automatically copy itself to the "Appeals" tab.

I am not good with macros and will need a lot of help with this - I am proficient with everything else in Excel. Please let me know if I need to elaborate further.

Thanks so much!!!

Master Mailing Forum Help.zip

Maybe:

Please Login or Register  to view this content.

AB33 - Thank you for your help but not quite what I was going for. I am needing the rows that have a "Y" in column A to appear on the "Appeals" sheet - all other individuals should not be present unless marked with a "Y".

Thank you so much for your help on this though!

John H. Davis - Thank you, that works perfectly.

Quick question (due to lack of experience) - Will I need to run the macro each time I update the information, or will it automatically update once I enter a "y" into column "A" ?

Unfortunately you would have to run it each time.

For fear that a person may need to take over this file and is not familiar with Macro's in any way (we're talking not even knowing how to enter a code) - is there a way to automate this? This will be a huge file with many rows of data and the more we can simplify for others, the better. If it is not possible, not a problem.

Thanks so much!