mickg

Hello, I am new to this forum, but ran across MickG's code for using VBA to merge duplicate rows and sum values in certain column. I was hoping someone might be able to help me edit this code to suit my needs. The original thread is here: VBA to merge duplicate rows and sum values in certain...

I found this code on the forums posted by MickG: Sub MG02Sep59 Dim Rng As Range, Dn As Range, n As Long, nRng As Range Set Rng = Range(Range("A2"), Range("A" & Rows.Count).End(xlUp)) With CreateObject("scripting.dictionary") .CompareMode = vbTextCompare For Each Dn In Rng If Not...

Hi, I have data in two tables on one sheet. I would like to remove duplicates and consolidate/sum the values for each table (separately). If possible, can you also please describe what each line does. A B C D E XX $$ XX $$ XX $$...

Hello Sir(s), I am now in <acronym title="visual basic for applications">VBA</acronym> and I want some from your side in this code. Dim Strg As String Dim Z As String Dim n, nn As Integer Dim c As Integer Dim Lst As Integer For nn = 64 To 83 Lst = IIf(nn = 83, 88, 90)...

I have below cash flow with Date and Amount,what method should i use for this for net Present value, NPV or XNPV. and how i can calcuate the PV. PV=XNPV? <TABLE style="WIDTH: 161pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=215 border=0><COLGROUP><COL style="WIDTH: 51pt...