do while loop problem

I have text files that may have one, or multiple, instances of the following line groupings: PG27FANU1022356 PG2803110701 PG30A0331202412002 2809...

Hello! I am trying to do a "Do While" loop to calculate a running total based on criteria. For the below: What I am trying to do is while the SKU column is the same, add up all the pink quantities together, add up all the purple quantities together (make the purple quantities positive) and...

Dim wb As Workbook Dim ws As Worksheet Dim objFSO, strTextFile, strData, arrLines, LineCount Dim ReceivedTrans, Mis As Integer Dim MyFolder, MyFile, MyFileName, MySheetName, ReportDate As String Dim FileType As String Dim i, j As Integer Const ForReading = 1 i = 1 j = 1 Set objFSO =...

i want to concatenate two columns which are in between two yellow filled rows but its concatenating for whole column till the end of column Sub ConcatColumns() Do While ActiveCellColor = NoFill 'Loops until the active cell is not coloured cell. ActiveCell.Offset(0, 1).FormulaR1C1 = _...