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

    Attaching Specific Files To Specific Email Addresses (via MS Outlook or Excel)

    I have a folder with approx 300 small file sized PDF's. They are all specifically named to a unique email recipient. I also have a list of these specific email address (that match the file names exactly). Lastly, I have an Outlook email template I will use to attach & send each file to...
  2. I

    Finding Duplicates, Transposing Data From Dupe Rows

    I have an example worksheet attached. This should make my question relatively simple. http://www.iandmyself.me/example.wksht.transpose.consolidate.duplicates.xlsx I have duplicate company names down a column that contain data that needs to be on one consolidated row. I'm hoping someone...
  3. I

    Highlight Cell If Match Found In Another Column

    Money shot. Thanks
  4. I

    Highlight Cell If Match Found In Another Column

    I am looking to highlight each cell in Column E, if a match is found in Column H. Highlighting the entire row would be nice (but since some rows are not contiguous -simply highlighting the match will suffice). I would like to highlight the match in Column E (if found in Column H). I've...
  5. I

    Highlight Entire Row With Non Contiguous Data If...

    Thanks I really appreciate it.
  6. I

    Highlight Entire Row With Non Contiguous Data If...

    I am looking to highlight an entire row if a matched name is found in Column L (from Column N). Some of the rows have blanks (hence why I'm looking for something to select the entire row regardless (selecting non contiguous rows). Any help is appreciated. Thanks.
  7. I

    Activating The Next Cell Down Once Column M Is Reached

    This worked perfectly. Thanks Luke.
  8. I

    Activating The Next Cell Down Once Column M Is Reached

    I have an excel sheet I simply use at work to track and log jobs. When the file is opened, I have a code that basically finds the next empty cell in the row and activates it (to ensure the next "thing" to fill in on the tracker is always brought to focus so I don't have to scroll around for...
  9. I

    Outputting The Value Of A Scanned Barcode In A Cell

    I appreciate as always Luke, I'll check out the link and keep digging.
  10. I

    Outputting The Value Of A Scanned Barcode In A Cell

    I work with forms through out each work day scanning them in - scanning them out etc (basically a lot of scanning using a hand held scanner), and I have to also manually type in the barcode number in excel (the manual barcode entry typing part is getting a bit annoying). My question... Is...
  11. I

    Break-Up Cell, Transpose Across With Specific Character

    Sounds simple enough, but the transposing the line coding would be the challenging part I guess. Is there any way I could email this workbook perhaps?
  12. I

    Break-Up Cell, Transpose Across With Specific Character

    With the example workbook beneath, I'm trying to disect each line in range based on the character "}" end brace, and then transpose it across. As you'll see it works fine, but the problem I'm running in to and why I need help is that it doesn't seem to work if an end brace is missing. My aim...
  13. I

    Concatenating Entire Row

    My code was placing another value in the string I forgot about but I figured it out and fixed it. I have no errors the code you helped me with works perfect thanks again. I noticed it is a little slower than: C = C.Offset(, 1).Value + C.Offset(, 2).Value + C.Offset(, 3).Value etc.. But I...
  14. I

    Concatenating Entire Row

    I did actually, but I wasn't going to bother you with that one, unless you want to of course : )
  15. I

    Concatenating Entire Row

    Resolved. Thanks Luke. I figured out what I was doing wrong. Everything is tip top now. Thanks again.
  16. I

    Concatenating Entire Row

    What do you have pre-populated in your worksheet before you run the code? I have: Row 1: Header Row 2: TextSegment1 in A2 | TextSegment2 in B2 | TextSegment3 in C2 Row 3: TextSegment1 in A3 | TextSegment2 in B3 | TextSegment3 in C3 Row 4: TextSegment1 in A4 | TextSegment2 in B4 |...
  17. I

    Concatenating Entire Row

    No luck. I think it has something to do with MyRange. The code looks sound, everything looks right, it's just not working for some reason.
  18. I

    Concatenating Entire Row

    No worries, it was simply a direct link to a blank worksheet with the UDF you provided me with a few segments: Row 1: Header *not to be concatenated Row 2: TextSegment1 in A2 | TextSegment2 in B2 | TextSegment3 in C2 Row 3: TextSegment1 in A3 | TextSegment2 in B3 | TextSegment3 in C3 Row...
  19. I

    Concatenating Entire Row

    No worries, it was just a direct link to a blank worksheet with the UDF you provided me and simple example text (with a header in A1). Row 1: Header *not to be concatenated Row 2: Text1 in A2 | Text2 in B2 | Text3 in C2 | Text4 in D2 Row 3: Text1 in A3 | Text2 in B3 | Text3 in C3 | Text4...
  20. I

    Concatenating Entire Row

    Am I overlooking something somewhere? http://www.iandmyself.me/Example.UDF.Concat.xlsm
  21. I

    Concatenating Entire Row

    I thought I found the answer here: http://chandoo.org/wp/2010/12/07/merge-cells-without-loosing-data/ This was neat, and I think it's almost what I was looking for, but my question is still open. Still needing to concatenate without actually merging.
  22. I

    Concatenating Entire Row

    I'm using this in my sub: Cell = Cell.Offset(, 1).Value + Cell.Offset(, 2).Value + Cell.Offset(, 3).Value etc... But because I have 30 offset rows to merge, I'm sure there's an easier way to achieve this. Also, some of the rows are shorter than others, which will result in me combining...
  23. I

    Translating Formulas For Sub Use

    Thanks to you Hui and Dan I'm on the right track. Thanks a million.
  24. I

    Translating Formulas For Sub Use

    These two formulas do the exact same thing. =RIGHT(A2,LEN(A12)-SEARCH("(",A2)+1) =MID(A2,1+FIND("(",A2)-1,999) I'm trying to get either one of them to work this way (for a sub using active cell). =RIGHT(ActiveCell.Value,LEN(ActiveCell.VAlue)-SEARCH("(",ActiveCell.Value)+1)...
  25. I

    How To Open VBE UserForm Window (With Macro)?

    I wanted to have a quick shortcut button to jump directly in there. I make a lot of mistakes : )
Back
Top