View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default Deleting rows with macro

Data filter AutoFilter Custom GreaterThan......

Will get the rows you want filtered out, then just copy and paste
them.........

Data Filter AutoFilter again will return your data to normal........


Vaya con Dios,
Chuck, CABGx3



"PhilScratchingmyhead" wrote:

Hi,

I need to cut rows which have a value over £2000 in a specific column of my
spreadsheet e.g. col AB and paste into another sheet after row 14 as I have
other data in rows 1-13inc.

I'm thinking macro but I'm rubbish!!

Any help would be appreciated.

Regards
P.x