Deleting rows with macro

  • Thread starter PhilScratchingmyhead
  • Start date
P

PhilScratchingmyhead

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
 
G

Gord Dibben

If this is a one-time operation, use Data>Filter>Autofilter to hide the rows
less than 2000.

Copy the visible rows and paste to row 14 of the other sheet.

Go back and delete the visible rows from sheet1.

If to be done repeatedly, record a macro whilst you go through the steps.


Gord Dibben MS Excel MVP
 
C

CLR

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
 
Top