Looking to create a search box with option buttons that once pressed searches a different worksheet for the search box content, then with all rows where this is present, copy them onto a neighboring worksheet and remove a few of the irrelevant columns at the same time.
I have a borrowed VBA Code that will delete columns that = NR ( =IF((K1=0),"NR",(K2/K1)) )
problem is when the cells shift after deleting ==> the code seems to skip over other NR fields
I have attached the code and a small sample of the excel sheet
column range can be from H3 to many...
Hello, I have a unique situation where I need to delete the columns between two columns. The number of columns between these two will be different at various times... Column_B will always be the second column, but as columns are added in between, "Column_C" will push to the right
Here is my...
I have a spreadsheet with 72 rows and about 10,000 columns. I have applied conditional formatting to highlight all the cells which have a value of less than 150. Is there a way of now deleting all the columns where ALL the cells are highlighted/less than 150? At the moment I have the cells...
Hello Everyone! I need a macro keep deleting until the value is met!!! I have this code, but it stops after the first column is deleted instead of deleting the next new Column H until it = Today. How do I get it to Loop? Please, any help...
Hi. I regularly receive a spreadsheet that has several hundred columns and a similar number of rows. From column 'D' onwards, the only columns I'm interested in are ones that contain either string "Outstanding" or "Required". Can anyone suggest a macro that would delete all columns after 'D'...
I need to import a 256 column table using power query [every fortnight through ODBC]. There are at least 150 columns in the table are empty however there is no fixed criteria that which column would be empty. I order to refine the data i need to delete these empty columns.
I am looking for help with a code that will help automate some financial statements. It is a standard tool that has the first year and the last year as an input. Based on the last year of analysis needed, the VBA code would extend (drag) the formulas to the column needed.
Also, I built...
The worksheets I have, require deleting all columns shaded green on row 13. Up to and including column 150.
I have a spreadsheet with headers on row 13, and a few thousand rows of data thereafter. Variable number of columns, starting from 100 to several hundred depending.
I need the VBA to delete Column "F" as the very last step in the process. Since I am not familiar with VBA I am looking for help. It would be greatly appreciated if you could assist.
.ScreenUpdating = False...
I have macro now that copies 10 sheets from my workbook and puts them into their own .Xlsx workbook. Once that happens, I want to delete (or clear contents on) a range of columns (P through Z) in all 10 of those sheets (in the new .xlsx file I just made).
I must have tried 20 different...
I have searched thoroughly the forums on how to keep only columns whose header is the text "x","y" or "c".. and saw a common formula pasted below:
Option Compare Text
Public Sub DeleteColumns()
Dim iLastCol As Long
Dim iPtr As Long
iLastCol = Cells(1...
I am a complete noob at macros and have searched high and low for the answer to this question and would be eternally grateful to anyone who can help me out with this.
I have an exported CSV file that has many unneeded columns that need to be removed.
I also want to split a column so...
I have a worksheet_change event that I want to put in place but I am having problems ensuring that this event exits if columns A to E are accidentally deleted.
I had the same problem with my code if a row was inserted but I started the event with the following:
This is my first post so I hope someone can help me out. The VBA macro that I have written is essentially a glorified transpose function (the specifics shouldn't be important for my question). Midway through the code I need to delete a large range of cells so that a) the formatting...
Hi all again,
I am am wanting to delete the entire column if there are no entires below the heading in Row 1.
So in image below, Col C, E & G are to be delete including the heading.
Thanks again everyone
Can anyone give me a clue as to what I need to do to search for blank columns in a range and delete them? I can do this for blank rows, but am stuck on deleting blank columns.
Here is the code I have started for the blank rows, but am lost on the columns section.
For a = 1 To lastrow...
I have a table that has thin borders around all four sides of the cells in a column. My column is in the middle of the table and I have to delete the columns so that now this column is the last column in the table. After I delete the columns to the right I lose the borders on the right...