Deleting rows with macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

complex sort search and replace macro 2
Deleting Rows based on a Value 1
Match and delete rows on two different sheets from reference numbers 4
Need Help Deleting Blank Rows 3
Deleting rows (with zeros) with a macro 7
Moving Rowes based on Date value with a macro 7
Macro to delete row 13
Macro for deleting rows and serialising the remaing rows 1

Back
Top