deleting columns

Hi All, Is there any method to remove multiple columns based on the header value apart from VBA ?? I have just use small example, however in real am dealing with more columns. Thanks in advance.

I have a worksheet with two tabs. The first tab I have 6 columns withe general number data in them for hours of work to perform the task at the 6 different levels which are the 6 columns. This is the basic set up for my template. Now I used this template fore each job and depending on which...

Hi All, I am cleaning up an file with dispersed formatting all over the place. I know the following procedure: 1. Saving file as .xlsb file 2. Deleting formatted columns 3. Saving and closing the file When exercising step 2 I encounter a problem. My file is large and calculation power is...

Hi, Please help me to create a button in Excel on which assign a macro with a condition that when I enter column name in cell and press the button then it automatically delete that column. Thanks in Advance. Muan

Hi, Hope someone can assist me, i have am new to the whole macro/formula experience and have spent 5 hours today trying different methods of trying to do this. I have to run reports every week and need to streamline how long it take me to do, so i want to delete out columns in excel that i do...

Dear All, I have a very large sheet with 250 columns. However some of these columns are empty. I need a script which can delete all empty columns. Can any one help? Regards Khawar

I am having trouble coming up with an algorithm for deleting columns, based on a certain set of criteria. Heres the issue, all the columns have a "1" the top of column . If that column has a cell number that's greater than or equal to 0.90 or less than or equal to -0.90 then that column gets...

I have a worksheet where columns A:D are merged. I want to delete columns B:D and this works perfect when I manually select column B and then C and finally D. I have recorded this, but the macro deletes all the 4 columns. I have also tried to unmerge the columns and this also works fine...

My First Macro-enabled Worksheet/VBA Project: I have a table with seven header rows, 500 data rows and 1 header column. There will be roughly 40 data columns, although that may vary slightly. The four header rows contain a year and various summary statistics for the data in the corresponding...