delete column

am trying to delete few columns in a pattern. the pattern is a set of 9 columns; first set is from column Q:Y and my data range spreads till column BVI. I want to keep the first two columns with column with 15 and delete the next 7 columns from each set. I have tried the following, but it is...

Hello, I have a formula in cell a1 of a sheet which results in a number between 6 and 28 Based on this value, is it possible to create a vba that would select this column and those beyond it, i.e. if it said 8, it would select columns H : XFD and delete the columns? Appreciate any help, VMT.

Hi, I am looking for a code that will help with what I want to achieve. I have a table where I have to split a column using text-to-columns. The number of columns created after will vary time to time. What I now want to do is copy the rows to a certain column and then for each of the columns...

Hi, Over the last week I've been teaching myself to develop very simple macros with goals of becoming a master one day. My questions in red are: 1. can anyone recommend beginner tutorial sites similar to this one that I've been using https://www.homeandlearn.org/index.html? 2. Ultimately, I...

Hello, I had a working macro but today it started giving me an error. When formatting the data, it is deleting 2 columns when it is to be deleting 1. I am not sure why it is doing this. Any tips or suggestions would be greatly appreciated. Below is the section of code where it is doing this...

I need help writing VBA Code that will work for a spreadsheet I am working on. I have tried the record macro process but I cannot get a date column I am working with the format correctly. This data is coming from a program and needs to be scrubbed so formulas can be written for it. In column...

Hello, I am currently working on a spreadsheet that looks somewhat like this: <tbody> Column A Column B Column C Column D Column E Column F Column G Column H Column I Item # Store 1 Units Store 1 Cases Store 2 Units Store 2 Cases Store 3 Units Store 3 Cases Total Units Total Cases 123 50...

I've got a large number of single column data entries that I'm trying to cull down to useful information. Currently, a test generates a single entry that records 13 rows of information. If no settings have been changed, the only difference between any two columns is the date and time. I'd like...

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