nrng

Hi Atry adapt a code, but din't work. Before Nº da NFe Série Data Emissão BASE ICMS ST CST Código do Produto 2805151 3 43643 110,78 210 101173 2805153 3 43643 100,44 510 100092 2805155 3 43643 1028,35 210 106447 2805157 3 43643 50,67 570 402850 2805159 3 43643 100,44 510 100092 2805161 3 43643...

Hi, Please help on the following code supposed to delete rows with duplicate values in P column and keep the first instance after combining the values in the 8th and 10th columns, but I get the 1004 Delete method of Range class failed error on the EntireRow. Sub MG02Sep59() Dim Rng As Range...

Hi, my data is as below: Sample Data: A B C Result: DG M 1 DG M 5 DG M 2 KH M 9 DG M 2 SG C 7 KH M 4 KH M 5 KH M 5 DG M 5 SG C 6 SG C 1 KH M 3 KH M 2 DG M 5 I got 3 column here, and I wish to sum up the value if rows in...

I have the following code from a previous threat for combining rows. Currently it sums my qty based on UPC, and deletes the duplicates. However, I need it to sum qty for the same UPC, when the location is not the same. Sub subSumDupes() Dim Rng As Range, Dn As Range, n As Long, nRng As Range...

Hello, Is there a way to alter this code to post the font, font size, and font color to the destination sheets? What I mean is to maintain the individual cells from the source sheets. Thank you very much for your help, XJ <code>Sub AddEventsToSheets() Call ClearCells Dim ws As...

Hi I am trying to create an array from an excel spreadsheet then manipulate it for example say you have cells a1:a5 with different values or strings I want to take that and then create a array so that I can then make there be extra rows between each string, add new stuff between for example say...

Hi, Need help to add / alter the code. Need to sum the values on column 4 & 5 by locating duplication on column 1. Say for an example: <tbody> Consumables 31222 NY <tbody> 698.2 </tbody> 77.6 Consumables 31222 NY 123.4 445.9 Consumables 31222 NY 554.21 23.5 Spares 31119 NY 33.4...

Hi all, i have the below code, which i was working for many years, but it block in a sheet on the point with blue letters. I would much appreciated if you could help me so that to run the code. The message which appears is follow: Run-time error '13': Type mismatch Thanks in advance Dim...

Hi All, I need a table that shows the DriverName and Duration columns, every other column can be deleted. All duplicates must be delete and the duration for each driver should be summed. I've been struggling with this for a while, the code i've been trying to use is below. It needs to be done...