Deleting rows with macro
 

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

Deleting rows with macro
 

If this is a one-time operation, use DataFilterAutofilter 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

On Thu, 29 Jun 2006 08:24:03 -0700, 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

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