Search results for query: *

Hi, i need a macro to insert a blank line between rows that are different on column 2. Example Data... Col 1 Col 2 12345 A 12346 A 12234 A 34534 B 52323 C 23455 C 23455 C 23542 C Needs to look like Col 1 Col 2 12345 A 12346 A 12234 A 34534 B...

Hi, im almost there! have got it all working, just need to remove all rows out of Column B if the cell is empty, null or has a value of 0. here is my working code so far... Sub DeleteUnused() Dim myLastRow As Long Dim myLastCol As Long Dim wks As Worksheet Dim dummyRng As Range For Each...

Hi, i have got this bit to work Sub FindSpecChar() Dim X As Long 'For X = 1 To 65536 For X = 1 To 1000 'MsgBox "A" & X With Range("A" & X).Select If InStr(ActiveCell.Text, "/") <> 0 Then 'RunMyRecordedProcess...

Hi, i get a compile error end With without With message that pops up. How does it move the rows to the top? Kindest regards, Jim

I would like to do it within a macro that i can just run. Regards.

Hi, i have come up with this which adds some data to a new column, which i can then do a sort by. =IF(ISNUMBER(SEARCH("/",A2)),"Slash",IF(ISNUMBER(SEARCH("(",A2)),"Open Bracket",IF(ISNUMBER(SEARCH(" ",A2)),"Space",IF(ISNUMBER(SEARCH("-",A2)),"Hyphen","")))) Can this be put into a macro, then...

Hi, thanks for replying. I dont know how to do a sort on the data looking for a certain char. If you can tell me how to do this, i will try to record it as a macro. Many thanks, Jim

Hi, is there a macro to move rows to the top of a worksheet that have certain chars like dashes, perods, commas etc. and change the font colour to red? Many thanks, Jim

Hi, i have been playing with moving any infotmation in brackets to a new field but cant quite get it working for the entire column. It just moves everything. I just want the information in the brackets moved to a new column and leave the other information alone. Here is my code.. Sub...

Hi, this is not a typeo.. 0200109002/009/026/072/202 to 0200109009/026/072/202 Basically this is what will happen.. Original Value: 0200109002/009/026/072/202 After the macro has been run, the original cell will display all the values up to the "/" which will be 0200109002 The cell...

Hi, here is my original data example... Item Code QTY 0200109002/009/026/072/202 1 0200109074/012/014 23 200109047 22 0.20.0109262 (red) 21 0200147024 / 29 34 0200147029/040 4...

Thanks for replying. Never done this before. Will post some results so you can see what im after. many thanks, Jim

Hi, thanks - i have just done this. Hope someone will be able to help me figure this one out!! Many thanks, Jim

Hi, i have an excel document which can be 1000's of rows long with the following example values in it... Item Code QTY 0200109002/009/026/072/202 1 0200109074/012/014 23 200109047 22 0.20.0109262 (red) 21...

Hi, i have an excel document which can be 1000's of rows long with the following example values in it... Item Code QTY 0200109002/009/026/072/202 1 0200109074/012/014 23 200109047 22 0.20.0109262 (red) 21...