Copy + Paste rws from multiple wrkshts that contain a specific value into new wrksht

    Hello All,


    I have a workbook with multiple sheets. I'm trying to create a macro that


    1. Goes into 4 specific sheets (I'll call them A, B, C, D)
    2. Searches column "C" for a specific date
    3. copies the entire row for which the specific date is present
    4. Paste those rows into another worksheet (called "Output") - the first row of the "output" has headers so I would ideally want the data to be pasted from row 2 on down.



    Thanks!

    Re: Copy + Paste rws from multiple wrkshts that contain a specific value into new wrk


    It's always better if you make a sample sheet and upload it, then we don't have to.


    Be sure to include some sample data so we don't have to recreate that either.


    When you click reply there will be a new button labeled go advanced, click on that button then there will be a paperclip icon in the toolbar, click on that icon and follow the instructions.

    Bruce :cool:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login