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
Move Rows Containing Specific Word
-
- Lounger
- Posts: 36
- Joined: 04 Feb 2013, 06:22
Move Rows Containing Specific Word
You do not have the required permissions to view the files attached to this post.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Move Rows Containing Specific Word
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?
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.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Lounger
- Posts: 36
- Joined: 04 Feb 2013, 06:22
Re: Move Rows Containing Specific Word
Hi Rudy Sir,
There is no problem with additional column to identify origin sheet.
Thanks & Regards
Raindrop
There is no problem with additional column to identify origin sheet.
Thanks & Regards
Raindrop
-
- Administrator
- Posts: 78585
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Move Rows Containing Specific Word
See the attached version. I created Worksheet_Change event procedures for the sheets.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- Lounger
- Posts: 36
- Joined: 04 Feb 2013, 06:22
Re: Move Rows Containing Specific Word
Hi HansV Sir,
Thank You for kind help. It works well and problem is solved.
Thanks & Regards
Raindrop
Thank You for kind help. It works well and problem is solved.
Thanks & Regards
Raindrop
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Move Rows Containing Specific Word
Thanks...HansV wrote:See the attached version. I created Worksheet_Change event procedures for the sheets.
I had to go out for the morning.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.