Search:

Type: Posts; User: Acholate; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: VBA to extract website that does not support IE

    any help?
  2. Re: VBA to extract website that does not support IE

    bump
  3. VBA to extract website that does not support IE

    I am trying to extract data in the table in this site.

    https://www.dw16.com/indicative-price-and-info/?dw=SAWA16C2001A

    Using various method, eg. web query, ie automation. I can't find a way to...
  4. Replies
    8
    Views
    543

    Re: VBA to extract Java script table

    I finally make it work!. Just knew that i have to put DW symbol in bracket...
    quite stupid from me taking so long to realise this.
  5. Replies
    8
    Views
    543

    Re: VBA to extract Java script table

    You said "call the getData sub with the DW symbol that's required". I don't know where should I input DW symbol in your code. I just see you put 'AOT28C1804A as comment.
    I also tried to replace...
  6. Replies
    8
    Views
    543

    Re: VBA to extract Java script table

    bump
  7. Replies
    8
    Views
    543

    Re: VBA to extract Java script table

    Help please :(. Even though I can write basic VBA, but advance VBA like Kyle123's solution I dont quite understand.
  8. Replies
    8
    Views
    543

    Re: VBA to extract Java script table

    Still need help. I dont really understand how to input DW symbol using Kyle123 solution.
  9. Replies
    8
    Views
    543

    Re: VBA to extract Java script table

    Thanks so much for solution
    However, Im a bit confuse. I suppose to call the getData sub right (Call getData)? And how to input DW symbol?
    What I did with others DW symbol (from other site) is...
  10. Replies
    8
    Views
    543

    VBA to extract Java script table

    Hi

    I need help on VBA which able to extract table from this site

    https://www.thaidw.com/tools/livematrix/AOT28C1804A?lang=en

    The table that contain underlying bid & DW bid

    note:...
  11. Replies
    23
    Views
    27,257

    Re: How to use VLOOKUP to return multiple values

    That formula is what I looking for! Thank you so so much, you are lifesaver!

    I don't know beforehand that F1A-A01-DUSS occurs twice in Solist. The Solist's data is updated by import company's...
  12. Replies
    23
    Views
    27,257

    Re: How to use VLOOKUP to return multiple values

    bump
  13. Replies
    23
    Views
    27,257

    Re: How to use VLOOKUP to return multiple values

    bumppp
  14. Replies
    23
    Views
    27,257

    Re: How to use VLOOKUP to return multiple values

    bump..
  15. Replies
    23
    Views
    27,257

    Re: How to use VLOOKUP to return multiple values

    Yes Exactly



    Unfortunately no, there are other entries as well.
    I guest I need to show you the full data of my work, please take a look.

    stock forecast.xlsx
  16. Replies
    23
    Views
    27,257

    Re: How to use VLOOKUP to return multiple values

    bump...
  17. Replies
    23
    Views
    27,257

    Re: How to use VLOOKUP to return multiple values

    bump
  18. Replies
    23
    Views
    27,257

    Re: How to use VLOOKUP to return multiple values

    bump
  19. Replies
    23
    Views
    27,257

    Re: How to use VLOOKUP to return multiple values

    I see now how your formula work, thank you again. But is it possible for you to create formula without change my data from column to row.
    Because actually I need to make next column (C) to show...
  20. Replies
    23
    Views
    27,257

    Re: How to use VLOOKUP to return multiple values

    Thank you very much for your formula, I tried it but it still do not work somehow.

    B3 still return SO560700288 not SO560700167
    It look the same as my vlookup formula, I don't know what when wrong
  21. Replies
    23
    Views
    27,257

    Re: How to use VLOOKUP to return multiple values

    Thank you very much for your reply.
    I cant believe that I mess up vlookup formula, my bad for not checking properly
    but I do understand vlookup concept.
    Here is my fix: LookupSample2.xlsx
    This...
  22. Replies
    23
    Views
    27,257

    Re: How to use VLOOKUP to return multiple values

    bump
  23. Replies
    23
    Views
    27,257

    Re: How to use VLOOKUP to return multiple values

    Thanks for these videos.
    I spending a hour try to apply formula to my case but still does not work.
    Something went wrong in my formula, I feeling so stupid right now :(

    This sound a bit selfish...
  24. Replies
    23
    Views
    27,257

    Re: How to use VLOOKUP to return multiple values

    bump
  25. Replies
    23
    Views
    27,257

    Re: How to use VLOOKUP to return multiple values

    someone help me out please!
Results 1 to 25 of 26
Page 1 of 2 1 2