Search results for query: *

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

Hi Skip, I applied what you suggested and it worked. Thank you for your help! Simpler is sometimes better.

Hi Skip, Thanks for your help. Sorry for not being clear. I get a daily download of IDs and other details. I need to take the most recent ID. The IDs are incremented with the latest version is in the largest row number. What you provided takes the older version of the ID instead the latest...

Thanks Skip. I sorted column F and BL. Column F contains my IDs (which can be many from 2 to 15 duplicates) and column BL contains row number using (ROW() function.) The goal of the macro is to only keep only one unique ID with the largest row number. Unfortunately, the macro above can not...

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

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

Hi Skip - it worked. Thank you for your help!

Hi Skip - see attached file. Also note that the file is producing breaks that are not breaks (reduced the number of rows). I've attached real number of rows/columns. Thanks in advance for your...

Hi Skip, I ran the macro you provided this morning using my standard data set 20,000 rows and 57 columns. Unfortunately, the macro crashes excel with Not Responding and I have to restart my excel. Not sure what to do?

Thank you so much Skip. It looks great. I will test it on my complete data set Monday morning and will let you know how it goes.

That would be awesome Skip. Thank you again for all your help.

Hi Skip, 1) Comparing two data sets. Sheet 1 is an extract from an internal system/ data set and sheet 2 is from a third party system. I am performing a reconcilation between the two to ensure the third party system has a record of all internal transaction IDs. There are mismatches caused by...

Thanks as most go rt the file and solution. I appreciate your time and effort. My only concern , Sorry for not mentioning it before, the sheet will have 20,000 rows and 55 to 60 columns will the spreadsheet method work? Is possible to do it all in VBA using arrays? Unfortunately my VBA skill...

In the code I provided the macro assumes a one for one relationship for tansaction IDs. If a transaction ID is missing in one of the sheets it throws of the comparison giving false breaks in diff sheet. Note the other columns will not always have the same dates and column numbers might expand...

Hi Skip, Thanks for the welcome. Sorry for not being clear. Sheet 1 and Sheet 2 share unique ids. The macro above compares rows and columns in each sheet and prints out differences in Diff sheet. I sort each sheet by unique id in (column 1) and the macro compares data in rows and columns in...

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