Recent content by mckhoa

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

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

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

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

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.

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

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.

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

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

Got it. Thanks

what do I put in C3 then? Sorry!

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

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

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

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?