Find text and copy into new column (excelvba) [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,
Please help me, can anyone of you tell me how to find a text in excel for example "channel1" then find "channel2" and then "channel3".all the text are written in the same column "column A". then cut and paste all the other text in range between text "channel2" and "channel3" into a new column "column B".

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hello

A suggestion
conditional format with several colours and check manually

or you can put this formula in cell B2
=IF(A2="channel1",1,IF(AND(B1=1,A2="channel2"),2,IF(AND(B1=2,A2="channel3"),3,0)))
and filter for number three to check the occurance of channel 1,2,3 in order
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4198 users have said thank you to us this month