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

    Help make recorded macro work (to obtain currency exchange rates)

    Hi All, I am hoping that someone can help me make the code below work. I used the macro recorder to create it, but when I try to run it later, it fails at .CommandType = 0 Run-time error '5': Invalid procedure call or argument Here is the recorded macro: Sub FXRate() ' ' FXRate Macro '...
  2. C

    Split multiple workbooks into multiple other workbooks based on cell contents

    Hi Hui, You give me too much credit and overestimate my brain power. I hunt and peck around the internet for code that can help me with my projects; however, taking something like the information in the links you provided and working that into my existing code is way beyond my capabilities. I...
  3. C

    Split multiple workbooks into multiple other workbooks based on cell contents

    Hi All, I currently have some code that pulls multiple single sheet workbooks into a single new workbook. The original workbooks sit in a folder on my desktop. After I run the first macro, I run a second macro that names each sheet based on the contents of cell A2. Both macros work...
  4. C

    Insert blank rows above a table based on unique values in one of the columns in the table

    Hi, First, my apologies if anything I write is unclear or if I have not provided sufficient information. I almost never have the opportunity to work with vba, so when I do get to play around with it once or twice every year or two, I come at it as an absolute newb. My question (with some...
  5. C

    Active cell contents: Show contents of active cell (any in a particular column) in another cell

    Ah, I see, thank you for the explanation. Now, if I might pester you again:DD Is it possible to have your code ignore rows 1 through 7? Here is what I mean: I am using your code to populate cells A2 and A4 (used to be K4 in my above posts). It is working perfectly; however, since your code...
  6. C

    Many ribbon features not available (grayed out), and undo feature not working

    Hi Deepak, You are correct. The sheet was locked. And ... this is embarrassing, but I am the one who locked it!!:oops: The problem is that I have never locked a worksheet before, and I did not know that all of those features would be disabled. After I figured out what happened, I also...
  7. C

    Many ribbon features not available (grayed out), and undo feature not working

    Hi, So sorry! I figured out the answer to my own question. Can this post be deleted? What can cause regular ribbon features to not be available for use, and the Undo feature to not work? I did not notice this until I wanted to use the "remove duplicates" feature, but it is grayed out (not...
  8. C

    Need formula to count unique projects for any given Project Manager

    Hi vletm, Thank you for what you provided. Your solution is fine; however, the sample file that I provided is not exactly like the real file. I would liked to have provided the actual file that I am working with, but if I did, my company would probably fire me (sensitive material)! The drop...
  9. C

    Need formula to count unique projects for any given Project Manager

    Thank you, John! This seems to be working perfectly.
  10. C

    Need formula to count unique projects for any given Project Manager

    Hi, I need a formula that will give me the count of projects that a particular Project Manager is assigned to. A simplified example of my file is: A2:A10 contains Sponsor names (ie. GSK, Merck, Biogen, Novartis, ect..) B2:B10 contains Project Managers names who are assigned to the projects C2...
  11. C

    Active cell contents: Show contents of active cell (any in a particular column) in another cell

    Amazing! Haha, well ... to me this is wizardry. Thank You Thank You Thank You!!! I have been wanting to learn VBA for some time now, but just haven't had the time nor, honestly, the brain power. Would you mind explaining what your macro does step by step? I totally understand if you don't...
  12. C

    Active cell contents: Show contents of active cell (any in a particular column) in another cell

    Thank you, Chihiro! Your code worked perfectly! Now, if I may .... I have had some time to think of ways to improve what I am trying to do. Would it be possible to do the same thing that your code does, but with one modification. What I would now like it to do is send the contents of column...
  13. C

    Active cell contents: Show contents of active cell (any in a particular column) in another cell

    Hi, Is it possible to show the contents any single active cell in a particular column, in another specific cell? For example, let's say that I want to be able to click on any cell in column C, and have the contents of that cell appear in cell K4. I would also want to be able to keep selecting...
  14. C

    Conditional formatting icons based on value of cell with formatting &how it relates to another cell

    Hi GraH - Guido, Thank you for your post. What you wrote is what I feared. I did not think that what I asked for was possible. I think your alternate solution makes sense, and will be easy to do. I just hope that the big wigs in my company are ok with that solution! Thanks! Carlos
  15. C

    Conditional formatting icons based on value of cell with formatting &how it relates to another cell

    Hi, I would like help with conditional formatting. I need arrow icons to point up, down or sideways based on the value entered in the cell with conditional formatting, and how it relates to the value in an adjacent cell. For example, if cell A1 contains 2, and cell B1 contains 1, then I want...
  16. C

    Dates (not really dates) not sorting properly

    This is awesome! Thank you so much. If you have the time, I would really appreciate it if you could explain how your formula works. I am particularly interested in the DATE and MONTH functions. Thanks again!
  17. C

    Dates (not really dates) not sorting properly

    Hi, I have a sheet with a column of "dates". I need to be able to sort the dates, but cannot do it since the dates aren't really dates. The problem is that I do not know how to make them dates. I have tried several things including Text to Columns, but nothing has worked so far. I have...
  18. C

    Hours Schedule by Role

    Thank you, P45cal! I will explore your solution more closely when I return from an afternoon appointment.
  19. C

    Hours Schedule by Role

    Thank you, Hui. This is amazing. You've made me happy by what you have provided, but you also make me feel a little bad about myself, as I am slowly arriving at the conclusion that, perhaps, I simply am not sufficiently intelligent to ever be able to come up with something like you did. I am...
  20. C

    Hours Schedule by Role

    Wow! I don't understand it, but wow. I will have to look at this tomorrow when I am fully awake and see if I can make sense of it, but it looks like it works perfectly! I don't think I will ever get to your level of awesomeness. Thank you!
  21. C

    Hours Schedule by Role

    Hi David, Thanks for the response. I have attached an updated file with a copy of the "HoursCostDistribution" (HoursCostDistribution (2)) sheet. In this copy I have deleted all of the roles except for "PM" in column H. As you look down column H, you will see that the PM is to perform 54 hours...
  22. C

    Hours Schedule by Role

    I don't know if what I want to do is even possible. I know it certainly is not with my current level of knowledge!! I have added an attachment. The first sheet, "HoursCostDistribution" is part of a tool that I receive for each new project for which my company is contracted to perform. The...
  23. C

    Conditional formatting for >=28 or <=-28

    Hi, I am working with a file in which I must find the difference between two dates. I am using a formula to do this. Then, I want to use conditional formatting to easily identify any cell in which the difference between the two dates is either greater than or equal to 28, or less than or equal...
Back
Top