I have an excel worksheet that is 341 columns by approx 50,000 rows. In
column A each row is given an identifying letter of A-E based on the
information contained within that row. The other 340 colums contain various
further information. I want to be able to extract either the entire or
ideally columns 2, 35, 37 and 269 in to a seperate workbook where column 1 is
equal to D and column 37 is within a specied date period (37 contains date
claim processed).

I've had a few goes at doing this but unfortunately i'm by no means an excel
expert and the only way i can get it to work is by using very basic IF/AND
statements and pulling through the claims that meet the criteria and ignoring
the ones that don't, unfortunately this means i'm left with thousands of
blank rows and have tried to copy and paste a code on another thread that
would remove these automatically and this works fine on a cut down version
(say a few hundred rows) but when ran against the entire workbook of 50,000
takes a long time to compelte and i'm sure there must we a way of just
extracting the information i want without the blank rows.

Many Thanks
Nathan