Previous Topic Next Topic

Cut-paste row to sheet2 if columnvalue is met

Solved/Closed
Trowa - Feb 22, 2010 at 08:54 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 25, 2010 at 08:48 AM
Hello,

I have got 2 sheets. Sheet1 contains a list of assignments, in which column B contains the status of those assignments. Sheet2 contains completed assignments.

Now I would like to check sheet1's column B for the word "Completed", when found, cut the entire row and paste it to sheet2.

Both sheet1 and sheet2 contains headers in the first row.

Could someone provide a VB code for this task?

Thanks in advance,
Trowa
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 22, 2010 at 10:08 AM
See this

https://ccm.net/forum/affich-258056-excel-2007-if-then-select-row-and-move-qu
0
Trowa
Feb 25, 2010 at 08:44 AM
Oke, thanks rizvisa1.

Not exactly what I was looking for, but it gave me an idea of how to write my own code.

So thanks for your reply, issue solved.

Best regards,
Trowa
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766 > Trowa
Feb 25, 2010 at 08:48 AM
Trowa
I think all you would have to change is sheet names and this line


Selection.AutoFilter Field:=19, Criteria1:="=" & 1, Operator:=xlAnd

to

Selection.AutoFilter Field:=2, Criteria1:="=Completed", Operator:=xlAnd
0

Similar discussions

Can no longer paste text into insta
6hypnone -
Richierichmeister -

6 responses
Cropping video in Daum PotPlayer
gogo60 -
ac3mark -

1 response
Instagram Live streaming limit only 1 hour, not 4 hours,why?
Insta_liveuser22 -
HelpiOS -

1 response
Root directory is full or errors during pasting
5468960 -
aryann9152 -

5 responses
How can I make my name text invisible in Discord
imbenmark -
imbenmark -

4 responses