• 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

    Personal Macros Disappear from Alt F8 after saving a new macro

    Hi all- I have had this problem happen intermittently over the past couple of years but now it seems to happen almost every time I try to save a new macro to my personal file. I will insert a module in developer mode and paste the vba code in or manually record a macro. I will then save the...
  2. C

    Using Index Match or Vlookup on a column that has cells with multiple values separated by a Space

    Hi all- I have been trying to find a solution for this but have come up empty. We have a new system that puts all of our barcodes into one cell in column C (example below) These values are dynamic. Some have 1 barcode and some have 15+. I am trying to find a way to use index match or...
  3. C

    Personal Macros not showing in View Macros (Alt-F8) but showing in Visual Basic

    Hi all! I have no idea what happened. I have used a version of my Personal.xlsb file for years and have over 200 macros saved to it. I was creating a new macro, made my changes like normal and saved the personal file as usual. It had the unique box to save the personal as it usually does...
  4. C

    Split multi line cells into their own rows

    Hello- I have looked all over but can't seem to find a solution to something that should be simple. I pull data from a PDF that looks like the following below. When pasting, it automatically puts all of the data in one cell separated by a line break. The data changes every time it is created...
  5. C

    Extract Data from a Column based on Two Different Criteria

    I have searched but not been able to find a solution anywhere. I'm assuming I have to use an array of some sort. I'm trying to simplify my data and still have it make sense. I essentially have two columns on one sheet (Sheet1). Column A is all months. COLUMN A COLUMN B JAN AB JAN...
  6. C

    Autofill down to last PLUS additional row

    I have a data that I paste in column A that is dynamic in quantity when I paste it in. Formulas are written into cells B2:BS2 I am familiar with the formula below to get the formulas to fill to the last row LastRow = Range("A2").End(xlDown).Row Range("B2:BS2").AutoFill...
  7. C

    VBA to hide all blank worksheets

    I have been searching online but cannot seem to find an answer to this. I have an order sheet that has all of my vendors listed on separate worksheets. We do not order from every vendor during every order period so some sheets will end up being blank. I would like a macro to run that hides...
  8. C

    "If cell contains a String of text" in an Array formula

    Hi all, I have been recently learning more and more about arrays to implement into my spreadsheets and now have them functioning! What I cannot seem to figure out is how to set the criteria for an array to function if it is searching for a certain portion of a cell, not the entire cell. Below...
Back
Top