Excel macro to delete column

[omkark2]

Hi,

I have certain number of columns with names starting from A, B, C ... to Z. Through an external program, I get a comma separated list of column names as "A,B,E,G". Now my task is to delete all the columns from A to Z except for the once occurring in the list i.e., A,B,E,G, in this case. How can I do this?

Thanks for the help in advance.

Regards,
Omkar.

[naveenmarapaka]

Hi ... Welcome....
Can you post your data... it would be easy to provide you solution...

Click Go advanced and click on paper clip icon and browse and upload the file.....

[omkark2]

Hi naveenmarapaka,

Please find the attached herewith the file. The columns are "A, B, C, D, E, F, G, H, I, J". Here in cell "N1" of the sheet I have a list "A,B,E,I". Now I have to delete all the columns of the given table except "A,B,E,I". Thus the columns to be deleted will be "C,D,F,G,H,J".
Please let me know if you need any further information.
Thanks!

Regards,
Omkar.

[jaslake]

Hi Omkar

Welcome to the Forum!!!

Will there always be only 10 Columns of Data?

[PCI]

You information concerning columns to keep is in column "N" and you want to search the columns to delete from A to Z ...?

[jaslake]

Hi Omkar

This Code in the attached appears to work as expected on your Sample File. I believe you'll need to address PCI's question regarding your Live File.

Please Login or Register  to view this content.

[naveenmarapaka]

Try this as well...

Please Login or Register  to view this content.

[omkark2]

Thanks naveenmarapaka, jaslake, PCI for spending time on my doubt.

This is working fine now. You guys rock

Thanks once again !!!

[omkark2]

Thanks naveenmarapaka, jaslake, PCI for spending time on my doubt.
This is working fine. You guys rock.

Thanks once again !!!

[jaslake]

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

If this resolves your issue please mark your Thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[omkark2]

Oops Sorry but this did not solve my problem. I checked it today. So it is keeping the Excel columns mentioned in cell "N1" of the sheet and deleting the remaining columns. However, I want the columns headers specified in the table to deleted. Like if the cell "N1" has "A,E,B,I" and want to delete all other columns except these from MY table and not the column names specified by Excel. For better understanding, I am uploading a new file. Here I want only Name and Phone to be the final columns. Please refer the "Desired Output" sheet in the file to know the exact requirement.

[jaslake]

Hi Omkar

Your explanation is a bit confusing but this Code in the attached achieves your described Desired Output in your Sample File. Ctrl + x will fire the Code.

Please Login or Register  to view this content.