Need help creating VBA to pull data from two worksheets into one worksheet

DiamondNate · Oct 13, 2014

First and foremost thank you for your help.

I have two forms of data, tabs 'SF Notes Added' and 'SFID-CID', that I need to combine into one worksheet, tab 'Notes to be Uploaded', for my records.

The first header in the 'Notes to be Uploaded' tab is Company ID. This would be a vlookup of the value in A4 'SF Notes Added' against 'SFID-CID'.

The second header 'Written By' is always 'nross'

The third header 'Written Date' will be the date in 'SF Notes Added' associated with the ID.

The forth header 'written note' is going to be a combination of cells based on the merged cells in 'SF Notes Added' (column d - column e: column F values separated by; for each row involved in the merged cells from column D)

Here's an example of the final output I'm looking for

[TABLE="width: 345"]
<tbody>[TR]
[TD]company_id[/TD]
[TD] written_by[/TD]
[TD] written_date[/TD]
[TD] written_note[/TD]
[/TR]
[TR]
[TD="align: right"]311177[/TD]
[TD][/TD]
[TD="align: right"]10/7/2014[/TD]
[TD]Services - Canelled: Sponsorhips Only - removed: Sponsorhips Only - removed; Maintenance/Service Providers (1); Professional Services (1); Independent Installers (1)[/TD]
[/TR]
</tbody>[/TABLE]

