Copy row to another sheet and delete (based on cell content)

**mpower87** · 06-29-2010, 12:19 AM

Hi guys, I would like to find an alternative to my code which doesnt work properly at the moment.

Please Login or Register  to view this content.

I need an efficient code which will copy all the rows with "D" in cell in column L to another sheet (CompeletedOrders) and then delete the rows in Orders sheet.

Please assist with this, Cheers.

**pike** · 06-29-2010, 07:38 AM

hi mpower87
at a glance

Please Login or Register  to view this content.

or find syntax mabe be a better option

**mpower87** · 06-29-2010, 10:25 PM

hi pike,

thanks for your reply. can you please explain what you mean there? and i tried that code but it doesnt work...

**pike** · 06-30-2010, 04:13 AM

Hi mpower87,
try..

Please Login or Register  to view this content.

**mpower87** · 07-01-2010, 01:56 AM

hi mate, thanks for that, i tried it as:

Please Login or Register  to view this content.

Unfortunately this resulted in an error:

Run-time error '1004':

Copy method of Range class failed

**mpower87** · 07-02-2010, 12:22 AM

no one else can have a crack at this?

**pike** · 07-02-2010, 03:03 AM

dude can you attach a sample workbook to play with

**pike** · 07-02-2010, 03:05 AM

change this bit

Please Login or Register  to view this content.

**pike** · 07-02-2010, 03:18 AM

or

Please Login or Register  to view this content.

**snb** · 07-02-2010, 04:26 AM

Please Login or Register  to view this content.

**mpower87** · 07-04-2010, 07:56 PM

hi guys, thanks for you for your replies. unfortunately i can't get your code to work

attached is a dummy file that may assist you with helping me. i appreciate your time. cheers.

**pike** · 07-05-2010, 02:55 AM

mpower87, matie, mate, maaaaate

You FORGOT to mention the worksheet change event!!!!!!

Please Login or Register  to view this content.

**mpower87** · 07-05-2010, 06:43 PM

hah, well I'm still a noob when it comes to vba. thanks for pointing that out and making a working piece of code pike. much appreciated. kudos to you mate

**pike** · 07-05-2010, 07:42 PM

Hey mpower87

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Copy row to another sheet and delete (based on cell content)

LinkBack

Thread Tools

Rate This Thread

Display

Copy row to another sheet and delete (based on cell content)

Re: Copy row to another sheet and delete (based on cell content)

Re: Copy row to another sheet and delete (based on cell content)

Re: Copy row to another sheet and delete (based on cell content)

Re: Copy row to another sheet and delete (based on cell content)

Re: Copy row to another sheet and delete (based on cell content)

Re: Copy row to another sheet and delete (based on cell content)

Re: Copy row to another sheet and delete (based on cell content)

Re: Copy row to another sheet and delete (based on cell content)

Re: Copy row to another sheet and delete (based on cell content)

Re: Copy row to another sheet and delete (based on cell content)

Re: Copy row to another sheet and delete (based on cell content)

Re: Copy row to another sheet and delete (based on cell content)

Re: Copy row to another sheet and delete (based on cell content)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions