Move Rows Containing Specific Word

raindrop
Lounger
Posts: 36
Joined: 04 Feb 2013, 06:22

Move Rows Containing Specific Word

Post by raindrop »

Hi !

I want to move all rows automatically to "Closed" sheet when approached word found in column F in worksheets named First, Second and Third. Is it Possible when approached word deleted in "Closed" sheet then those rows automatically move in related origin sheet. Please have a look at my attached sheet.

Thanks & Regards
Raindrop
You do not have the required permissions to view the files attached to this post.

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Move Rows Containing Specific Word

Post by Rudi »

Hi Raindrop,

The record can be moved to the Closed Sheet easily, but based on your second requirement, if you delete the approached word on the Closed sheet, the code will not know which original sheet the record came from...unless we add a column that identifies the original sheet name. Can we do that?
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

raindrop
Lounger
Posts: 36
Joined: 04 Feb 2013, 06:22

Re: Move Rows Containing Specific Word

Post by raindrop »

Hi Rudy Sir,

There is no problem with additional column to identify origin sheet.

Thanks & Regards
Raindrop

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Move Rows Containing Specific Word

Post by HansV »

See the attached version. I created Worksheet_Change event procedures for the sheets.
R2.xlsm
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

raindrop
Lounger
Posts: 36
Joined: 04 Feb 2013, 06:22

Re: Move Rows Containing Specific Word

Post by raindrop »

Hi HansV Sir,

Thank You for kind help. It works well and problem is solved.

Thanks & Regards
Raindrop

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Move Rows Containing Specific Word

Post by Rudi »

HansV wrote:See the attached version. I created Worksheet_Change event procedures for the sheets.
R2.xlsm
Thanks...
I had to go out for the morning.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.