Here is 'SF Notes Added' tab
[TABLE="width: 706"]
<tbody>[TR]
[TD]Account ID[/TD]
[TD]Date[/TD]
[TD]Company / Account[/TD]
[TD]Activity Type[/TD]
[TD]Subject[/TD]
[TD]Full Comments[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Assigned: NR (14 records)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]001i000000N9cua[/TD]
[TD]10/7/2014[/TD]
[TD]MediaCentric Integration Inc.[/TD]
[TD]Services[/TD]
[TD]Cancelled[/TD]
[TD]Sponsorhips Only - removed:[/TD]
[/TR]
[TR]
[TD]Maintenance/Service Providers (1)[/TD]
[/TR]
[TR]
[TD]Professional Services (1)[/TD]
[/TR]
[TR]
[TD]Independent Installers (1)[/TD]
[/TR]
[TR]
[TD]001i000000N9cvH[/TD]
[TD]10/7/2014[/TD]
[TD]Immedia Integrated Technologies[/TD]
[TD]Treatment[/TD]
[TD]Redesign[/TD]
[TD]Match new look and feel of company site.[/TD]
[/TR]
[TR]
[TD]001i000000N9cvH[/TD]
[TD]10/7/2014[/TD]
[TD]Immedia Integrated Technologies[/TD]
[TD]Treatment[/TD]
[TD]Logo[/TD]
[TD]Uploaded new company Logo[/TD]
[/TR]
[TR]
[TD]001i000000pS3ok[/TD]
[TD]10/8/2014[/TD]
[TD]NewTek, Inc.[/TD]
[TD]Products[/TD]
[TD]New[/TD]
[TD]TriCaster Mini HD-4i[/TD]
[/TR]
[TR]
[TD]TriCaster Mini HD-4[/TD]
[/TR]
[TR]
[TD]TriCaster Mini Control Surface[/TD]
[/TR]
[TR]
[TD]001i000000pS3mf[/TD]
[TD]10/10/2014[/TD]
[TD]Atlona Technologies[/TD]
[TD]Media Center[/TD]
[TD]Video(s)[/TD]
[TD]AT-UHD-CLSO-612 Basic IO Front Panel[/TD]
[/TR]
[TR]
[TD]AT-HD-M2C features[/TD]
[/TR]
[TR]
[TD]001i000000pS3nz[/TD]
[TD]10/10/2014[/TD]
[TD]Imagine Communications[/TD]
[TD]Media Center[/TD]
[TD]Video(s)[/TD]
[TD]WEBINAR: Future proofing Playout Operations[/TD]
[/TR]
[TR]
[TD]IBC2014: Redefining the Industry with Playout in the Cloud[/TD]
[/TR]
[TR]
[TD]LandmarkOSI™ Traffic & Billing | Same Day Program Changes[/TD]
[/TR]
[TR]
[TD]LandmarkOSI™ Traffic & Billing | Late Ads Made Easy[/TD]
[/TR]
[TR]
[TD]LandmarkOSI™ Traffic & Billing | Reducing Make Goods[/TD]
[/TR]
[TR]
[TD]LandmarkOSI™ Traffic & Billing | Making Quick Copy Changes[/TD]
[/TR]
[TR]
[TD]IBC2014 Highlights: Relive the excitement![/TD]
[/TR]
[TR]
[TD]ImagineLIVE! Europe: Eight visionaries. One energy-packed event.[/TD]
[/TR]
[TR]
[TD]IBC2014 Keynote: Assessing the Health of Broadcast[/TD]
[/TR]
[TR]
[TD]001i000000pS3mX[/TD]
[TD]10/10/2014[/TD]
[TD]AMX[/TD]
[TD]Media Center[/TD]
[TD]Video(s)[/TD]
[TD]TUTORIAL: How to Use Screen Mirroring with Enzo[/TD]
[/TR]
[TR]
[TD]On Screen! Display Content Wirelessly from Your Device in Seconds[/TD]
[/TR]
[TR]
[TD]AMX Campus Explorer Education App Delivers Interactive AV Planning to Assist Technology Managers[/TD]
[/TR]
[TR]
[TD]001i000000pS3pI[/TD]
[TD]10/10/2014[/TD]
[TD]TeamBoard[/TD]
[TD]Media Center[/TD]
[TD]Video(s)[/TD]
[TD]TeamBoard IFP Overview[/TD]
[/TR]
[TR]
[TD]001i000000pS3nB[/TD]
[TD]10/10/2014[/TD]
[TD]Chief[/TD]
[TD]Media Center[/TD]
[TD]Video(s)[/TD]
[TD]Canada Road Show Tour[/TD]
[/TR]
[TR]
[TD]001i000000pS3nG[/TD]
[TD]10/10/2014[/TD]
[TD]Contemporary Research[/TD]
[TD]Media Center[/TD]
[TD]Press Release(s)[/TD]
[TD]Doug’s Q-Tips – What sources will work with QMOD’s HDMI input?[/TD]
[/TR]
[TR]
[TD]001i000000N9d3r[/TD]
[TD]10/10/2014[/TD]
[TD]Emcore Corporation[/TD]
[TD]Treatment[/TD]
[TD]Contact Us[/TD]
[TD]Second time I'm having Dev remove their contact us. Still appearing on product detail pages.[/TD]
[/TR]
[TR]
[TD]001i000000pS3p0[/TD]
[TD]10/10/2014[/TD]
[TD]Ricoh Corporation[/TD]
[TD]Media Center[/TD]
[TD]Press Release(s)[/TD]
[TD]New Ricoh Meeting Room Services Help Companies Improve The Way They Manage Their Workspace[/TD]
[/TR]
[TR]
[TD]001i000000pS3pd[/TD]
[TD]10/10/2014[/TD]
[TD]Williams Sound[/TD]
[TD]Media Center[/TD]
[TD]Press Release(s)[/TD]
[TD]Williams Sound sponsors Veterans Scholarship Program[/TD]
[/TR]
[TR]
[TD]001i000000N9cae[/TD]
[TD]10/10/2014[/TD]
[TD]Theatrical Services & Supplies, Inc.[/TD]
[TD]Services[/TD]
[TD]Cancelled[/TD]
[TD]Remove AV Service Ad[/TD]
[/TR]
[TR]
[TD]Design/Build Contractors (1)[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Grand Totals (14 records)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Here is 'SFID-CID' tab
[TABLE="width: 230"]
<tbody>[TR]
[TD]Account ID[/TD]
[TD]Company ID[/TD]
[/TR]
[TR]
[TD]001i000000cMfIb[/TD]
[TD="align: right"]313170[/TD]
[/TR]
[TR]
[TD]001i000000ePzjl[/TD]
[TD="align: right"]313030[/TD]
[/TR]
[TR]
[TD]001i000000ePzkz[/TD]
[TD="align: right"]204700[/TD]
[/TR]
[TR]
[TD]001i000000ePzl5[/TD]
[TD="align: right"]203875[/TD]
[/TR]
[TR]
[TD]001i000000ePzl8[/TD]
[TD="align: right"]306535[/TD]
[/TR]
[TR]
[TD]001i000000ePzlC[/TD]
[TD="align: right"]313098[/TD]
[/TR]
[TR]
[TD]001i000000ePzlO[/TD]
[TD="align: right"]310949[/TD]
[/TR]
[TR]
[TD]001i000000ePzlX[/TD]
[TD="align: right"]205592[/TD]
[/TR]
[TR]
[TD]001i000000ePzm4[/TD]
[TD="align: right"]204715[/TD]
[/TR]
[TR]
[TD]001i000000eSNw3[/TD]
[TD="align: right"]313305[/TD]
[/TR]
[TR]
[TD]001i000000hkAtj[/TD]
[TD="align: right"]313310[/TD]
[/TR]
[TR]
[TD]001i000000N9ca0[/TD]
[TD="align: right"]202927[/TD]
[/TR]
[TR]
[TD]001i000000N9caa[/TD]
[TD="align: right"]308745[/TD]
[/TR]
[TR]
[TD]001i000000N9caB[/TD]
[TD="align: right"]206353[/TD]
[/TR]
[TR]
[TD]001i000000N9caC[/TD]
[TD="align: right"]205488[/TD]
[/TR]
[TR]
[TD]001i000000N9caD[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000N9caE[/TD]
[TD="align: right"]205229[/TD]
[/TR]
[TR]
[TD]001i000000N9cae[/TD]
[TD="align: right"]200719[/TD]
[/TR]
[TR]
[TD]001i000000N9caG[/TD]
[TD="align: right"]203939[/TD]
[/TR]
[TR]
[TD]001i000000N9caJ[/TD]
[TD="align: right"]205796[/TD]
[/TR]
[TR]
[TD]001i000000N9caK[/TD]
[TD="align: right"]307107[/TD]
[/TR]
[TR]
[TD]001i000000N9caO[/TD]
[TD="align: right"]205918[/TD]
[/TR]
[TR]
[TD]001i000000N9cas[/TD]
[TD="align: right"]203698[/TD]
[/TR]
[TR]
[TD]001i000000N9cau[/TD]
[TD="align: right"]310243[/TD]
[/TR]
[TR]
[TD]001i000000N9caX[/TD]
[TD="align: right"]301027[/TD]
[/TR]
[TR]
[TD]001i000000N9cb2[/TD]
[TD="align: right"]204996[/TD]
[/TR]
[TR]
[TD]001i000000N9cbF[/TD]
[TD="align: right"]206141[/TD]
[/TR]
[TR]
[TD]001i000000N9cbl[/TD]
[TD="align: right"]312914[/TD]
[/TR]
[TR]
[TD]001i000000N9cc6[/TD]
[TD="align: right"]203659[/TD]
[/TR]
[TR]
[TD]001i000000N9cc7[/TD]
[TD="align: right"]312664[/TD]
[/TR]
[TR]
[TD]001i000000N9cci[/TD]
[TD="align: right"]207596[/TD]
[/TR]
[TR]
[TD]001i000000N9ccz[/TD]
[TD="align: right"]205319[/TD]
[/TR]
[TR]
[TD]001i000000N9cd0[/TD]
[TD="align: right"]301660[/TD]
[/TR]
[TR]
[TD]001i000000N9cd1[/TD]
[TD="align: right"]301791[/TD]
[/TR]
[TR]
[TD]001i000000N9cdb[/TD]
[TD="align: right"]304618[/TD]
[/TR]
[TR]
[TD]001i000000N9cde[/TD]
[TD="align: right"]200215[/TD]
[/TR]
[TR]
[TD]001i000000N9cdV[/TD]
[TD="align: right"]204700[/TD]
[/TR]
[TR]
[TD]001i000000N9cdX[/TD]
[TD="align: right"]202897[/TD]
[/TR]
[TR]
[TD]001i000000N9cef[/TD]
[TD="align: right"]301003[/TD]
[/TR]
[TR]
[TD]001i000000N9ceh[/TD]
[TD="align: right"]200033[/TD]
[/TR]
[TR]
[TD]001i000000N9cer[/TD]
[TD="align: right"]203193[/TD]
[/TR]
[TR]
[TD]001i000000N9ceu[/TD]
[TD="align: right"]309166[/TD]
[/TR]
[TR]
[TD]001i000000N9cev[/TD]
[TD="align: right"]301054[/TD]
[/TR]
[TR]
[TD]001i000000N9cfE[/TD]
[TD="align: right"]205281[/TD]
[/TR]
[TR]
[TD]001i000000N9cfG[/TD]
[TD="align: right"]203804[/TD]
[/TR]
[TR]
[TD]001i000000N9cgE[/TD]
[TD="align: right"]308112[/TD]
[/TR]
[TR]
[TD]001i000000N9cgF[/TD]
[TD="align: right"]205195[/TD]
[/TR]
[TR]
[TD]001i000000N9cgG[/TD]
[TD="align: right"]300698[/TD]
[/TR]
[TR]
[TD]001i000000N9cgH[/TD]
[TD="align: right"]301539[/TD]
[/TR]
[TR]
[TD]001i000000N9cgZ[/TD]
[TD="align: right"]204725[/TD]
[/TR]
[TR]
[TD]001i000000N9chj[/TD]
[TD="align: right"]206016[/TD]
[/TR]
[TR]
[TD]001i000000N9cho[/TD]
[TD="align: right"]302451[/TD]
[/TR]
[TR]
[TD]001i000000N9chU[/TD]
[TD="align: right"]301182[/TD]
[/TR]
[TR]
[TD]001i000000N9ciG[/TD]
[TD="align: right"]311867[/TD]
[/TR]
[TR]
[TD]001i000000N9ciI[/TD]
[TD="align: right"]206017[/TD]
[/TR]
[TR]
[TD]001i000000N9ciS[/TD]
[TD="align: right"]203693[/TD]
[/TR]
[TR]
[TD]001i000000N9cja[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000N9ckN[/TD]
[TD="align: right"]310328[/TD]
[/TR]
[TR]
[TD]001i000000N9ckn[/TD]
[TD="align: right"]311455[/TD]
[/TR]
[TR]
[TD]001i000000N9cko[/TD]
[TD="align: right"]204786[/TD]
[/TR]
[TR]
[TD]001i000000N9ckr[/TD]
[TD="align: right"]300549[/TD]
[/TR]
[TR]
[TD]001i000000N9ckx[/TD]
[TD="align: right"]308942[/TD]
[/TR]
[TR]
[TD]001i000000N9cky[/TD]
[TD="align: right"]307323[/TD]
[/TR]
[TR]
[TD]001i000000N9clr[/TD]
[TD="align: right"]312266[/TD]
[/TR]
[TR]
[TD]001i000000N9cmP[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000N9cmQ[/TD]
[TD="align: right"]310227[/TD]
[/TR]
[TR]
[TD]001i000000N9cn5[/TD]
[TD="align: right"]203791[/TD]
[/TR]
[TR]
[TD]001i000000N9cnR[/TD]
[TD="align: right"]301080[/TD]
[/TR]
[TR]
[TD]001i000000N9cnS[/TD]
[TD="align: right"]310296[/TD]
[/TR]
[TR]
[TD]001i000000N9coE[/TD]
[TD="align: right"]302979[/TD]
[/TR]
[TR]
[TD]001i000000N9coF[/TD]
[TD="align: right"]202914[/TD]
[/TR]
[TR]
[TD]001i000000N9coG[/TD]
[TD="align: right"]204855[/TD]
[/TR]
[TR]
[TD]001i000000N9coH[/TD]
[TD="align: right"]204855[/TD]
[/TR]
[TR]
[TD]001i000000N9coI[/TD]
[TD="align: right"]311023[/TD]
[/TR]
[TR]
[TD]001i000000N9coi[/TD]
[TD="align: right"]203002[/TD]
[/TR]
[TR]
[TD]001i000000N9coJ[/TD]
[TD="align: right"]204875[/TD]
[/TR]
[TR]
[TD]001i000000N9coL[/TD]
[TD="align: right"]204958[/TD]
[/TR]
[TR]
[TD]001i000000N9coN[/TD]
[TD="align: right"]204654[/TD]
[/TR]
[TR]
[TD]001i000000N9coO[/TD]
[TD="align: right"]204986[/TD]
[/TR]
[TR]
[TD]001i000000N9coo[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000N9coP[/TD]
[TD="align: right"]202896[/TD]
[/TR]
[TR]
[TD]001i000000N9cop[/TD]
[TD="align: right"]301737[/TD]
[/TR]
[TR]
[TD]001i000000N9coR[/TD]
[TD="align: right"]301572[/TD]
[/TR]
[TR]
[TD]001i000000N9cpf[/TD]
[TD="align: right"]203780[/TD]
[/TR]
[TR]
[TD]001i000000N9cph[/TD]
[TD="align: right"]311919[/TD]
[/TR]
[TR]
[TD]001i000000N9cpP[/TD]
[TD="align: right"]311232[/TD]
[/TR]
[TR]
[TD]001i000000N9cpX[/TD]
[TD="align: right"]300017[/TD]
[/TR]
[TR]
[TD]001i000000N9cpY[/TD]
[TD="align: right"]203834[/TD]
[/TR]
[TR]
[TD]001i000000N9cq1[/TD]
[TD="align: right"]200315[/TD]
[/TR]
[TR]
[TD]001i000000N9cq5[/TD]
[TD="align: right"]311034[/TD]
[/TR]
[TR]
[TD]001i000000N9cqA[/TD]
[TD="align: right"]200969[/TD]
[/TR]
[TR]
[TD]001i000000N9cqe[/TD]
[TD="align: right"]307015[/TD]
[/TR]
[TR]
[TD]001i000000N9cqH[/TD]
[TD="align: right"]202985[/TD]
[/TR]
[TR]
[TD]001i000000N9cQk[/TD]
[TD="align: right"]200748[/TD]
[/TR]
[TR]
[TD]001i000000N9cQl[/TD]
[TD="align: right"]301368[/TD]
[/TR]
[TR]
[TD]001i000000N9cQm[/TD]
[TD="align: right"]202990[/TD]
[/TR]
[TR]
[TD]001i000000N9cQo[/TD]
[TD="align: right"]307075[/TD]
[/TR]
[TR]
[TD]001i000000N9cQp[/TD]
[TD="align: right"]302429[/TD]
[/TR]
[TR]
[TD]001i000000N9cQs[/TD]
[TD="align: right"]310686[/TD]
[/TR]
[TR]
[TD]001i000000N9cr7[/TD]
[TD="align: right"]306955[/TD]
[/TR]
[TR]
[TD]001i000000N9crJ[/TD]
[TD="align: right"]203770[/TD]
[/TR]
[TR]
[TD]001i000000N9csc[/TD]
[TD="align: right"]311333[/TD]
[/TR]
[TR]
[TD]001i000000N9cse[/TD]
[TD="align: right"]300045[/TD]
[/TR]
[TR]
[TD]001i000000N9csi[/TD]
[TD="align: right"]207449[/TD]
[/TR]
[TR]
[TD]001i000000N9csk[/TD]
[TD="align: right"]301100[/TD]
[/TR]
[TR]
[TD]001i000000N9csP[/TD]
[TD="align: right"]300061[/TD]
[/TR]
[TR]
[TD]001i000000N9css[/TD]
[TD="align: right"]306264[/TD]
[/TR]
[TR]
[TD]001i000000N9cst[/TD]
[TD="align: right"]311135[/TD]
[/TR]
[TR]
[TD]001i000000N9csX[/TD]
[TD="align: right"]206051[/TD]
[/TR]
[TR]
[TD]001i000000N9ct1[/TD]
[TD="align: right"]310649[/TD]
[/TR]
[TR]
[TD]001i000000N9ct2[/TD]
[TD="align: right"]300734[/TD]
[/TR]
[TR]
[TD]001i000000N9ct3[/TD]
[TD="align: right"]202977[/TD]
[/TR]
[TR]
[TD]001i000000N9ct4[/TD]
[TD="align: right"]302995[/TD]
[/TR]
[TR]
[TD]001i000000N9ct8[/TD]
[TD="align: right"]204791[/TD]
[/TR]
[TR]
[TD]001i000000N9ctA[/TD]
[TD="align: right"]311519[/TD]
[/TR]
[TR]
[TD]001i000000N9cTc[/TD]
[TD="align: right"]203707[/TD]
[/TR]
[TR]
[TD]001i000000N9cTF[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000N9cTQ[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000N9cTw[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000N9ctx[/TD]
[TD="align: right"]206014[/TD]
[/TR]
[TR]
[TD]001i000000N9cua[/TD]
[TD="align: right"]311177[/TD]
[/TR]
[TR]
[TD]001i000000N9cUb[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000N9cub[/TD]
[TD="align: right"]300921[/TD]
[/TR]
[TR]
[TD]001i000000N9cuc[/TD]
[TD="align: right"]306187[/TD]
[/TR]
[TR]
[TD]001i000000N9cud[/TD]
[TD="align: right"]203852[/TD]
[/TR]
[TR]
[TD]001i000000N9cue[/TD]
[TD="align: right"]310667[/TD]
[/TR]
[TR]
[TD]001i000000N9cuj[/TD]
[TD="align: right"]302978[/TD]
[/TR]
[TR]
[TD]001i000000N9cUo[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000N9cUS[/TD]
[TD="align: right"]301385[/TD]
[/TR]
[TR]
[TD]001i000000N9cUw[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000N9cuW[/TD]
[TD="align: right"]207612[/TD]
[/TR]
[TR]
[TD]001i000000N9cuw[/TD]
[TD="align: right"]307642[/TD]
[/TR]
[TR]
[TD]001i000000N9cuX[/TD]
[TD="align: right"]205732[/TD]
[/TR]
[TR]
[TD]001i000000N9cuy[/TD]
[TD="align: right"]309860[/TD]
[/TR]
[TR]
[TD]001i000000N9cv0[/TD]
[TD="align: right"]307834[/TD]
[/TR]
[TR]
[TD]001i000000N9cv7[/TD]
[TD="align: right"]306873[/TD]
[/TR]
[TR]
[TD]001i000000N9cv9[/TD]
[TD="align: right"]307873[/TD]
[/TR]
[TR]
[TD]001i000000N9cvA[/TD]
[TD="align: right"]202996[/TD]
[/TR]
[TR]
[TD]001i000000N9cvB[/TD]
[TD="align: right"]310979[/TD]
[/TR]
[TR]
[TD]001i000000N9cvD[/TD]
[TD="align: right"]202916[/TD]
[/TR]
[TR]
[TD]001i000000N9cvH[/TD]
[TD="align: right"]306181[/TD]
[/TR]
[TR]
[TD]001i000000N9cvK[/TD]
[TD="align: right"]205681[/TD]
[/TR]
[TR]
[TD]001i000000N9cvQ[/TD]
[TD="align: right"]205718[/TD]
[/TR]
[TR]
[TD]001i000000N9cvR[/TD]
[TD="align: right"]205723[/TD]
[/TR]
[TR]
[TD]001i000000N9cVv[/TD]
[TD="align: right"]300499[/TD]
[/TR]
[TR]
[TD]001i000000N9cvY[/TD]
[TD="align: right"]202920[/TD]
[/TR]
[TR]
[TD]001i000000N9cW5[/TD]
[TD="align: right"]203402[/TD]
[/TR]
[TR]
[TD]001i000000N9cw5[/TD]
[TD="align: right"]306663[/TD]
[/TR]
[TR]
[TD]001i000000N9cwb[/TD]
[TD="align: right"]206898[/TD]
[/TR]
[TR]
[TD]001i000000N9cwE[/TD]
[TD="align: right"]307335[/TD]
[/TR]
[TR]
[TD]001i000000N9cwT[/TD]
[TD="align: right"]311479[/TD]
[/TR]
[TR]
[TD]001i000000N9cwV[/TD]
[TD="align: right"]206067[/TD]
[/TR]
[TR]
[TD]001i000000N9cwX[/TD]
[TD="align: right"]206162[/TD]
[/TR]
[TR]
[TD]001i000000N9cx3[/TD]
[TD="align: right"]306675[/TD]
[/TR]
[TR]
[TD]001i000000N9cxd[/TD]
[TD="align: right"]207000[/TD]
[/TR]
[TR]
[TD]001i000000N9cXe[/TD]
[TD="align: right"]206494[/TD]
[/TR]
[TR]
[TD]001i000000N9cxe[/TD]
[TD="align: right"]311241[/TD]
[/TR]
[TR]
[TD]001i000000N9cXR[/TD]
[TD="align: right"]302913[/TD]
[/TR]
[TR]
[TD]001i000000N9cXs[/TD]
[TD="align: right"]309843[/TD]
[/TR]
[TR]
[TD]001i000000N9cXu[/TD]
[TD="align: right"]309094[/TD]
[/TR]
[TR]
[TD]001i000000N9cXv[/TD]
[TD="align: right"]306024[/TD]
[/TR]
[TR]
[TD]001i000000N9cXw[/TD]
[TD="align: right"]307571[/TD]
[/TR]
[TR]
[TD]001i000000N9cxW[/TD]
[TD="align: right"]310466[/TD]
[/TR]
[TR]
[TD]001i000000N9cXx[/TD]
[TD="align: right"]306365[/TD]
[/TR]
[TR]
[TD]001i000000N9cxX[/TD]
[TD="align: right"]200229[/TD]
[/TR]
[TR]
[TD]001i000000N9cxZ[/TD]
[TD="align: right"]311780[/TD]
[/TR]
[TR]
[TD]001i000000N9cY2[/TD]
[TD="align: right"]302669[/TD]
[/TR]
[TR]
[TD]001i000000N9cY3[/TD]
[TD="align: right"]202993[/TD]
[/TR]
[TR]
[TD]001i000000N9cY4[/TD]
[TD="align: right"]308111[/TD]
[/TR]
[TR]
[TD]001i000000N9cY5[/TD]
[TD="align: right"]200104[/TD]
[/TR]
[TR]
[TD]001i000000N9cYA[/TD]
[TD="align: right"]301048[/TD]
[/TR]
[TR]
[TD]001i000000N9cYB[/TD]
[TD="align: right"]205335[/TD]
[/TR]
[TR]
[TD]001i000000N9cYC[/TD]
[TD="align: right"]204666[/TD]
[/TR]
[TR]
[TD]001i000000N9cYD[/TD]
[TD="align: right"]301524[/TD]
[/TR]
[TR]
[TD]001i000000N9cYE[/TD]
[TD="align: right"]202980[/TD]
[/TR]
[TR]
[TD]001i000000N9cYF[/TD]
[TD="align: right"]309845[/TD]
[/TR]
[TR]
[TD]001i000000N9cYG[/TD]
[TD="align: right"]203854[/TD]
[/TR]
[TR]
[TD]001i000000N9cyh[/TD]
[TD="align: right"]311866[/TD]
[/TR]
[TR]
[TD]001i000000N9cYN[/TD]
[TD="align: right"]203128[/TD]
[/TR]
[TR]
[TD]001i000000N9cYp[/TD]
[TD="align: right"]206497[/TD]
[/TR]
[TR]
[TD]001i000000N9cYr[/TD]
[TD="align: right"]203667[/TD]
[/TR]
[TR]
[TD]001i000000N9cYv[/TD]
[TD="align: right"]308477[/TD]
[/TR]
[TR]
[TD]001i000000N9cYW[/TD]
[TD="align: right"]204757[/TD]
[/TR]
[TR]
[TD]001i000000N9cYX[/TD]
[TD="align: right"]301796[/TD]
[/TR]
[TR]
[TD]001i000000N9cYY[/TD]
[TD="align: right"]301745[/TD]
[/TR]
[TR]
[TD]001i000000N9cYZ[/TD]
[TD="align: right"]311552[/TD]
[/TR]
[TR]
[TD]001i000000N9cZ0[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000N9cz0[/TD]
[TD="align: right"]306243[/TD]
[/TR]
[TR]
[TD]001i000000N9cz1[/TD]
[TD="align: right"]301004[/TD]
[/TR]
[TR]
[TD]001i000000N9cZ8[/TD]
[TD="align: right"]306185[/TD]
[/TR]
[TR]
[TD]001i000000N9cZ9[/TD]
[TD="align: right"]309304[/TD]
[/TR]
[TR]
[TD]001i000000N9cZA[/TD]
[TD="align: right"]306534[/TD]
[/TR]
[TR]
[TD]001i000000N9cZE[/TD]
[TD="align: right"]203951[/TD]
[/TR]
[TR]
[TD]001i000000N9cZJ[/TD]
[TD="align: right"]308393[/TD]
[/TR]
[TR]
[TD]001i000000N9cZR[/TD]
[TD="align: right"]204936[/TD]
[/TR]
[TR]
[TD]001i000000N9cZu[/TD]
[TD="align: right"]307943[/TD]
[/TR]
[TR]
[TD]001i000000N9cZV[/TD]
[TD="align: right"]308517[/TD]
[/TR]
[TR]
[TD]001i000000N9cZx[/TD]
[TD="align: right"]306509[/TD]
[/TR]
[TR]
[TD]001i000000N9cZz[/TD]
[TD="align: right"]300552[/TD]
[/TR]
[TR]
[TD]001i000000N9d3q[/TD]
[TD="align: right"]308508[/TD]
[/TR]
[TR]
[TD]001i000000N9d3r[/TD]
[TD="align: right"]311884[/TD]
[/TR]
[TR]
[TD]001i000000N9d42[/TD]
[TD="align: right"]306667[/TD]
[/TR]
[TR]
[TD]001i000000N9d58[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000N9d5a[/TD]
[TD="align: right"]203206[/TD]
[/TR]
[TR]
[TD]001i000000OVbrA[/TD]
[TD="align: right"]312667[/TD]
[/TR]
[TR]
[TD]001i000000pS3mb[/TD]
[TD="align: right"]210018[/TD]
[/TR]
[TR]
[TD]001i000000pS3mf[/TD]
[TD="align: right"]305815[/TD]
[/TR]
[TR]
[TD]001i000000pS3mk[/TD]
[TD="align: right"]203225[/TD]
[/TR]
[TR]
[TD]001i000000pS3mL[/TD]
[TD="align: right"]301200[/TD]
[/TR]
[TR]
[TD]001i000000pS3mM[/TD]
[TD="align: right"]310971[/TD]
[/TR]
[TR]
[TD]001i000000pS3mN[/TD]
[TD="align: right"]301808[/TD]
[/TR]
[TR]
[TD]001i000000pS3ms[/TD]
[TD="align: right"]303217[/TD]
[/TR]
[TR]
[TD]001i000000pS3mT[/TD]
[TD="align: right"]203066[/TD]
[/TR]
[TR]
[TD]001i000000pS3mu[/TD]
[TD="align: right"]207332[/TD]
[/TR]
[TR]
[TD]001i000000pS3mW[/TD]
[TD="align: right"]203054[/TD]
[/TR]
[TR]
[TD]001i000000pS3mw[/TD]
[TD="align: right"]300085[/TD]
[/TR]
[TR]
[TD]001i000000pS3mX[/TD]
[TD="align: right"]206548[/TD]
[/TR]
[TR]
[TD]001i000000pS3my[/TD]
[TD="align: right"]301652[/TD]
[/TR]
[TR]
[TD]001i000000pS3n0[/TD]
[TD="align: right"]203465[/TD]
[/TR]
[TR]
[TD]001i000000pS3n2[/TD]
[TD="align: right"]203146[/TD]
[/TR]
[TR]
[TD]001i000000pS3n3[/TD]
[TD="align: right"]301676[/TD]
[/TR]
[TR]
[TD]001i000000pS3n6[/TD]
[TD="align: right"]204786[/TD]
[/TR]
[TR]
[TD]001i000000pS3n8[/TD]
[TD="align: right"]305830[/TD]
[/TR]
[TR]
[TD]001i000000pS3nA[/TD]
[TD="align: right"]301379[/TD]
[/TR]
[TR]
[TD]001i000000pS3nB[/TD]
[TD="align: right"]203122[/TD]
[/TR]
[TR]
[TD]001i000000pS3nc[/TD]
[TD="align: right"]203331[/TD]
[/TR]
[TR]
[TD]001i000000pS3nD[/TD]
[TD="align: right"]203255[/TD]
[/TR]
[TR]
[TD]001i000000pS3ne[/TD]
[TD="align: right"]302851[/TD]
[/TR]
[TR]
[TD]001i000000pS3nG[/TD]
[TD="align: right"]203252[/TD]
[/TR]
[TR]
[TD]001i000000pS3nH[/TD]
[TD="align: right"]203182[/TD]
[/TR]
[TR]
[TD]001i000000pS3ni[/TD]
[TD="align: right"]301734[/TD]
[/TR]
[TR]
[TD]001i000000pS3nJ[/TD]
[TD="align: right"]308533[/TD]
[/TR]
[TR]
[TD]001i000000pS3nj[/TD]
[TD="align: right"]302025[/TD]
[/TR]
[TR]
[TD]001i000000pS3nK[/TD]
[TD="align: right"]309207[/TD]
[/TR]
[TR]
[TD]001i000000pS3nl[/TD]
[TD="align: right"]306601[/TD]
[/TR]
[TR]
[TD]001i000000pS3nM[/TD]
[TD="align: right"]302686[/TD]
[/TR]
[TR]
[TD]001i000000pS3nO[/TD]
[TD="align: right"]203198[/TD]
[/TR]
[TR]
[TD]001i000000pS3no[/TD]
[TD="align: right"]203065[/TD]
[/TR]
[TR]
[TD]001i000000pS3nQ[/TD]
[TD="align: right"]203451[/TD]
[/TR]
[TR]
[TD]001i000000pS3nq[/TD]
[TD="align: right"]203191[/TD]
[/TR]
[TR]
[TD]001i000000pS3nr[/TD]
[TD="align: right"]302520[/TD]
[/TR]
[TR]
[TD]001i000000pS3nu[/TD]
[TD="align: right"]305787[/TD]
[/TR]
[TR]
[TD]001i000000pS3nV[/TD]
[TD="align: right"]203156[/TD]
[/TR]
[TR]
[TD]001i000000pS3nW[/TD]
[TD="align: right"]203330[/TD]
[/TR]
[TR]
[TD]001i000000pS3nw[/TD]
[TD="align: right"]203115[/TD]
[/TR]
[TR]
[TD]001i000000pS3nZ[/TD]
[TD="align: right"]301258[/TD]
[/TR]
[TR]
[TD]001i000000pS3nz[/TD]
[TD="align: right"]302109[/TD]
[/TR]
[TR]
[TD]001i000000pS3o4[/TD]
[TD="align: right"]203174[/TD]
[/TR]
[TR]
[TD]001i000000pS3o7[/TD]
[TD="align: right"]300145[/TD]
[/TR]
[TR]
[TD]001i000000pS3oA[/TD]
[TD="align: right"]203126[/TD]
[/TR]
[TR]
[TD]001i000000pS3oa[/TD]
[TD="align: right"]203365[/TD]
[/TR]
[TR]
[TD]001i000000pS3ob[/TD]
[TD="align: right"]300513[/TD]
[/TR]
[TR]
[TD]001i000000pS3oC[/TD]
[TD="align: right"]305792[/TD]
[/TR]
[TR]
[TD]001i000000pS3oe[/TD]
[TD="align: right"]203369[/TD]
[/TR]
[TR]
[TD]001i000000pS3oF[/TD]
[TD="align: right"]301566[/TD]
[/TR]
[TR]
[TD]001i000000pS3oH[/TD]
[TD="align: right"]301192[/TD]
[/TR]
[TR]
[TD]001i000000pS3oJ[/TD]
[TD="align: right"]307591[/TD]
[/TR]
[TR]
[TD]001i000000pS3ok[/TD]
[TD="align: right"]203623[/TD]
[/TR]
[TR]
[TD]001i000000pS3oL[/TD]
[TD="align: right"]300083[/TD]
[/TR]
[TR]
[TD]001i000000pS3oN[/TD]
[TD="align: right"]311901[/TD]
[/TR]
[TR]
[TD]001i000000pS3oo[/TD]
[TD="align: right"]306672[/TD]
[/TR]
[TR]
[TD]001i000000pS3oP[/TD]
[TD="align: right"]312024[/TD]
[/TR]
[TR]
[TD]001i000000pS3op[/TD]
[TD="align: right"]203079[/TD]
[/TR]
[TR]
[TD]001i000000pS3or[/TD]
[TD="align: right"]203107[/TD]
[/TR]
[TR]
[TD]001i000000pS3oT[/TD]
[TD="align: right"]302108[/TD]
[/TR]
[TR]
[TD]001i000000pS3ot[/TD]
[TD="align: right"]302726[/TD]
[/TR]
[TR]
[TD]001i000000pS3oV[/TD]
[TD="align: right"]308219[/TD]
[/TR]
[TR]
[TD]001i000000pS3ov[/TD]
[TD="align: right"]301323[/TD]
[/TR]
[TR]
[TD]001i000000pS3oW[/TD]
[TD="align: right"]307291[/TD]
[/TR]
[TR]
[TD]001i000000pS3oX[/TD]
[TD="align: right"]308931[/TD]
[/TR]
[TR]
[TD]001i000000pS3oy[/TD]
[TD="align: right"]203142[/TD]
[/TR]
[TR]
[TD]001i000000pS3p0[/TD]
[TD="align: right"]206580[/TD]
[/TR]
[TR]
[TD]001i000000pS3p2[/TD]
[TD="align: right"]302649[/TD]
[/TR]
[TR]
[TD]001i000000pS3p6[/TD]
[TD="align: right"]300698[/TD]
[/TR]
[TR]
[TD]001i000000pS3p8[/TD]
[TD="align: right"]203183[/TD]
[/TR]
[TR]
[TD]001i000000pS3pB[/TD]
[TD="align: right"]203120[/TD]
[/TR]
[TR]
[TD]001i000000pS3pb[/TD]
[TD="align: right"]203423[/TD]
[/TR]
[TR]
[TD]001i000000pS3pD[/TD]
[TD]305409-EU[/TD]
[/TR]
[TR]
[TD]001i000000pS3pd[/TD]
[TD="align: right"]203428[/TD]
[/TR]
[TR]
[TD]001i000000pS3pE[/TD]
[TD="align: right"]304566[/TD]
[/TR]
[TR]
[TD]001i000000pS3pf[/TD]
[TD="align: right"]203209[/TD]
[/TR]
[TR]
[TD]001i000000pS3pG[/TD]
[TD="align: right"]305989[/TD]
[/TR]
[TR]
[TD]001i000000pS3ph[/TD]
[TD="align: right"]306929[/TD]
[/TR]
[TR]
[TD]001i000000pS3pI[/TD]
[TD="align: right"]203329[/TD]
[/TR]
[TR]
[TD]001i000000pS3pj[/TD]
[TD="align: right"]312667[/TD]
[/TR]
[TR]
[TD]001i000000pS3pk[/TD]
[TD="align: right"]310264[/TD]
[/TR]
[TR]
[TD]001i000000pS3pL[/TD]
[TD="align: right"]307530[/TD]
[/TR]
[TR]
[TD]001i000000pS3pM[/TD]
[TD="align: right"]203450[/TD]
[/TR]
[TR]
[TD]001i000000pS3pm[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3pO[/TD]
[TD="align: right"]305868[/TD]
[/TR]
[TR]
[TD]001i000000pS3pQ[/TD]
[TD="align: right"]301261[/TD]
[/TR]
[TR]
[TD]001i000000pS3pq[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3pS[/TD]
[TD="align: right"]300113[/TD]
[/TR]
[TR]
[TD]001i000000pS3pV[/TD]
[TD="align: right"]203718[/TD]
[/TR]
[TR]
[TD]001i000000pS3pX[/TD]
[TD="align: right"]203121[/TD]
[/TR]
[TR]
[TD]001i000000pS3px[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3pZ[/TD]
[TD="align: right"]203059[/TD]
[/TR]
[TR]
[TD]001i000000pS3q4[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3q9[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3qB[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3qD[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3qf[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3qg[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3qI[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3qi[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3qn[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3qQ[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3qr[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3qS[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3qT[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3qV[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3qY[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3qZ[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3r6[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3rA[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3rb[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3rc[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3rD[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3rF[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3rG[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3rh[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3ri[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3rM[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3rn[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3ro[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3rS[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3rs[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3rt[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3rw[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3rx[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3s1[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3s3[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3s4[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3s5[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3sF[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3sG[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pS3sN[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000pSjOb[/TD]
[TD="align: right"]305409[/TD]
[/TR]
[TR]
[TD]001i000000sVXZd[/TD]
[TD="align: right"]310328[/TD]
[/TR]
[TR]
[TD]001i000000sVXZe[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]001i000000X8rQe[/TD]
[TD="align: right"]312954[/TD]
[/TR]
[TR]
[TD]001i000000zG8dT[/TD]
[TD="align: right"]315427[/TD]
[/TR]
[TR]
[TD]001i0000019eth0[/TD]
[TD]-[/TD]
[/TR]
</tbody>[/TABLE]

Thanks for your help!

JLGWhiz · Oct 13, 2014

I am assuming that the data shown between Account IDs is a glitch in the html copy over and that it actually is part of the 'Full Comments' column. If it is part of column A then this code will fail.

Code:

Sub combineDiamondNate()
Dim sh1 As Worksheet, sh2 As Worksheet, sh3 As Worksheet, lr As Long, c As Range, fn As Range
Set sh1 = Sheets("SF Notes Added") 'Validate sheet name
Set sh2 = Sheets("SFID-CID") 'Validate sheet name
Set sh3 = Sheets(3) 'Edit sheet name-this is the combined sheet which you must designate.
lr = sh1.Cells(Rows.Count, 1).End(xlUp).Row
    For Each c In sh1.Range("A2:A" & lr)
        Set fn = sh2.Range("A:A").Find(c.Value, , xlValues, xlWhole)
            If Not fn Is Nothing Then
                sh3.Cells(Rows.Count, 1).End(xlUp)(2) = fn.Offset(0, 1).Value
                sh3.Cells(Rows.Count, 1).End(xlUp).Offset(0, 1) = "nross'"
                sh3.Cells(Rows.Count, 1).End(xlUp).Offset(0, 2) = c.Offset(0, 1).Value
                sh3.Cells(Rows.Count, 1).End(xlUp).Offset(0, 3) = c.Offset(0, 5).Value
            End If
    Next
End Sub

DiamondNate · Oct 13, 2014

Hi JLGWhiz

Thank you so much for your help.

The VBA you provided, when tested, had a view issues.

1) The Account ID's are case-sensitive so you could have 11upD and 11UpD.
2) The Date wasn't being pulled in on some.
3) The note field is note quiet working properly. Should be coulmn d - column e: colum F row(); column F row(); for all rows columns a:e have merged.

Here is the link to view a sample of the excel file
https://drive.google.com/file/d/0B0dzgXh022zddENXNGZjUmhYVW8/view?usp=sharing

Need help creating VBA to pull data from two worksheets into one worksheet

DiamondNate

New Member

JLGWhiz

Well-known Member

DiamondNate

New Member

Similar threads

Share this page

Need help creating VBA to pull data from two worksheets into one worksheet

DiamondNate

New Member

JLGWhiz

Well-known Member

DiamondNate

New Member

Similar threads

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock