Need Help with VBA Code

M

Megha1484

New Member
Joined
Nov 10, 2018
Messages
17
Hi,
I have been struggling with this VBA code for quite some time now and would appreciate any help with it. I have attached a sample spreadsheet I am working with. First sheet shows the raw data that comes from the SharePoint and second sheet shows the report I am trying to build form the raw data. Goal is to search for each question (starts at col C) and look for any “No – Correction Needed” and “No – Correction Not Needed” words and display the corresponding “ID”, “Name”, “Notes” associated with the question and “correction made”. I don’t want any “yes” or NA in the report only “Nos*”.
I have filled question “TND” as an example. So, when I run the code it should go through the entire col look for Nos and fill out rest of fields that comes from raw data. Here is the code I am trying to work with.
There are couple of issues with it. First, every time I will run the code it will start from scratch instead of picking up the row where it left off last. This could be an issue overtime when data starts building up.
Second, I am going to have to write the same code 32 times one for each question, which is OK as long as I can make this code work.
Third, I think its not recognizing the new report location where I am trying to build the report.


Sorry, I could not find a way to attach to Excel workbook so copied the sheets at the bottom of the email. First table is Rawdata and second table is Report. Thanks in advance!



Sub Report ()
'builds the report line by line based on iterative check of criteria

'clear old report data
Sheets ("Report").Select
Range("3:3").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Delete Shift:=xlUp

'set up for report build
Range("Report[Question ID]").Select


'iteratively search for selected criteria for Q1

Dim Q1Column As Range
Dim q1answer As Range
Dim q1current As Range


Set Q1Column = Sheets("Rawdata").Range("Table_Rawdata[Memo]")
For Each q1answer In Q1Column.Cells
If q1answer.Value Like "No*" Then
Set q1current = Range(Cells(ActiveCell))
Range("Report[@[Question ID]]").Select
Set ActiveCell.Value = "Q.1"
ActiveCell.Offset(0, 1).Select
Set ActiveCell.Value = "TD"
ActiveCell.Offset(0, 1).Select
Set ActiveCell.Value = "Deatiled Question Description"
ActiveCell.Offset(0, 1).Select
Set ActiveCell.Value = "Memo"
ActiveCell.Offset(0, 1).Select
Set ActiveCell.Value = Cells(q1current.Row, Range("Table_Rawdata[@[Name]]").Column)
ActiveCell.Offset(0, 1).Select
Set ActiveCell.Value = q1answer.Value
ActiveCell.Offset(0, 1).Select
Set ActiveCell.Value = Cells(q1current.Row, Range("Table_Rawdata[@[CorrectionsMade]]").Column)
ActiveCell.Offset(0, 1).Select
Set ActiveCell.Value = Cells(q1current.Row, Range("Table_Rawdata[@[MemoNotes]]").Column)
ActiveCell.Offset(0, 1).Select
Set ActiveCell.Value = Cells(q1current.Row, Range("Table_Rawdata[@[ID]]").Column)

Else
End If
Next q1answer

'Next datum - copy code for the next question...
End Sub


RawData(Sheet1)

