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]
 
Sort by date Sort by votes

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Hi Dante,
sorry to bother you again. One small issue. The "Notes" column on Report sheet is returning only TND notes. I tried to change the range instead of referring to a "TNDNotes".column,
but it is not accepting it. Right now, the report gives me pretty much everything I want except for Notes column. I would like TNDNotes displayed next to TND list field, STW notes displayed next to
STW list field etc...
Thanks!!
 
Upvote 0
Change name TNDNotes by the new name, or put the number of column e.g.:


ws2.Cells(j, "H").Value = ws1.Cells(answer.Row, 8)


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("Table1[#All]").Cells(1, 1).Row
    For i = Columns("C").Column To Columns("AR").Column
        For Each answer In ws1.Range("Table1[" & 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 = ws1.Cells(answer.Row, 1)    'ID
                ws2.Cells(j, "H").Value = ws1.Cells(answer.Row, Range("Table1[[[COLOR=#ff0000]TNDNotes[/COLOR]]]").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[CODE]
[/CODE]
 
Upvote 0
Once again, thanks for the quick reply. I think my last message was little confusing. I did not provide a good explanation of what I was trying to accomplish.
Sorry about that.
So, the code that I had posted originally was meant to run 32 times for each question separately and the line below would have worked perfectly in that case because we knew what question we wanted to pull the information from. But thanks to your modified version I don't have to do that anymore. It saved me a lot of time and effort. Its now looking for wild card "no*" and fills out all the fields from Table1 and it is basically looking for all 32 questions at the same time rather than individually.

All the columns from "Question ID" till "ID" and "Corrections Made" is working perfectly on the Report, except for "Notes" column.
Other columns are easier because they are all fixed values but Notes column is not fixed. Here I would like to look the for the "No*" and fill out the corresponding NOTE in the notes column.

Issue is that "NO*" could appear in any question randomly, which impacts ONLY the "Notes" col in the Report. The code below will pull only notes from TND but if for some reason
the first "No*" appears in some other question then this line won't work. or replacing with a different name or number won't help because we don't know which notes to pull from.

ws2.Cells(j, "H").Value = ws1.Cells(answer.Row, Range("Table1[[TNDNotes]]").Column

so instead of pulling information from this specific column from Table1,it should be a range(only for "Notes"), I think.

For instance, if the first "No*" was found in "DecAcc" (Table1, row 2, Col F), then it would search for all NOTES from col AU to Col BY and pull "DecAccNotes"(Table1, row2, col AX), but if it was found in "ConPro" (Table1, row 3, col G) then
the it will do a search again and pull information from "ConProNotes" (table1, row3, col AY).

I apologize if this is confusing. Please let me know if this helps you understand the issue or if you need more clarification.

Thanks!
https://app.box.com/s/k331pem8w3jypbw3tux2xz65rty7zkwi
 
Upvote 0
Please discard the last post. I figured it out. The solution is a combination of what you had suggested earlier and changing the way row was displayed. Thanks!!


Modified code line - ws2.Cells(j, "H").Value = ws1.Cells(answer.Row, i + 7).Value
 
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