Find Data, Delete It And The Adjacet Cell
Oct 13, 2006
I have the code below. and it works to delete the variable in DelWC which is selected by a combobox. Combobox is populated by Column R info, You select the data, and then hit the delete key, it deletes what it found, great.. but I need it to delete addition info that is in the next row adjacent to it...
Column R Column S
AINA2 X-5900
AENE2 X-5874
The code finds and delets the AENE2 but doesn't delete the X-5874
With Worksheets("Data"). Range("R:S")
On Error Resume Next
Set Del = .Find(DelWC)
If Del = Del Then
Del.Delete Shift:=xlShiftUp
View 2 Replies
ADVERTISEMENT
Mar 29, 2012
I found a lot of information on this but not what I need. I have 8 columns A - H. Column D has some duplicate numbers. I would like to find the duplicate numbers in column D (they are all one right after the other) and delete the entire row leaving only the first. I do not need to sum or anything, just delete the row with a duplicate number. If there are 2 or 3, I just end up with one.
View 2 Replies
View Related
May 25, 2006
compare and find exact matches b/w the data in columns J and K in the attached csv file. I would simply like all rows with exact matches to be hidden. I can simply change any code to reflect something like
Selection.EntireRow.delete
later if necessary.
View 3 Replies
View Related
Jan 5, 2010
I have a large report that I pull each month listing which products we sold last month. There are certain products I don't want included in the report. Until I can have the report re-written, I'm looking for a macro or a function that will find all the rows that contain these product numbers in column M and delete the entire row. The product numbers I need to delete are always the same, but some months one or more of them might not be in the report if they weren't sold.
In Summary:
Find in column M the product numbers:
c1000
316140a
316140
316295a
316295
316311a
316311
316451a
316451
316450a
316450
316452a
316452
Delete those rows containing the product numbers above
View 6 Replies
View Related
Feb 28, 2014
create a VBA to delete rows if the cell doesn't have "Other".
The data is in Column C which consist of the below data so I like VBA to delete the rows when the cell doesn't have "Other"..
-Primary
-Business
-Home
-(blank)
-Other
View 5 Replies
View Related
Mar 14, 2008
I'm trying to come up with a formula to find the last row without any data in columns E and F and delete the 10 rows below them. Is there a way to do this?
View 3 Replies
View Related
Aug 1, 2014
I'm looking to search column A on a worksheet, find a specific value and then delete the entire row that value shows up in. This is what I have so far...
[Code] ......
View 1 Replies
View Related
Aug 20, 2013
I need a Macro that will search all of the cells for specific text, and delete all cells containing the text. I prefer to make a list of the specific texts and run macro to find all of them and delete all cells containing the text. I need to be able to add some more text into the list in future.
View 9 Replies
View Related
Apr 24, 2009
In the code below I find rows containing "$$ #" at the far left and process it.
For all the remaining rows I want to delete the entire row, my macro only deletes some rows. Obviously I am not grasping something about looping throught the rows to delete unwanted data.
View 2 Replies
View Related
Apr 23, 2008
I have a huge database. I am looking for a macro that can search for a particular word. If a match is found, the macro should do two things simultaneously... (i) delete the contents of the cell in which the match is found........(ii) display the same contents 1 row below and 1 coloumn to the left of this cell where the match is found. For e.g....
View 9 Replies
View Related
Mar 26, 2014
I have a a very large time series spreadsheet with many observed values of many variables. For each variable, I want to find and delete the first observation. It looks something like this
A * (x)
A *
A *
B * (x)
B *
B *
C * (x)
C *
C *
Each letter is one variable and each * is an observation. The (x) indicate the value I want to find and delete the entire row.
View 8 Replies
View Related
Dec 28, 2013
I'm looking for code to find a copy of the text in cell AH3 in a range AH7:AH100 then delete all copies of the text in that range AH7:AH100 leaving other cells in that range which contain different text intact.
View 3 Replies
View Related
Jan 25, 2008
My code is always failing on the findnext method. I'm thinking that the findnext method fails because it loses it's cell reference when the row gets deleted.
Sub findwbs()
Dim rngFind As Range
Dim strFirstAddress As String
View 9 Replies
View Related
Jun 6, 2014
I have multiple tables like the one in the picture and have to duplicate this code for different known ranges.
View 11 Replies
View Related
Mar 28, 2014
I need to find the data in the sheet SKU & match it to the data in import_215 column F if it matches then delete the entire row (see Attachment SKU3)
View 12 Replies
View Related
Aug 17, 2009
I want find the data in some rows that same with one or more cell and automatically fill the data. And for more details, I have attached the examp file (Examp.xls).Antoni
View 3 Replies
View Related
Aug 2, 2014
I have large worksheet with data. Have data in the range L121:ED490.
I need to VB macro to check cells in column L,P,T,(every 4th column) until row 490 column ED and see if the cell is blank. If any cell in column L,P,T, and so on until column ED is blank then i need to make corresponding cell in column N,R, V and so on blank. Example : If L151 is blank then need to make N151 blank. If T152 is blank the need to make V152 blank.
View 3 Replies
View Related
Jul 27, 2007
I need a quick macro that will search column D for the words "balance forward" then delete the entire row. The macro needs to loop through many rows and it contain more than one "balance forward" reference.
View 9 Replies
View Related
Feb 21, 2008
The 1st set is in a column. Nice & tidy all twelve characters in length & alpanumeric
zx0123123123
zz0123123124
zy0123123129
The second set is a mess, taken from a lotus notes inbox from the subject line off an email, eg. there Blah blah zz0123123124 etc etc. What I want to do is do a reconcilliation between the two with a lookup, but have no idea which route to go down to get round the messy data. I have been using =IF(ISNA(MATCH(A1,'[spreadsheet to lookup to.xls]sheet1'!$A:$A,0))," No match"," Match")
but here the data is clean. I have searched teh forum ;o) DaveH & found something about > Instr() but this can't be used in formulas..
View 5 Replies
View Related
Aug 11, 2013
One more thing and I think I completed my project. I have a tab called comments.
Column A and B will always have data in them from 1-320.
Column C may or may not have data in it from 1-320.
Is there a code I could tie a button with that will delete the cells A and B if C has no data but leave it alone if C has data?
Ex: [URL] ........
When I click sort, only A1, B1, C1 and A5, B5 and C5 will still be there and everything else deleted.
View 5 Replies
View Related
Jun 19, 2009
I need a VBA that i will attach to a button that will delete spisific data in the cell.
Eg... delete all the cell CONTENT in column A1:A65536 with the word "NONE" in them, it must only delete the word not the cell.
View 9 Replies
View Related
Dec 30, 2013
I have a column with unique identifiers (numeric) that are included in another column. I need to find this number in the column and pull the data from that column into a new one. For example:
Unique Identifier: 28530
Is included in this string: 10.1.8........28530_201_10-....
I need the content from the string pulled into a new column. It seems there would be a LOOKUP that would work, but I'm not able to figure it out.
View 3 Replies
View Related
Aug 19, 2014
I need cell A1 data deleted once the date in B1 has passed.
View 7 Replies
View Related
Dec 12, 2012
I want to extract the following details into another collumn (bold ) from data in column B1 into C1. The information i want begins with 3 digits with a '/' then other digits follow.
M / AS308 - :308/65588 POUN
S33 / 33 - :133/01504 TR
NI101 - :101/915635 T
N101 - :101/915635
View 4 Replies
View Related
May 28, 2013
I have a sheet with 12 months in it, each in a column. As month's go on, I put the cumulative sales figures (YTD sales) in the given month. What I'm trying to figure out is how in the 13th column (i.e. the one after december), can I have it show the value of the most recent cumulative sales (i.e. if we are in May, there will be sales data for jan, feb, mar, and april and I want column 13 to show the value of April since it will be the month that last has data.
View 4 Replies
View Related
Apr 23, 2014
Basically I need a formula that work as below. It's over two sheets and is probably very easy to most of you I just cant get my head round this one!!
If B1 (sheet 1) = "TEXT1" ,FIND the content I1 (sheet 1) within a1:a3000 (sheet 2). If I1 is found in that range i need to know the text in the cell next to the found text.
E.g.: the text of I1 (sheet 1) was found in cell a234 (sheet 2) so it gives me the text in b234.
View 9 Replies
View Related
Aug 17, 2006
I have a worksheet that projects data into the future. Say 5 rows with each column containing a projection. In the last column (say 10) I want a formula that detects the cell to the left that first contains data and returns that data.
Each row will have data in different columns.
View 9 Replies
View Related
Feb 25, 2009
I have a spreadsheet that I have been entering and deleting data from. Currently there is data in A1:J1 only, however, when I Ctrl+End my cell focus is on J242. I have deleted rows 2 through 300 and cleared all from the Edit menu on cells A2:J242, both to no avail. How do I clear this so that if I Ctrl+End it goes only to J1?
View 2 Replies
View Related
Dec 12, 2006
i can use the VLOOKUP function to find entire cell in one table and paste the required data from the row....
Is there a function to search part of data and paste the required data
View 9 Replies
View Related
Feb 10, 2009
I am looking for a macro to do the below
copy range b2:b8 from sheet 2
find the first empty cell on sheet 1 row 2
paste values into there
View 9 Replies
View Related