Delete the particular data in column based.

[sampath]

Hello All,

I have column wise data in excel sheet and every column has "Group-1*******".

Here I Need to delete this data and after data from "Group-1*******" in every column.

could you give any macros for this. because having more data.

Here with I have attached the samples for the same.

Regards,
Sampath.S

 

[deepak.gupta@logica.com]

Hi,
There is one way. You can apply Text Filter -> Custom Filter -> does not begins with, on the columns and use GROUP-1 as the keywords. Then just paste the filtered results to sheet 2.

cheers,
Deepak

 

[sampath]

Hi Deepak.

I need automated result using macro, Because using 2 more macro with this for single shot.

could you help for this.

Regards,
Sampath.S

 

[Somendra Misra]

Hi Sampath,

Assuming the cells to be deleted contains "-" the code will run.

Select the range and run the code. Modify as per your original file.

Regards,

 

[sampath]

Hi Misra,

When using this macro. output shows only numbers like A1 has 1, B1 has 2, and C1 has 3. i cannot get the expected output.

Kindly solve this clarification.

Regards,
Sampath.S

 

[Somendra Misra]

@sampath

Well it working on my end.

Select the entire data A3:C11 on input sheet & than run the code.

Regards,

 

[sampath]

Hi Misra,

Thanks for given this Macro. One clarification. some time that "GROUP" criteria will come in naming cell. that time how can we assuming "-".

Could you solve this. Herewith I have attached the same file.

Thank with regards,
Sampath