Copying Cells Based on Drop Down Criteria

Hello,

I need to copy all of the cells that match criteria that are in a drop down. The drop down gives me a corresponding number which is in cell D1 on Sheet2. I then need all of the corresponding rows that have the corresponding number in row A that is in Cell D1, copied into Sheet2 below the drop down. I think I need to use the IF Then function and loop it, but I haven't been able to get it to work. Please see attached. Thanks.

Sorry. Here is the attachment.

Hey,

Try This. Hope its what your after.

Please Login or Register  to view this content.

Tom

Thanks for the help, but that isn't exactly what I am looking for. The issue that I have is that I don't know exactly how big the list of data will be, which is why I had to name the final row. Thanks though!

That Code should work no matter on how big the list gets. The only part that wont will be where I have cleard the cells which showed the previous selection.

All you will need to do will be somthing like is done with the Final Row to clear the contents of the previous selection.

Try Adapting it and it might work.

Thanks

Tom