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

    split pdf file

    Hello, I had a code a while back that would split a pdf from pages x to y based on column A1 and B1. For example: A1 B1 C1 1 5 "Charlie" 6 9 "Mickey" The VBA would split the pdf from page 1 - 5 and rename it "Charlie", and then 6 - 9 and rename it "Mickey". My old computer went KAPLUNK and I...
  2. M

    split pdf pages in excel based on...

    Hello, I had a code a while back that would split a pdf from pages x to y based on column A1 and B1. For example: A1 B1 C1 1 5 "Charlie" 6 9 "Mickey" The VBA would split the pdf from page 1 - 5 and rename it "Charlie", and then 6 - 9 and rename it "Mickey". My old computer...
  3. M

    Excel VB Help!!!

    thanks for the heads up, new to posting, I will definitely make a better effort to titling my needs.
  4. M

    Excel VB Help!!!

    One other thing, can I get it to copy only files and not folders?
  5. M

    Excel VB Help!!!

    I notice that your file, it has the location of the file on the cell, how do I do it where the location of all the files are in one constant folder in the vb code.
  6. M

    Excel VB Help!!!

    I have an excel sheet, column A and column B. Column A consist of a list of names of folders Column B consist of another set of list of names of folders i.e. ColumnA | ColumnB 1abc Washington 342a Oregon and so on.... is there a code that I can write in VB that will...
  7. M

    copy formula from one sheet to another sheet

    I have a series of formula that is linked on sheet1, I would like to copy those formulas to sheet2 while still linking to sheet1, is there a way to do it in mass, I have about a thousand formula so it would take forever to do it by hand.
  8. M

    repeated list to single item list

    Thank you, you are awesome, made my day. That is great, I am very appreciative of it. Thank you!!!!!
  9. M

    repeated list to single item list

    Can this be done without VBA, I have a list of names. i.e. Names Bob Joe Mike Bob Tim Bob Mike I would like to somehow populate those list with no repeated names. So the results would be List2 Bob Joe Mike Tim thanks, mckhoa
  10. M

    Remove a product list from selection

    Got it. Thanks
  11. M

    Remove a product list from selection

    what do I put in C3 then? Sorry!
  12. M

    Remove a product list from selection

    I don't even know if this is even possible without a macro.
  13. M

    Remove a product list from selection

    There isn't any error. I am copying and pasting your code. Calculation is set to Automatic and I have a brand new no macros running. We might have a communication error. I just want to make sure I am communicating this correctly. I have a list (List 1) of Products containing the...
  14. M

    Remove a product list from selection

    Yes, I made sure to do ctrl+shift+enter the results: List Apple Pear Bannana selection Apple Results Pear Pear Test#2 List Apple Pear Bannana selection Pear Results Apple Apple Third test: List Apple Pear Bannana selection Bannana Results Apple Apple
  15. M

    Remove a product list from selection

    When I do this it gives me all Apple when I select Orange or Pear, it does not give me what remains in the list. Does that make sense? List1 Apple Pear Bannana I select "Apple" Output list should be: Pear Bannana Does that make sense?
  16. M

    Remove a product list from selection

    I have a list i.e. List 1 Apple Pear Oranges Challenge: I would like to have a drop down box select a product from List 1 (Easily done) However, in another column, it would populate all but the selected item from List 1. The challenge is to do this without VB code. (And also the...
Top