1. M

    Trim/Clean Rows faster in VBA

    Hello - I have the following code, but it takes a long time to run. Can someone help me shorten it/make it run faster? Thank You! Dim ws As Worksheet Dim lastRow As Long Dim i As Long ' Specify the worksheet Set ws = ThisWorkbook.Sheets("IMPORT_RATES")...
  2. D

    Completely cleaning account numbers and storing with a specific format

    Hi there, I'm interested in setting up VBA that I can use to completely clean account numbers and format them identically, no matter the data source. Just to explain my usecase a bit further, I'm bringing in account data from multiple locations and then running a lot of INDEX MATCH type of...
  3. D

    Clean, Trim, or otherwise remove all non-printing characters?

    Hi there, This topic has been brought up a few times, but the solutions I've found are not working too well. All I want to do is be able to remove all non-printing characters (including outliers like CHAR 160) and not have to worry about it breaking functions (primarily MATCH.) I'm not...
  4. S

    How to clean and convert data into columns using VBA

    Hi Friends, I been trying from few hours to clean and convert data into columns using excel formula. But its taking much to process huge data. I want take into different columns Like ColumnA ColumnB ColumnC ColumnD First Name Last Name Job title Company name Sample data sheet attached...
  5. B

    Clean up code

    Hi guys, bit of a novice at VBA and I have pieced together a workbook combing code I have recorded, sourced on the web and with help from this board. The code seems slow and clunky and I've now started to get 1004 errors. Is anyone willing to take a look and try and clean up the code for me? i...
  6. C

    VBA Code to Unhide columns

    I'd like to unhide columns based on clicking the a button that I have created. When the user clicks the button, columns F-I would unhide. When the button is clicked again it moves to unhide the next group of columns J-M and so on. I'd like to use the same button to keep this quoting worksheet...
  7. F

    Macros to create new excel files based on criteria

    Hey guys, I have an excel file that I need to create 4 separate files from. In column A I have either "Clean" or "Not Clean" and in column B I have either "NFL", "MLS", or "REMOVE". What I need is a macro that will create 4 files : Clean & NFL, Not Clean & NFL, Clean & MLS, Not Clean & MLS. I...
  8. drom

    usedrange when applied to a pivot table in a Sheet

    Hi and Thanks in advance I am feeding a table thanks to a macro, this table may have 40 rows or 20000 rows I have a Pivot table using this table as data source When feeding the table I clean always the previous data, and then I refresh the pivot table (I am using macros because I am doing many...
  9. G

    Copy data based on cell value

    Hello, I have a workbook where I want to copy specific row data based on the value of a cell in a column. Below is from my workbook. The goal is anytime there is an "x" in header "R", then the cell values from columns "A", "B" and "I" are copied onto a new sheet called "ROCC". Same thing...
  10. S

    Create a String to Use as a Range Name - Illegal Characters

    The problem, I think, is that I'm ending up with illegal characters so can't use the string as a range name and I don't know where the characters are being inserted. I also understand a UDF can be created to clean the string, but I simply can't figure out to use the UDF with VBA. Help. TIA...
  11. R

    Calculated Field in Pivot Table

    I'm trying to create a calculated field in a pivot table. The table's structure is below. The Sum of Sum of Clean Loans (I'll change the title once the data works) should come out to 82. I've also pasted the formula in the calculated field below. I've never worked with these before, and...
  12. M

    Show Cells that are referenced in data validation

    I took over a spreadsheet for someone and I want to clean it up. On sheet1, there are several places where list validation is applied that references lists on sheet2. I am pretty sure some of the lists on sheet2 are NOT being referenced, so I want to get rid of those items for the sake of...
  13. S

    Can I remove duplicates from a CELL?

    I have a spreadsheet with a few hundred URLs in it, but for whatever reason they have all doubled up. For example, A1 looks like: "https://website.com" Is there a way I can clean this up? Kind regards
  14. K

    Need referral for class best suited for data clean up

    I am looking for suggestions for an online class (self guided preferred) that will teach me everything I need to know about formulas/functions that will help me clean up messy files from a lot of different sources. I have basic excel knowledge but am expecting a much heavier workload very soon...
  15. L

    clean() break lines - creating space after

    Hi I used alt+enter to enter the following in one cell. John Smith 123 Main Street MyCity, 12345 Then I used Clean() to clean break lines. But I ended up with a text look like this John Smith123 Main StreetMyCity, 12345 How can I create a space between "John Smith" and "123 Main Street" and...
  16. L

    clean none printable unicode chars

    Hi I have cells as below. I know clean() function will not clean these chars and I will need to do substitute() these chars with "" for example. But I have 2 questions: 1) does that mean I have to create a new substitute() function for each cell? knowing these cells are having different chars...
  17. H

    Help With Error in VBA CODE

    Hey I got a weird Problem with my Code (Clean Sheets Cells) I have Picture on my sheets to press on and Macro Running as it should everything in the Code Works ok BUT BUT when the code is running from sheets 2 Clean Specific cells and then Jump on to sheets 1 and Clean specific cells as it...
  18. B

    Range Object adds extra space that cannot be trimmed without specifically trimming the cell

    I have some code that is supposed to Trim the values of cells quickly, taken from here: <code> With ActiveWorkbook.Worksheets(WSname) .Activate Dim rng As Object Dim Area As...
  19. M

    VBA Help

    Hi, I need to run some VBA code to clean Column D on various workbooks. Column D contains a load of names from websites/apps with a load of non-Alpha characters. I have found the below two functions online which are perfect for what I need to do. However they need to be done in order, first...
  20. A

    Want Fill blank cell values with left cell values if condition matches

    Hi, I have below scenario, I want to fill Clean data column with Source data if clean column do not have values only if first column data is matching after source and Clean. <tbody> Source_Account_Name Clean_Account_Name Amit Chavan Amit Chavan Amit Chavan Amit Chavan A Amit Chavan A...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back