• 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...
Back
Top