Search:

Type: Posts; User: BlakeSkate; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Search for multiple text within a cell and return text

    So what happens in column B when it finds more than one of the search terms?
    do you have a list of these search terms?
    does it have to be a formula or does VBA work?
  2. Re: Macro for identifying distinct days from time stamp doesn't work

    you can just post the link the workbook here on the forum
    make sure to change sensitive data or break the link after a solution is found although to help other people with maybe a similar problem...
  3. Re: Macro for identifying distinct days from time stamp doesn't work

    Any chance you can upload your workbook to cloud storage like dropbox or google drive?
    I can't seem to replicate the merged cells
    If you can upload it please include a second sheet that DOESN'T...
  4. Re: Macro for identifying distinct days from time stamp doesn't work

    this is what i have after running your code and i have a feeling its not whats intended because the beginning where it wants to select D:F and unmerge something doesn't happen when i copy/paste the...
  5. Re: Macro for identifying distinct days from time stamp doesn't work

    a few things to help people understand what you're trying to accomplish:
    - use code tags when posting code
    - show an end example of it working and it not working
    - explain "my problem is it works...
  6. Replies
    1
    Views
    105

    Re: Dictionary Overlap Problem

    Update: So my code is fine
    I was not made aware by my boss that two of our vendors are merging and they are migrating the part numbers over
    So MTT is going to WM so WM has added columns. The price...
  7. Replies
    1
    Views
    105

    Dictionary Overlap Problem

    Hey i'm having some trouble identifying an issue with a dictionary that is returning a key its not supposed to have
    I've checked over my code 9 times and tried isolating the problem by commenting...
  8. Replies
    4
    Views
    135

    Re: @MATCH Function?

    Lotus is a lot like Visual Basic. "@Matches" is syntax used to match strings and patterns in that language, but it's weird that they kept the @ symbol but got rid of the "es". If it works it works...
  9. Re: Search entire column data in a another column

    will there be any blanks in column c?
    and what about column a?
  10. Re: Help with totaling up currency for a game

    try this?

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
  11. Re: Someone else is using the file. Please try again later.

    using an event like workbook_open
    So if you paste the event code in "This Workbook" rather than "Module 1" it will do whatever you want with the workbook rather than regular subs/macros.
    here is a...
  12. Re: Someone else is using the file. Please try again later.

    yes but your sub still opens a workbook.
    my sub would go in the
    A&S CFC Funding Hierarchy.xlsm

    so when you open the workbook (by macro or otherwise) its opening a copy. this would go for...
  13. Re: Someone else is using the file. Please try again later.

    well it would make it so if anyone opened it they are opening a "copy" of it. This is NOT read only so you can still interact with the data etc
    the only time you would have an issue is if two people...
  14. Re: Someone else is using the file. Please try again later.

    Offthelip posted generally what i was getting at
    here is my own version of the solution
    after creating a temporary file folder, copy/paste this into the "This Workbook" code of the "master file"...
  15. Re: Someone else is using the file. Please try again later.

    i think in this instance it would be best to open a copy of the workbook if you have multiple users using the same files.
    I.E make a macro/button to open copies of files, and if someone is making...
  16. Replies
    9
    Views
    151

    Re: Excel Formula to give unique countif

    did you try the code i provided? it should do this without whatever you added
    i'll attach an example:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color:...
  17. Re: Delete rows if cell value is not contained on a list

    This should achieve what you want if you create a sheet named "Locations" that has all of the locations in column A with no blanks
    As well just run this on the active sheet where you are trying to...
  18. Re: Delete rows if cell value is not contained on a list

    or could you put this list of locations in an excel sheet attached to the workbook of your report? or perhaps in a separate workbook that will never ever be moved or deleted??
    if so tell me which...
  19. Replies
    9
    Views
    151

    Re: Excel Formula to give unique countif

    oh nevermind. i see you mean that there is cell values that = "No Change" that you would like excluded. so maybe this? hard to tell without an example
    ctrl + shift + enter must be used

    ...
  20. Replies
    9
    Views
    151

    Re: Excel Formula to give unique countif

    does No Change have blanks? (assuming that is a named range, if not please explain what no change is)
    or just the BN3:BN277 range?
  21. Replies
    4
    Views
    113

    Re: Extract a number from a long Cell

    in order for there to be a clean cut way to do this you need to provide some sort of pattern that your data has
    i.e

    if this number always appears after the second set of semicolons, etc
  22. Replies
    11
    Views
    248

    Re: Non Case Sensitive Dictionary

    thank you for the info
    and thank you Rory for the answer
    works a charm
  23. Replies
    2
    Views
    94

    Re: XLSB Corrupted - Can't Open VBA

    safe mode worked just fine :)
    all is good, crisis averted
  24. Replies
    2
    Views
    94

    Re: XLSB Corrupted - Can't Open VBA

    removed the file from the folder XLSB is stored in and all my other workbooks work fine now.
    i'll take this time to backup everything that isn't XLSB, but is there a way for me to view the module...
  25. Replies
    2
    Views
    94

    XLSB Corrupted - Can't Open VBA

    I've gone and donked up my XLSB file somehow.
    i can access the workbook itself but i can not save it, nor can i access the VBA editor to fix whatever vba code is causing this in the first place....
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4