Search results for query: *

xlbo, thanks for the help. i used you suggestion.

Hi, I found the below code in one of the threads and was wondering if can be amended to handle the following: I have two sheets I want to compare and spit out discrepancies in another sheet (called discrepancies). The Id will be common each sheet. I want to compare amt, order and price (see...

Thanks for the code John, but I want to capture duplicates only. So, if a text is appears more than once, I want to capture the original text and the duplicate cell in another sheet. Thanks Mike

I tried the below code, but it copies everything in the sheet Sub stance() Dim c1 As Range, c2 As Range Dim lRow As Long lRow = 1 For Each c1 In Worksheets("MBS15 P&L Report").UsedRange.Columns(2).Cells Set c2 = Worksheets("MBS15 P&L Report").UsedRange.Columns(2).Cells _...

Hi, I've seen code to delete duplicates. I can modify the code to copy the duplicate cell into another sheet, but how can I copy both duplicate cells and copy both rows into another sheet. I basically want to track duplicate records. Your help will be greatly appreciated.....

Yeah...I made a mistake...They are not Unique....Sorry about that...

will Lookup run faster?? Skip - 20,000 rows in range fundingtradedata

Yes. Each value is unique. Not sure about the SUMIF calculation once for each group of values and then copy the value into that range. I'm not sure what ur talking about.

I don't need the sumif function, but I do want the results. I'm not sure how to to the longwinded way. I would appreciate any suggestions.....Thanks again for your help..

over an hour. i figured VBA would be quicker

Below code takes 45 minutes to process 28,0000 rows. I'm using a SUMIF to grab data from another tab with predetermined ranges. This is my second post and need your help. I never encountered this type of problem before. Please Assist!! Sub BBGDownLoad12() Dim lastcell As Long...

Hi, Apologies for not being clear. "fundingtradedata" and "fundingpl" are ranges that contain info needed in my download tab. There will always be data in these ranges for my tab. Pivot Table would not work because i'm using the data i'm pulling in from the sumif to calculate other values in...

Hi, I appreciate the code GlennUK. I works great for less than 10,000 rows, but the s/s freezes up if the data is greater than 10,000 rows. Not sure how to proceed. It is a little frustrating process.....

Hi GlennUK, How do I get it to do the remaining 27,000 rows. Not sure how to program that in the below code. Sub BBGDownLoad12() Dim lastcell As Long Application.ScreenUpdating = False Application.Calculation = xlCalculationManual lastcell = 1000 Sheets("Download").Select Range("AB2", "AB" &...

Hi GlennUK, I will give it a try. Thanks for your suggestion.

Hi Guys, Thanks for you replies. i really appreciate all the help..I changed my code to what anotherhiggens suggested. I'm currently working with 28,000 rows and the macro crashes my spreadsheet (Not Responding). Iam using application>screenUpdating=false and application.Calculation=xlManual...

Hi, I tried your suggestion. It ran a little bit faster. It took 20 minutes instead of 25. I appreciate your help...I thought the formula in VBA would go very quickly

Hi, Yes...It still runs very slow.....It is driving me crazy...It is a simple sumif vba code.....there has to be a faster way

Hi, Thanks for the response. I tried that. Still very slow

I have a great deal of data that I pull in daily. It can range from 200 rows to 35000 rows. The below code works great if the date is not greater than 2000 rows. Can anyone suggest how to improve the efficiency of the code to handle large amounts of rows?? Also, It needs to be done in...