Excel macro; Cutting specific rows and pasting into another work sheet

[adamrace]

Hi,

I have a very large spreadsheet (up to the maximum 65000) I am facing the task of manually looking through, cutting and pasting any rows which have an N/A in the L column, (these are about every 15 rows, but are sporadic) therefore it's a massive task that i feel could be sorted quickly with the aid of a macro. I have created a few macro's before but am struggling even where to start, i know it needs if statements but i am more used to visual basic than VBA sorta thing. Any help would be muchly appreciated.

Cheers

 

[PHV]

You may use the macrorecorder while you manually autofilter the L column for N/A and do the cut'n'paste.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[adamrace]

Yea cheers, i have just had a go with the auto filter and sorted it out, most of it anyway, cheers