VBA Loop Code Help

Hi,

I need a simple bit of VBA Code that can help me loop through a large table quickly.

I have a large table with loads of data what i want it to do is basically apply a filter on Column B for any row that contains a certain name (note this name is not the only aspect of the field it is formatted "Day Time / Person") then for all these values select only columns B,C, and CH and then spit to output into another sheet in the workbook.

I've got something but it really isn't elegant ... and am guessing this can be done with a simple loop function.

Any Help???

Cheers,

Maybe:

Please Login or Register  to view this content.

Workbook attached

Hi,

Copied into the process data sheet column A - C for Bullied, D - F for Maunsell, G - I for Stroudley, and J - L for Wainwright as these populate graphs

cheers

This is excellent Thanks!!