• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. B

    Find matching value in 2 different columns and copy data if match

    Hi There, can someone advise me on my code? i want to find the matching value from B9:B100 Sh4 columns B14:B51 Sh 7. when found, copy the cell +13 col of the found value row of Sh4 to cell + 3 of the found value row of Sh7. my code isn't finished but it can't find match... and there is...
  2. B

    from a tree data organisation to data table, please any idea?

    Yeeessss!!! that is good! one piece of the puzzle i won't have to bang my head on the wall. Thank you.
  3. B

    from a tree data organisation to data table, please any idea?

    Well, i would like to do this: i have an house name X, 5 rooms. put house name x in cell, and 5 in an other. when press save, it create a table:house x /room1, House x /room2, house x /room3, House x/ room4, House x/ room. ID room 1,2,3,4,5 then i enter a new house: name Y, 2 rooms. put house...
  4. B

    from a tree data organisation to data table, please any idea?

    Hi and thank you for this great help. it don't behave exactly as i'm trying to achieve but your code is a solid base for it. Thanks again.
  5. B

    from a tree data organisation to data table, please any idea?

    Hi There, dose any one know how could i generate a simple column, row table from a tree data organisation. it will be much more explicit to just look at my attached fill. Thanks a lot.d
  6. B

    VBA : Looking for a variable date into a different sheet, Please some help)

    ok i will do ) thank you. Great help
  7. B

    VBA : Looking for a variable date into a different sheet, Please some help)

    thanks heaps. but Dam i have this "subscript out of range error o_O. yellow on Set ws2 = ThisWorkbook.Worksheets("Sheet2"). do i miss somethings with active and thisworkbook statment. any idear of reason? Sub CopyTimeLine() Dim ws2 As Worksheet Dim ws7 As Worksheet Dim rng As Range Dim...
  8. B

    VBA : Looking for a variable date into a different sheet, Please some help)

    Hello and thank you for the welcoming. Thanks for you expertise. you definitely clean up my mess. i'm almost there. however, if the date is not found then i don't want to do anything just message box. (the date will be found anyway) i need to find where (x,y) is the searched date so i can...
  9. B

    VBA : Looking for a variable date into a different sheet, Please some help)

    Hi There, Please, anyone can help me with a VBA code. Purpose is : Finding the variable date form "Sheet2" "F13" into my Row 13 "sheet 7" (Col F to HP) get the location Cells(Y, x) so i can from this Cell (Y, x) copy and past some selected data do "sheet2". This is a part of a macro attached...
Back
Top