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

    How do you know Excel is your passion? Or is it?

    Great question Cheryl. But I think the answer is, you just know. Excel or modelling eclipsed any other hobby or interest I ever had. It extends you, it's creative and satisfying. It humbles you when you see how far others have gone. But it drives you to keep going. You become an optimist...
  2. Jack

    VBA documentation

    Just for anyone else looking for 2010 Developer's Documentation as opposed to 2013 here is the link. But note it is not as convenient as the stand alone CHM file for 2013 and has to be extracted to a specific location.... http://www.microsoft.com/en-au/download/confirmation.aspx?id=2451
  3. Jack

    VBA documentation

    Thanks Hui, I searched for the same thing but for 2010 but couldn't find it. If you or anyone else has the link I would be greatful. Cheers John
  4. Jack

    Its all good...

    Its all good...
  5. Jack

    Passing string to web page field (box)

    No worries Marc I was just trying to figure out how you got the URL from what I was seeing but hats off to you, it is great to have the functionality I wanted. Cheers John
  6. Jack

    Passing string to web page field (box)

    OK Marc L appreciate this very much and sorry to put you to more effort but I just want to understand this stuff better. Never had anything to do with XML before and was not even getting a hand hold on the learning curve. On the Test and troubleshoot your Linked CSE page - what is the xml...
  7. Jack

    Passing string to web page field (box)

    @Marc L Thanks very much works perfectly! I must confess I started at the Google CSE help but didn't know enough about how HTML or Java etc worked and so my eyes glazed over and further Googling led me to this other approach. Would you mind cutting and pasting the bit from Help that told you...
  8. Jack

    Passing string to web page field (box)

    Hi all I am trying to pass a search string a user enters to my Google Custom Search Engine (GCSE) https://www.google.com/cse/publicurl?cx=012611895431513734681:xpw195-soo8 . It used to be easy as the search string became part of the URL so I used followhyperlink happily. But these days the...
  9. Jack

    High level data summary using seperate table to define data to HL code [SOLVED]

    Haseeb your formula indeed works perfectly. This is a little gem of a formula with lots of real work applications, thank you very much again, well thought of. Thanks again for your interest Smallman agree and I knew it was a bridge too far to introduce two tables to interrogate within the one...
  10. Jack

    High level data summary using seperate table to define data to HL code [SOLVED]

    Haseeb So sorry to take so long to get back to you - been out all day. I will check this out tomorrow and reply again but it looks like very good to me. Thanks very much for taking the time. Cheers John
  11. Jack

    High level data summary using seperate table to define data to HL code [SOLVED]

    Hi Smallman Thanks for your response and time! Actually the different range size 100 vs 1000 was a typo so sorry for that impression as I know from bitter experience SUMPRODUCT has to be generally symmetrical. If I could I would go back and edit this so it doesn't distract anyone. But...
  12. Jack

    High level data summary using seperate table to define data to HL code [SOLVED]

    Hi everyone, I have a problem I have been trying to solve with SUMPRODUCT but you might have other ideas or come across the same situation. In summary and in simple terms, I want to use an intermediate conversion table to summarise data: data -> prod no -> higher level prod grouping...
  13. Jack

    Find 1st instance of text across multiple columns [SOLVED]

    Hello Shrivallabha yes great formulas, they work well, thanks very much for this. This issue can be closed now. Cheers John
  14. Jack

    Find 1st instance of text across multiple columns [SOLVED]

    All I decided to write a UDF to do this to put myself out of misery...this seems to work and I have it in an Index formula with F35 having the text to look for... =INDEX($F6:$S31,Rowfor_Nth_TextinRange($G6:$S31, F35, 1)-ROW(F6)+1,1) Thanks to Ozgrid for the headstart. Function...
  15. Jack

    Find 1st instance of text across multiple columns [SOLVED]

    Hi everyone This one I think is and I have certainly found to be harder than it sounds. I have a range of data spanning 13 columns G6:S30 with each column representing different jobs on any given day in a business for a roster. Each row is a 1/2 hour time slot. So an employee's initials say...
  16. Jack

    Creating an object of a subset of worksheets [SOLVED]

    Well this works if it helps anyone.... Sub testwssubset() Dim vWSsubset As Variant Dim vws As Variant Dim ws As Worksheet vWSsubset = Array("Sheet1", "Sheet2", "Sheet3", "Sheet4") For Each vws In vWSsubset For Each ws In ThisWorkbook.Worksheets If...
  17. Jack

    Creating an object of a subset of worksheets [SOLVED]

    OK thanks Narayank991 wow you are fast - Thanks I will try that syntax and play with it on getting to see the names as worksheets and let you know if it works. Cheers John
  18. Jack

    Creating an object of a subset of worksheets [SOLVED]

    Hi all I have a large Workbook with about 60 worksheets. But of these I have only 20 or so that have to be updated with new data. Can I or how can I create an object of these 20 worksheets which I need to define by tab name as the index numbers for these sheets are not in one group. I know...
  19. Jack

    SUMPRODUCT and Time problem

    Hi and many thanks Chandoo, I thought I was going nuts. The formula should work but it doesn't for some reason. I am not getting the days returned I am getting another number that makes no sense. After many frustrating attempts I have given up and gone for the following workaround index/match...
  20. Jack

    SUMPRODUCT and Time problem

    Hi everyone, I have a problem with using SUMPRODUCT and a range of time data (hours) from a report dumped out of our system as CSV, copied into my workbook. My formula is...
  21. Jack

    Sum

    Try this and adjust the ranges to suit =SUMPRODUCT((D2:D5)*(D2:D5>0))
  22. Jack

    Code for finding any combination of three numbers that add up to zero

    Hi Gert-Jan http://www.mrexcel.com/pc09.shtml has a Accounts Receivable tool from a Mr Excel Challenge - page down to IOANNIS's winning macro: section. I know it probably won't suit you right now as you need to know a bit about VBA to get it working for you. It also can be slow if the...
  23. Jack

    How to present 50 different variables in %

    mrzoogle I would think you want to summarise or highlight certain results by ID# and then have a summary to highlight across the 50 ID#s so you can see across this high number of things to manage. You would also want an interactive graph to see trends. I would leave the data as is in it's...
  24. Jack

    User form

    Thanks Lymm for this and to Vijay in the first place!
  25. Jack

    Using VBA to Change Drive Letter in Edit Links

    Hi SuperKrishna I really like Luke's code and this is an alternative that can work with it. I faced this problem with a new HP Laptop - HP took up Drive E with HP Recovery software and all my VBA for opening files assumed E for an External HDD which I tend to use for all data. But...
Top