Copy rows from one sheet to another,while deleting from source,under condition

**piulibero** · 12-12-2011, 06:15 AM

Hi, i am newbie in excel and i need help on this.
I have a task manager where each row corerspond to jobs that have to be done. there is a row where status is displayed. I want your help in a macro where when the status of tasks is set to "Completed" the row to be copied in another sheet and be deleted from the current. Greatfull for a solution.I need to avoid however Autofilter.

Thanks

**tom1977** · 12-12-2011, 06:38 AM

put this code into sheet module

Please Login or Register  to view this content.

and fill e.g. cell B3 with "Completed"

**piulibero** · 12-13-2011, 11:30 AM

Hi Tom ,thank you for the reply.What i actually need is the below:
help.jpg

Thank you in advance,i really need this.

**tom1977** · 12-13-2011, 03:58 PM

Hi send the attachment as excel file not picture and I will change this for you

**piulibero** · 12-13-2011, 07:41 PM

help.xlsx

thank you so Much Tom for replying.
Here it is

**tom1977** · 12-14-2011, 03:50 AM

hi I've made this with event procedure

**piulibero** · 12-14-2011, 04:35 AM

Thank you so much Tom. Works exaclty as i need. Many thanks again

Copy rows from one sheet to another,while deleting from source,under condition

LinkBack

Thread Tools

Rate This Thread

Display

Copy rows from one sheet to another,while deleting from source,under condition

Re: Copy rows from one sheet to another,while deleting from source,under condition

Re: Copy rows from one sheet to another,while deleting from source,under condition

Re: Copy rows from one sheet to another,while deleting from source,under condition

Re: Copy rows from one sheet to another,while deleting from source,under condition

Re: Copy rows from one sheet to another,while deleting from source,under condition

Re: Copy rows from one sheet to another,while deleting from source,under condition

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions