Recent content by Jorispk

  1. J

    Convert Text into numbers with vba

    Thank you very much Brian This code works perfectly, Ty!
  2. J

    Convert Text into numbers with vba

    Goodafternoon, I have written a vba code that copies a list from one workbook to another workbook. This all works perfectly. But the list contains numbers that are written as text values. (The list is big most of the times over 1000 rows), I need the text values converted into numbers. The...
  3. J

    Find and copy several values

    thanks this works great !!
  4. J

    Find and copy several values

    Thank you very much!! This is already working fine! It sorts out the different lines perfectly ^^. I can work with this results thank you! Edit* I can't get it work for a 2nd subject Sub test() 'Brian Warnock November 2011 Dim lastrow As Long Dim r As Long Dim ws As Worksheet Set ws...
  5. J

    Find and copy several values

    Thanks for the reply, will try this tomorrow. Look (suppose the code works fine) In row 2 style A in column D/E is found and style C in column G is found. The program needs to copy Style A, Style C from row 2 and most important the quantity located in row 3/4 and Column S/T/U(merged cells)...
  6. J

    Find and copy several values

    Good afternoon, I'm trying to make a very complex VBA code in excel but so far it is not working as it should. Information: In excel I get a list wich is containing over 300 rows of information on 1 sheet with each different statements. (Used for weight calculation) Each statements...
Back
Top Bottom