Find text and copy into new column (excelvba)

Closed

amzary - Oct 19, 2009 at 09:53 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 21, 2009 at 07:01 AM

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".

Find text and copy into new column (excelvba)
How to delete column in word - Guide
Tweetdeck remove column - Guide
Excel vba find last non empty cell in column - Guide
Excel count occurrences of string in column - Guide
Excel copy column from one sheet to another automatically - Guide

1 response

Answer 1 / 1

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Oct 21, 2009 at 07:01 AM

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

Similar discussions

VBA find column by name and sort

Auto generate serial number in excel based on Column

Excel Macro/Code help: Creating sheet for each name in column of another sheet

Converting rows of data in notepad to columns

Copy range data in a column to new column.

Similar discussions

Subscribe To Our Newsletter!