[TABLE="width: 7847"]
<colgroup><col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2304;"> <col width="106" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3783;"> <col width="101" style="width: 76pt; mso-width-source: userset; mso-width-alt: 3584;"> <col width="175" style="width: 131pt; mso-width-source: userset; mso-width-alt: 6229;"> <col width="149" style="width: 112pt; mso-width-source: userset; mso-width-alt: 5290;"> <col width="175" style="width: 131pt; mso-width-source: userset; mso-width-alt: 6229;" span="3"> <col width="91" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3242;" span="2"> <col width="149" style="width: 112pt; mso-width-source: userset; mso-width-alt: 5290;" span="2"> <col width="175" style="width: 131pt; mso-width-source: userset; mso-width-alt: 6229;"> <col width="149" style="width: 112pt; mso-width-source: userset; mso-width-alt: 5290;" span="2"> <col width="175" style="width: 131pt; mso-width-source: userset; mso-width-alt: 6229;" span="2"> <col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2958;"> <col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2588;"> <col width="63" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2247;"> <col width="175" style="width: 131pt; mso-width-source: userset; mso-width-alt: 6229;" span="6"> <col width="98" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3498;"> <col width="62" style="width: 46pt; mso-width-source: userset; mso-width-alt: 2190;"> <col width="149" style="width: 112pt; mso-width-source: userset; mso-width-alt: 5290;" span="3"> <col width="175" style="width: 131pt; mso-width-source: userset; mso-width-alt: 6229;"> <col width="58" style="width: 44pt; mso-width-source: userset; mso-width-alt: 2076;"> <col width="175" style="width: 131pt; mso-width-source: userset; mso-width-alt: 6229;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2560;"> <col width="90" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3185;"> <col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 4295;"> <col width="110" style="width: 82pt; mso-width-source: userset; mso-width-alt: 3896;"> <col width="175" style="width: 131pt; mso-width-source: userset; mso-width-alt: 6229;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2560;"> <col width="114" style="width: 85pt; mso-width-source: userset; mso-width-alt: 4039;"> <col width="175" style="width: 131pt; mso-width-source: userset; mso-width-alt: 6229;" span="3"> <col width="95" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3384;"> <col width="125" style="width: 94pt; mso-width-source: userset; mso-width-alt: 4437;"> <col width="98" style="width: 73pt; mso-width-source: userset; mso-width-alt: 3470;"> <col width="128" style="width: 96pt; mso-width-source: userset; mso-width-alt: 4551;" span="2"> <col width="101" style="width: 76pt; mso-width-source: userset; mso-width-alt: 3584;"> <col width="134" style="width: 101pt; mso-width-source: userset; mso-width-alt: 4778;"> <col width="150" style="width: 112pt; mso-width-source: userset; mso-width-alt: 5319;"> <col width="109" style="width: 82pt; mso-width-source: userset; mso-width-alt: 3868;"> <col width="155" style="width: 116pt; mso-width-source: userset; mso-width-alt: 5518;"> <col width="232" style="width: 174pt; mso-width-source: userset; mso-width-alt: 8248;"> <col width="146" style="width: 109pt; mso-width-source: userset; mso-width-alt: 5176;"> <col width="133" style="width: 100pt; mso-width-source: userset; mso-width-alt: 4721;"> <col width="91" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3242;"> <col width="133" style="width: 100pt; mso-width-source: userset; mso-width-alt: 4721;"> <col width="143" style="width: 107pt; mso-width-source: userset; mso-width-alt: 5091;"> <col width="137" style="width: 103pt; mso-width-source: userset; mso-width-alt: 4864;"> <col width="134" style="width: 100pt; mso-width-source: userset; mso-width-alt: 4750;"> <col width="164" style="width: 123pt; mso-width-source: userset; mso-width-alt: 5831;"> <col width="138" style="width: 104pt; mso-width-source: userset; mso-width-alt: 4920;"> <col width="173" style="width: 130pt; mso-width-source: userset; mso-width-alt: 6144;"> <col width="169" style="width: 127pt; mso-width-source: userset; mso-width-alt: 6001;"> <col width="94" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3356;"> <col width="118" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4209;"> <col width="143" style="width: 107pt; mso-width-source: userset; mso-width-alt: 5091;"> <col width="152" style="width: 114pt; mso-width-source: userset; mso-width-alt: 5404;"> <col width="102" style="width: 76pt; mso-width-source: userset; mso-width-alt: 3612;"> <col width="162" style="width: 121pt; mso-width-source: userset; mso-width-alt: 5745;"> <col width="90" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3214;"> <col width="134" style="width: 101pt; mso-width-source: userset; mso-width-alt: 4778;"> <col width="126" style="width: 94pt; mso-width-source: userset; mso-width-alt: 4465;"> <col width="145" style="width: 109pt; mso-width-source: userset; mso-width-alt: 5148;"> <col width="132" style="width: 99pt; mso-width-source: userset; mso-width-alt: 4693;"> <col width="66" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2332;"> <tbody>[TR]
[TD="width: 65"] ID[/TD]
[TD="width: 106"]Name[/TD]
[TD="width: 101"]Memo[/TD]
[TD="width: 175"]TND[/TD]
[TD="width: 149"]STW[/TD]
[TD="width: 175"]DecAcc[/TD]
[TD="width: 175"]ConPro[/TD]
[TD="width: 175"]CoD[/TD]
[TD="width: 91"]BegDat[/TD]
[TD="width: 91"]Duration[/TD]
[TD="width: 149"]CP[/TD]
[TD="width: 149"]Contribution[/TD]
[TD="width: 175"]FIMF[/TD]
[TD="width: 149"]MBP[/TD]
[TD="width: 149"]Rpay[/TD]
[TD="width: 175"]OffAcc[/TD]
[TD="width: 175"]ReAcc[/TD]
[TD="width: 83"]ReErr[/TD]
[TD="width: 73"]Amt[/TD]
[TD="width: 63"]ErrAmt[/TD]
[TD="width: 175"]IC[/TD]
[TD="width: 175"]Dmet[/TD]
[TD="width: 175"]Status[/TD]
[TD="width: 175"]ResAccute[/TD]
[TD="width: 175"]Benaccu[/TD]
[TD="width: 175"]PET[/TD]
[TD="width: 98"]ComA[/TD]
[TD="width: 62"]Au[/TD]
[TD="width: 149"]Cplan[/TD]
[TD="width: 149"]DMWU[/TD]
[TD="width: 149"]SUIO[/TD]
[TD="width: 175"]SalPre[/TD]
[TD="width: 58"]Pdat[/TD]
[TD="width: 175"]OUPY[/TD]
[TD="width: 72"]Aman[/TD]
[TD="width: 90"]ClInter[/TD]
[TD="width: 121"]Wrkst[/TD]
[TD="width: 110"]BupWkst[/TD]
[TD="width: 175"]Lwaivers[/TD]
[TD="width: 72"]Review[/TD]
[TD="width: 114"]CC[/TD]
[TD="width: 175"]Comp[/TD]
[TD="width: 175"]TimExt[/TD]
[TD="width: 175"]RDMD[/TD]
[TD="width: 95"]Review Date[/TD]
[TD="width: 125"]CorrectionsMade[/TD]
[TD="width: 98"]MemoNOtes[/TD]
[TD="width: 128"]TNDNotes[/TD]
[TD="width: 128"]STWNotes[/TD]
[TD="width: 101"]DecAccNotes[/TD]
[TD="width: 134"]ConProNotes[/TD]
[TD="width: 150"]CoDNotes[/TD]
[TD="width: 109"]BegDatNotes[/TD]
[TD="width: 155"]DurationNotes[/TD]
[TD="width: 232"]CPNotes[/TD]
[TD="width: 146"]ContributionNotes[/TD]
[TD="width: 133"]FIMFNotes[/TD]
[TD="width: 91"]MBPNotes[/TD]
[TD="width: 133"]RpayNotes[/TD]
[TD="width: 143"]OffAccNotes[/TD]
[TD="width: 137"]ReAccNotes[/TD]
[TD="width: 134"]ReErrNotes[/TD]
[TD="width: 164"]AmtNotes[/TD]
[TD="width: 138"]ErrAmtNotes[/TD]
[TD="width: 173"]ICNotes[/TD]
[TD="width: 169"]DmetNotes[/TD]
[TD="width: 94"]StatusNotes[/TD]
[TD="width: 118"]ResAccuteNotes[/TD]
[TD="width: 143"]BenaccuNotes[/TD]
[TD="width: 152"]PETNotes[/TD]
[TD="width: 102"]ComANotes[/TD]
[TD="width: 162"]AuNotes[/TD]
[TD="width: 90"]CplanNotes[/TD]
[TD="width: 134"]DMWUNotes[/TD]
[TD="width: 126"]SUIONotes[/TD]
[TD="width: 145"]SalPreNotes[/TD]
[TD="width: 132"]PdatNotes[/TD]
[TD="width: 66"]Item[/TD]
[/TR]
[TR]
[TD]4567678[/TD]
[TD]MH[/TD]
[TD]Yes[/TD]
[TD]No - Correction Needed[/TD]
[TD]N/A[/TD]
[TD]No - Correction Needed[/TD]
[TD]No - Correction Needed[/TD]
[TD]No - Correction Not Needed[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]No - Correction Needed[/TD]
[TD][/TD]
[TD="align: right"]1000000[/TD]
[TD="align: right"]200000[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]No - Correction Needed[/TD]
[TD]N/A[/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]N/A[/TD]
[TD]Yes[/TD]
[TD]N/A[/TD]
[TD]No - Correction Not Needed[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]No - Correction Needed[/TD]
[TD]No - Correction Not Needed[/TD]
[TD]No - Correction Not Needed[/TD]
[TD="align: right"]1/30/2019[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD]dgdd[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Item[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]67890[/TD]
[TD="bgcolor: transparent"]SG[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent, align: right"]456667[/TD]
[TD="bgcolor: transparent, align: right"]500000[/TD]
[TD="bgcolor: transparent, align: right"]10000[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent, align: right"]1/16/2019[/TD]
[TD="bgcolor: transparent"]No[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]fgfgdgdgd[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]​bzdb[/TD]
[TD="bgcolor: transparent"]xb​[/TD]
[TD="bgcolor: transparent"]fbxb​[/TD]
[TD="bgcolor: transparent"]xb​[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]​eytsghsfth[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]​fgfbxb[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]fbxbb​[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]bbxb​[/TD]
[TD="bgcolor: transparent"]xfbxb​[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]​fxgxfxh[/TD]
[TD="bgcolor: transparent"]fbxxfb​[/TD]
[TD="bgcolor: transparent"]Item[/TD]
[/TR]
[TR]
[TD]45678[/TD]
[TD]CL[/TD]
[TD]Yes[/TD]
[TD]No - Correction Needed[/TD]
[TD]No - Correction Needed[/TD]
[TD]No - Correction Not Needed[/TD]
[TD]N/A[/TD]
[TD]No - Correction Needed[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]N/A[/TD]
[TD]Yes[/TD]
[TD]No - Correction Needed[/TD]
[TD][/TD]
[TD="align: right"]1500000[/TD]
[TD="align: right"]200000[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]N/A[/TD]
[TD]No - Correction Needed[/TD]
[TD][/TD]
[TD]No - Correction Not Needed[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]N/A[/TD]
[TD]No - Correction Needed[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]No - Correction Needed[/TD]
[TD]No - Correction Not Needed[/TD]
[TD]No - Correction Not Needed[/TD]
[TD="align: right"]2/13/2019[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD]cvddfg[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Item[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]45678[/TD]
[TD="bgcolor: transparent"]DG[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]700000[/TD]
[TD="bgcolor: transparent, align: right"]50000[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent, align: right"]8/14/2019[/TD]
[TD="bgcolor: transparent"]No[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]cxvxcvxc[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Item[/TD]
[/TR]
[TR]
[TD]45678[/TD]
[TD]DL[/TD]
[TD]Yes
[/TD]
[TD]No - Correction Not Needed[/TD]
[TD]N/A[/TD]
[TD]No - Correction Not Needed[/TD]
[TD]No - Correction Not Needed[/TD]
[TD]No - Correction Needed[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]N/A[/TD]
[TD]No - Correction Not Needed[/TD]
[TD][/TD]
[TD="align: right"]750000[/TD]
[TD="align: right"]10000[/TD]
[TD]N/A[/TD]
[TD]Yes[/TD]
[TD]No - Correction Needed[/TD]
[TD]No - Correction Needed[/TD]
[TD][/TD]
[TD]No - Correction Not Needed[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]No - Correction Needed[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]No - Correction Needed[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD="align: right"]4/16/2020[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD] gdfhh[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Item[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]45678[/TD]
[TD="bgcolor: transparent"]GS[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]300000[/TD]
[TD="bgcolor: transparent, align: right"]2000[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent, align: right"]9/24/2020[/TD]
[TD="bgcolor: transparent"]No[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]gdfgg[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Item[/TD]
[/TR]
[TR]
[TD]56789[/TD]
[TD]MB[/TD]
[TD]Yes[/TD]
[TD]No - Correction Needed[/TD]
[TD]N/A[/TD]
[TD]No - Correction Not Needed[/TD]
[TD]N/A[/TD]
[TD]No - Correction Needed[/TD]
[TD]Yes[/TD]
[TD]N/A[/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]No - Correction Needed[/TD]
[TD]Yes[/TD]
[TD]No - Correction Needed[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]600000[/TD]
[TD="align: right"]20000[/TD]
[TD]No - Correction Not Needed[/TD]
[TD]No - Correction Not Needed[/TD]
[TD]No - Correction Not Needed[/TD]
[TD]No - Correction Needed[/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]No - Correction Needed[/TD]
[TD]No - Correction Needed[/TD]
[TD]No - Correction Needed[/TD]
[TD]No - Correction Not Needed[/TD]
[TD]Yes[/TD]
[TD]No - Correction Not Needed[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]Yes[/TD]
[TD]No - Correction Needed[/TD]
[TD]No - Correction Not Needed[/TD]
[TD="align: right"]2/4/2021[/TD]
[TD]No[/TD]
[TD][/TD]
[TD]sdgdsgsd[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Item[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]234567[/TD]
[TD="bgcolor: transparent"]CL[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent, align: right"]1000000[/TD]
[TD="bgcolor: transparent, align: right"]50000[/TD]
[TD="bgcolor: transparent, align: right"]60000[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent, align: right"]1/15/2019[/TD]
[TD="bgcolor: transparent"]No[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]sdgsdg[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]​comments[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]​Comment[/TD]
[TD="bgcolor: transparent"]​Comment
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]​Comments[/TD]
[TD="bgcolor: transparent"]​Comments[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]​[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]​comments[/TD]
[TD="bgcolor: transparent"]​comments[/TD]
[TD="bgcolor: transparent"]​comments[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]​COmment[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]​comments[/TD]
[TD="bgcolor: transparent"]​comments[/TD]
[TD="bgcolor: transparent"]​Comments[/TD]
[TD="bgcolor: transparent"]​Comments[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Item[/TD]
[/TR]
[TR]
[TD]692877[/TD]
[TD]NB[/TD]
[TD]Yes[/TD]
[TD]No - Correction Not Needed[/TD]
[TD]No - Correction Needed[/TD]
[TD]N/A[/TD]
[TD]Yes[/TD]
[TD]No - Correction Needed[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]N/A[/TD]
[TD]Yes[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]957.19[/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD="align: right"]1/21/2019[/TD]
[TD]No[/TD]
[TD][/TD]
[TD]sdgsdgs[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]​date corrected to reflect earlier onset[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]i:0#.w|sic\kspierin[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]ncm consult needed[/TD]
[TD][/TD]
[TD][/TD]
[TD]Item[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]00325698[/TD]
[TD="bgcolor: transparent"]TG[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]1/15/2019[/TD]
[TD="bgcolor: transparent"]No[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]ertery[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Item[/TD]
[/TR]
[TR]
[TD]693008[/TD]
[TD]NB[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]Yes[/TD]
[TD]N/A[/TD]
[TD]No - Correction Needed[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]No - Correction Needed[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1000[/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]No - Correction Needed[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]Yes[/TD]
[TD]N/A[/TD]
[TD]No - Correction Needed[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]No - Correction Needed[/TD]
[TD]N/A[/TD]
[TD]No - Correction Not Needed[/TD]
[TD="align: right"]1/23/2019[/TD]
[TD]No[/TD]
[TD][/TD]
[TD]eryery[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]​disability date should be 10.1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Item[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]00323333[/TD]
[TD="bgcolor: transparent"]TG
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]1/8/2019[/TD]
[TD="bgcolor: transparent"]No[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]eryery[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Item[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1125"]
<colgroup><col width="166" style="width: 125pt;" span="2"> <col width="166" style="width: 125pt;" span="7"> <tbody>[TR]
[TD="width: 166, bgcolor: transparent"]


Report (sheet#2)

[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]

[/TR]
[TR]
[TD="width: 166, bgcolor: yellow"]PREFILLED FIELD[/TD]
[TD="width: 166, bgcolor: yellow"]PREFILLED FIELD[/TD]
[TD="width: 166, bgcolor: yellow"]PREFILLED FIELD[/TD]
[TD="width: 166, bgcolor: yellow"]PREFILLED FIELD[/TD]
[TD="width: 166, bgcolor: yellow"]Comes from Raw Data[/TD]
[TD="width: 166, bgcolor: yellow"]Comes from Raw Data[/TD]
[TD="width: 166, bgcolor: yellow"]Comes from Raw Data[/TD]
[TD="width: 166, bgcolor: yellow"]Comes from Raw Data[/TD]
[TD="width: 166, bgcolor: yellow"]Comes from Raw Data[/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Question ID[/TD]
[TD="width: 166, bgcolor: transparent"]Category[/TD]
[TD="width: 166, bgcolor: transparent"]QUESTIONS[/TD]
[TD="width: 166, bgcolor: transparent"]list field[/TD]
[TD="width: 166, bgcolor: #5B9BD5"]Name[/TD]
[TD="width: 166, bgcolor: #5B9BD5"]Correctable/Not Correctable[/TD]
[TD="width: 166, bgcolor: #5B9BD5"]ID[/TD]
[TD="width: 166, bgcolor: #5B9BD5"]Notes[/TD]
[TD="width: 166, bgcolor: #5B9BD5"]CorrectionMade[/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.2[/TD]
[TD="width: 166, bgcolor: transparent"]TD[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]TND[/TD]
[TD="bgcolor: transparent"]MH[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]4567678[/TD]
[TD="bgcolor: transparent"]dgdd[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.2[/TD]
[TD="width: 166, bgcolor: transparent"]TD[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]TND[/TD]
[TD="bgcolor: transparent"]SG[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]67890[/TD]
[TD="bgcolor: transparent"]fgfgdgdgd[/TD]
[TD="bgcolor: transparent"]No[/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.2[/TD]
[TD="width: 166, bgcolor: transparent"]TD[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]TND[/TD]
[TD="bgcolor: transparent"]CL[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]45678[/TD]
[TD="bgcolor: transparent"]cvddfg[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.2[/TD]
[TD="width: 166, bgcolor: transparent"]TD[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]TND[/TD]
[TD="bgcolor: transparent"]DL[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]45678[/TD]
[TD="bgcolor: transparent"] gdfhh[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.2[/TD]
[TD="width: 166, bgcolor: transparent"]TD[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]TND[/TD]
[TD="bgcolor: transparent"]GS[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]45678[/TD]
[TD="bgcolor: transparent"]gdfgg[/TD]
[TD="bgcolor: transparent"]No[/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.2[/TD]
[TD="width: 166, bgcolor: transparent"]TD[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]TND[/TD]
[TD="bgcolor: transparent"]MB[/TD]
[TD="bgcolor: transparent"]No - Correction Needed[/TD]
[TD="bgcolor: transparent"]56789[/TD]
[TD="bgcolor: transparent"]sdgdsgsd[/TD]
[TD="bgcolor: transparent"]No[/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.2[/TD]
[TD="width: 166, bgcolor: transparent"]TD[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]TND[/TD]
[TD="bgcolor: transparent"]NB[/TD]
[TD="bgcolor: transparent"]No - Correction Not Needed[/TD]
[TD="bgcolor: transparent"]692877[/TD]
[TD="bgcolor: transparent"]sdgsdgs[/TD]
[TD="bgcolor: transparent"]No[/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.3[/TD]
[TD="width: 166, bgcolor: transparent"]TD[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]STW[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.3[/TD]
[TD="width: 166, bgcolor: transparent"]TD[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]STW[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.3[/TD]
[TD="width: 166, bgcolor: transparent"]TD[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]STW[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.3[/TD]
[TD="width: 166, bgcolor: transparent"]TD[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]STW[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.3[/TD]
[TD="width: 166, bgcolor: transparent"]TD[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]STW[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.3[/TD]
[TD="width: 166, bgcolor: transparent"]TD[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]STW[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.3[/TD]
[TD="width: 166, bgcolor: transparent"]TD[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]STW[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.3[/TD]
[TD="width: 166, bgcolor: transparent"]TD[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]STW[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.5[/TD]
[TD="width: 166, bgcolor: transparent"]DA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]DecAcc[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"]DA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]DecAcc[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"]DA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]DecAcc[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.6[/TD]
[TD="width: 166, bgcolor: transparent"]DA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]ConPro[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.7[/TD]
[TD="width: 166, bgcolor: transparent"]DA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]CoD[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.8[/TD]
[TD="width: 166, bgcolor: transparent"]PFA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]BegDat[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.9[/TD]
[TD="width: 166, bgcolor: transparent"]PFA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]Duration[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"]PFA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]Duration[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.10[/TD]
[TD="width: 166, bgcolor: transparent"]PFA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]CP[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"]PFA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]CP[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.12[/TD]
[TD="width: 166, bgcolor: transparent"]PFA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]FIMF[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"]PFA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]FIMF[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.13[/TD]
[TD="width: 166, bgcolor: transparent"]PFA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]MBP[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"]PFA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]Rpay[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.14[/TD]
[TD="width: 166, bgcolor: transparent"]PFA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]OffAcc[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"]PFA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]OffAcc[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 166, bgcolor: transparent"]Q.15[/TD]
[TD="width: 166, bgcolor: transparent"]PFA[/TD]
[TD="width: 166, bgcolor: transparent"]Detailed Question Description[/TD]
[TD="bgcolor: transparent"]ReAcc[/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[TD="width: 166, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
Try this for all the questions

Code: 
Sub Fill_Report()
    Dim ws1 As Worksheet, ws2 As Worksheet
    Dim answer As Range
    Dim q As Long, j As Long
    
    Application.ScreenUpdating = False
    
    Set ws1 = Sheets("Rawdata")
    Set ws2 = Sheets("Report")
    
    'clear old report data
    ws2.Rows("3:" & Rows.Count).ClearContents
    ws2.ListObjects("Report").Resize Range("$A$2:$I$3")
    
    q = 1   'Initial question number
    j = 3   'Initial row target
    
    'Column C initial question To column AR end question
    For i = Columns("C").Column To Columns("AR").Column
        For Each answer In ws1.Range("Table_Rawdata[" & ws1.Cells(1, i).Value & "]").Cells
            If answer.Value Like "No*" Then
                ws2.Cells(j, "A").Value = "Q." & q                                                      'question ID
                ws2.Cells(j, "B").Value = "Category"                                                    'category
                ws2.Cells(j, "C").Value = "Deatiled Question Description"                               'question
                ws2.Cells(j, "D").Value = ws1.Cells(1, i).Value                                         'list field
                ws2.Cells(j, "E").Value = ws1.Cells(answer.Row, Range("Table_Rawdata[[Name]]").Column)  'name
                ws2.Cells(j, "F").Value = answer.Value                                                  'Correctable/Not Correctable
                ws2.Cells(j, "G").Value = ws1.Cells(answer.Row, Range("Table_Rawdata[[ID]]").Column)    'ID
                ws2.Cells(j, "H").Value = ws1.Cells(answer.Row, Range("Table_Rawdata[[TNDNotes]]").Column)  'Notes
                ws2.Cells(j, "I").Value = ws1.Cells(answer.Row, Range("Table_Rawdata[[CorrectionsMade]]").Column)   'CorrectionMade
                j = j + 1
            End If
        Next
        q = q + 1
    Next
    
    Application.ScreenUpdating = True
    
    MsgBox "End"
End Sub
 
Upvote 0
Thanks for the quick reply, really appreciate your help. I ran the code and it works till ws2.row("3:" & Rows.Count).ClearContents. After that it gives me a "Run time error '9' Subscript out of range err"







DanteAmor said:
Try this for all the questions

Code: 
Sub Fill_Report()
    Dim ws1 As Worksheet, ws2 As Worksheet
    Dim answer As Range
    Dim q As Long, j As Long
    
    Application.ScreenUpdating = False
    
    Set ws1 = Sheets("Rawdata")
    Set ws2 = Sheets("Report")
    
    'clear old report data
    ws2.Rows("3:" & Rows.Count).ClearContents
    ws2.ListObjects("Report").Resize Range("$A$2:$I$3")
    
    q = 1   'Initial question number
    j = 3   'Initial row target
    
    'Column C initial question To column AR end question
    For i = Columns("C").Column To Columns("AR").Column
        For Each answer In ws1.Range("Table_Rawdata[" & ws1.Cells(1, i).Value & "]").Cells
            If answer.Value Like "No*" Then
                ws2.Cells(j, "A").Value = "Q." & q                                                      'question ID
                ws2.Cells(j, "B").Value = "Category"                                                    'category
                ws2.Cells(j, "C").Value = "Deatiled Question Description"                               'question
                ws2.Cells(j, "D").Value = ws1.Cells(1, i).Value                                         'list field
                ws2.Cells(j, "E").Value = ws1.Cells(answer.Row, Range("Table_Rawdata[[Name]]").Column)  'name
                ws2.Cells(j, "F").Value = answer.Value                                                  'Correctable/Not Correctable
                ws2.Cells(j, "G").Value = ws1.Cells(answer.Row, Range("Table_Rawdata[[ID]]").Column)    'ID
                ws2.Cells(j, "H").Value = ws1.Cells(answer.Row, Range("Table_Rawdata[[TNDNotes]]").Column)  'Notes
                ws2.Cells(j, "I").Value = ws1.Cells(answer.Row, Range("Table_Rawdata[[CorrectionsMade]]").Column)   'CorrectionMade
                j = j + 1
            End If
        Next
        q = q + 1
    Next
    
    Application.ScreenUpdating = True
    
    MsgBox "End"
End Sub
Click to expand...
 
Upvote 0
Remove this line and try again

Code: 
ws2.ListObjects("Report").Resize Range("$A$2:$I$3")
 
Upvote 0
sorry, the image did not come through.

Run-time error'1004' Method 'Rang' of Object'_Worksheet' failed on line

For Each answer In ws1.Range("Table_Rawdata[" & ws1.Cells(1, i).Value & "]").Cells
 
Upvote 0
Try this,

Sorry but, I'm trying to guess where your "Table_Rawdata" and "Report" tables are. If you have another problem, You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

Code: 
Sub Fill_Report()
    Dim ws1 As Worksheet, ws2 As Worksheet
    Dim answer As Range
    Dim q As Long, j As Long, initial As Long
    
    Application.ScreenUpdating = False
    
    Set ws1 = Sheets("Rawdata")
    Set ws2 = Sheets("Report")
    
    'clear old report data
    ws2.Rows("3:" & Rows.Count).ClearContents
    'ws2.ListObjects("Report").Resize Range("$A$2:$I$3")
    
    q = 1   'Initial question number
    j = 3   'Initial row target
    
    'Column C initial question To column AR end question
    initial = ws1.Range("Table_Rawdata[#All]").Cells(1, 1).Row
    For i = Columns("C").Column To Columns("AR").Column
        For Each answer In ws1.Range("Table_Rawdata[" & ws1.Cells(initial, i).Value & "]").Cells
            If answer.Value Like "No*" Then
                ws2.Cells(j, "A").Value = "Q." & q                                                      'question ID
                ws2.Cells(j, "B").Value = "Category"                                                    'category
                ws2.Cells(j, "C").Value = "Deatiled Question Description"                               'question
                ws2.Cells(j, "D").Value = ws1.Cells(1, i).Value                                         'list field
                ws2.Cells(j, "E").Value = ws1.Cells(answer.Row, Range("Table_Rawdata[[Name]]").Column)  'name
                ws2.Cells(j, "F").Value = answer.Value                                                  'Correctable/Not Correctable
                ws2.Cells(j, "G").Value = ws1.Cells(answer.Row, Range("Table_Rawdata[[ID]]").Column)    'ID
                ws2.Cells(j, "H").Value = ws1.Cells(answer.Row, Range("Table_Rawdata[[TNDNotes]]").Column)  'Notes
                ws2.Cells(j, "I").Value = ws1.Cells(answer.Row, Range("Table_Rawdata[[CorrectionsMade]]").Column)   'CorrectionMade
                j = j + 1
            End If
        Next
        q = q + 1
    Next
    
    Application.ScreenUpdating = True
    
    MsgBox "End"
End Sub
 
Upvote 0
In your original code the name of your table is "Table_Rawdata" and now it is "Table1".
I have problems with the ID column, but it is already solved.
Try this:

Code: 
Sub Fill_Report()
    Dim ws1 As Worksheet, ws2 As Worksheet
    Dim answer As Range
    Dim q As Long, j As Long, initial As Long
    
    Application.ScreenUpdating = False
    
    Set ws1 = Sheets("Rawdata")
    Set ws2 = Sheets("Report")
    
    'clear old report data
    ws2.Rows("3:" & Rows.Count).ClearContents
    'ws2.ListObjects("Report").Resize Range("$A$2:$I$3")
    
    q = 1   'Initial question number
    j = 3   'Initial row target
    
    'Column C initial question To column AR end question
    initial = ws1.Range("[COLOR=#ff0000]Table1[/COLOR][#All]").Cells(1, 1).Row
    For i = Columns("C").Column To Columns("AR").Column
        For Each answer In ws1.Range("[COLOR=#ff0000]Table1[/COLOR][" & ws1.Cells(initial, i).Value & "]").Cells
            If answer.Value Like "No*" Then
                ws2.Cells(j, "A").Value = "Q." & q                                                      'question ID
                ws2.Cells(j, "B").Value = "Category"                                                    'category
                ws2.Cells(j, "C").Value = "Deatiled Question Description"                               'question
                ws2.Cells(j, "D").Value = ws1.Cells(1, i).Value                                         'list field
                ws2.Cells(j, "E").Value = ws1.Cells(answer.Row, Range("Table1[[Name]]").Column)  'name
                ws2.Cells(j, "F").Value = answer.Value                                                  'Correctable/Not Correctable
                ws2.Cells(j, "G").Value = [COLOR=#ff0000]ws1.Cells(answer.Row, 1)    'ID[/COLOR]
                ws2.Cells(j, "H").Value = ws1.Cells(answer.Row, Range("Table1[[TNDNotes]]").Column)  'Notes
                ws2.Cells(j, "I").Value = ws1.Cells(answer.Row, Range("Table1[[CorrectionsMade]]").Column)   'CorrectionMade
                j = j + 1
            End If
        Next
        q = q + 1
    Next
    
    Application.ScreenUpdating = True
    
    MsgBox "End"
End Sub

Review the file below
https://www.dropbox.com/s/4iur739oaantsnk/Correrrreport dam.xlsm?dl=0
 
Last edited:
Upvote 0
Many, many thanks! I will try it out on first thing on Tuesday. I will keep you.posted!



DanteAmor said:
In your original code the name of your table is "Table_Rawdata" and now it is "Table1".
I have problems with the ID column, but it is already solved.
Try this:

Code: 
Sub Fill_Report()
    Dim ws1 As Worksheet, ws2 As Worksheet
    Dim answer As Range
    Dim q As Long, j As Long, initial As Long
    
    Application.ScreenUpdating = False
    
    Set ws1 = Sheets("Rawdata")
    Set ws2 = Sheets("Report")
    
    'clear old report data
    ws2.Rows("3:" & Rows.Count).ClearContents
    'ws2.ListObjects("Report").Resize Range("$A$2:$I$3")
    
    q = 1   'Initial question number
    j = 3   'Initial row target
    
    'Column C initial question To column AR end question
    initial = ws1.Range("[COLOR=#ff0000]Table1[/COLOR][#All]").Cells(1, 1).Row
    For i = Columns("C").Column To Columns("AR").Column
        For Each answer In ws1.Range("[COLOR=#ff0000]Table1[/COLOR][" & ws1.Cells(initial, i).Value & "]").Cells
            If answer.Value Like "No*" Then
                ws2.Cells(j, "A").Value = "Q." & q                                                      'question ID
                ws2.Cells(j, "B").Value = "Category"                                                    'category
                ws2.Cells(j, "C").Value = "Deatiled Question Description"                               'question
                ws2.Cells(j, "D").Value = ws1.Cells(1, i).Value                                         'list field
                ws2.Cells(j, "E").Value = ws1.Cells(answer.Row, Range("Table1[[Name]]").Column)  'name
                ws2.Cells(j, "F").Value = answer.Value                                                  'Correctable/Not Correctable
                ws2.Cells(j, "G").Value = [COLOR=#ff0000]ws1.Cells(answer.Row, 1)    'ID[/COLOR]
                ws2.Cells(j, "H").Value = ws1.Cells(answer.Row, Range("Table1[[TNDNotes]]").Column)  'Notes
                ws2.Cells(j, "I").Value = ws1.Cells(answer.Row, Range("Table1[[CorrectionsMade]]").Column)   'CorrectionMade
                j = j + 1
            End If
        Next
        q = q + 1
    Next
    
    Application.ScreenUpdating = True
    
    MsgBox "End"
End Sub

Review the file below
https://www.dropbox.com/s/4iur739oaantsnk/Correrrreport dam.xlsm?dl=0
Click to expand...
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
645
smozgur
smozgur
C
  • Question Question
Create code that sends emails and creates a log
Replies
1
Views
315
cokeoverpepsi123
C
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C
M
  • Question Question
Help with FilterXML formula
Replies
0
Views
2K
montex01
M
E
  • Question Question
Can anyone help me get my VBA code working? I have spent tons of time but can't quite fix it.
Replies
3
Views
3K
profray
P

Forum statistics

Threads
1,224,818
Messages
6,181,152
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top