Like I said, I no experience so I don't know what any of this stuff means, or where to input data which pertains to my spreadsheet specifically vs generic information that applies to all spreadsheets. The data in Red is highlighted in my VBA editor, so I'm assuming my error is there. If Range("A" & i).Value Cells(1, 2) Then Rows(i).Delete shift:=x1Up Range("A" & Rows.Count).End(x1Up).Row To 3 Step -1 So far here is what I have come up with in my research for the first step of this process:įor i =. I then want it to search for and delete duplicate values in Column E. When the cell in column A does not equal the value which was placed in cell B2, I want it to delete that entire Row. I want the macro behind that button to search every cell in column A which contains data and compare it to the value which was entered in cell B2. I want the user of this spreadsheet, specifically tab/worksheet titled "Download Data" to which the query is linked, to be able to enter a value in cell B2 and then click the "Run Query" button to filter the data. I have an excel sheet which pulls a bunch of data from an Access Query. I have ZERO experience with VBA, but am trying to make an idea come to life. I have been searching for hours for the answer to this question.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |