Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. OMG_VBA_IS_GREAT

    Create Pivot table from two sheets

    Hi All, I am struggling to get the following code to work. I want to create a pivot table using from two spreadsheets that have same column headers. Unfortunately, the macro fails. Any help or advise would be greatly appreciated. Sub CreatePivot() Dim i As Long Dim arSQL() As String...
  2. OMG_VBA_IS_GREAT

    VBA Delete Dupes ---SLOW

    Hi All, The below code finds dupes and deletes the dupe(s) with the lowest number located in column "BL". The code works great for small set of data (8k rows). I am trying to use the code for over a 500,000 cells takes over three hours to run. Any help would be greatly appreciated. Sub...
  3. OMG_VBA_IS_GREAT

    Delete Duplicates takes over 3 hours to complete

    Hi All, The below code finds dupes and deletes the dupe(s) with the lowest number located in column "BL". The code works great for small set of data (8k rows). I am trying to use the code for over a 500,000 cells takes over three hours to run. Any help would be greatly appreciated. Sub...
  4. OMG_VBA_IS_GREAT

    Compare Sheets with diff number of rows

    Hi All, I've been using the below code (took from this great website) and it works great when I have the same number of rows in sheet 1 and sheet 2. The problem I am having and I am struggling to resolve if one of the two sheets has different rows the macro displays diffs because the number of...

Part and Inventory Search

Back
Top