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

    How to CC multiple recipents?

    Good evening all, I'm working on a file that automatically sends two files to multiple To: recipients, based off of emails in column I, I'd like to also CC: the emails in columns J and K (because those will vary depending on the recipient) but I have no idea how to do that. Any help would be...
  2. sharkey

    Copying Data from Multiple Worksheets based on Common Values

    Good morning all, I think I have the meat and potatoes for this from my extensive Google research, just need a little help combining what I have. Currently I have two macros that look at two separate worksheets and parse them into separate files based off of common values. My first macro does...
  3. sharkey

    Another confusing formula...

    Help! Totally lost here...For this equation I'm trying to take a value (N9) and subtract the amount of that value that is pending deactivation(I9), then from that amount I want to subtract values prior to applying a discount (1-$O$3), and then adding those values back and then multiplying by the...
  4. sharkey

    Can't figure out why this formula isn't working...

    =IFERROR(IF($E9="","",IF(AND(VLOOKUP($A9,PIVOTS.LOOKUPS!$BP:$BP,1,FALSE)=$A9,VLOOKUP($A9,PIVOTS.LOOKUPS!$BS:$BS,1,FALSE)=$A9),"DP & KM",IF(VLOOKUP($A9,PIVOTS.LOOKUPS!$BP:$BP,1,FALSE)=$A9,"CONVERT TO KM",IF(VLOOKUP($A9,PIVOTS.LOOKUPS!$BS:$BS,1,FALSE)=$A9,"CONVERT TO DP","")))),"") This formula...
  5. sharkey

    How to require a password based off of sales person.

    I'm working on developing a sales tool to be distributed to various sales teams, currently I have it set where you can select the sales person by a drop down list. I'd like to make it require a unique password on a per sales person basis, so the different sales people can't see each other's...
Back
Top