• 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. 3G

    Compare 2 lists..

    Luke = the man. You are right. Ha! You're original suggestion got it to work. Thanks!
  2. 3G

    Compare 2 lists..

    Hello- I've got a list of Vendor IDs (Col A) & Product IDs (Col G). The Vendor ID is 6 digits long, starting with 1 (10000). I have a list of product IDs for these Vendors that I created using the Vendor ID, also 6 digits long, but, the last number increments up if they have multiple products...
  3. 3G

    Use concatenate to create a workbook reference? (non-vba)

    Thanks HUI! THis also helps my question from the other day regarding ADDRESS & INDIRECT. Awesome!
  4. 3G

    Use concatenate to create a workbook reference? (non-vba)

    Hi there- I am trying to create a data sheet that will pull (eventually) from the sheets I load to the workbook. There are many sheets, but, the data is ALWAYS in the same position on the source sheets (O10-O24). What I'm trying to do is set up the summary/helper sheet to pull the data back...
  5. 3G

    Use drop down to load worksheet

    Luke- I've tried this techinique, and, it says the address is not valid? Here's what I've got: =HYPERLINK("[Book6.xls]Department "&A2&"!A1","Take me to Department: "&A2) Where Book6 is my file, and, Department 23 is a sheet name in that book. Any thoughts as to where I'm going wrong?
View older results
Back
Top