Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jimmyfinch

    Macro to add line between certain rows

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

    Move certain rows to top of worksheet

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

    Move certain rows to top of worksheet

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

    Move certain rows to top of worksheet

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

    Move certain rows to top of worksheet

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

    Move certain rows to top of worksheet

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

    Move certain rows to top of worksheet

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

    Move certain rows to top of worksheet

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

    Macro Button to format cells

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

    Macro Button to format cells

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

    Macro Button to format cells

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

    Macro Button to format cells

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

    Button to format cell contents in Excel

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

    Macro Button to format cells

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

    Button to format cell contents in Excel

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

Part and Inventory Search

Back
Top