Data Validation to Fill in Spreadsheet

E

Ebull

New Member
Joined
Feb 20, 2019
Messages
1
I am creating a battle simulator for a crypto-game that I play (Etheremon if anyone is familar). I am able to pull a list of my possible opponents and all of their "mons" and respective stats using VBA. It looks like this:

[TABLE="width: 1703"]
<colgroup><col><col><col><col><col><col><col><col><col span="5"><col span="2"><col><col span="3"><col><col><col><col></colgroup><tbody>[TR]
[TD]Username[/TD]
[TD]Avg BP[/TD]
[TD]Avg Level[/TD]
[TD]Opp. Address[/TD]
[TD]Player ID[/TD]
[TD]Catch Number[/TD]
[TD]Monster ID[/TD]
[TD]Type 1[/TD]
[TD]Type 2[/TD]
[TD]Gason Y/N[/TD]
[TD]Ancestor 1[/TD]
[TD]Ancestor 2[/TD]
[TD]Ancestor 3[/TD]
[TD]Class ID[/TD]
[TD]Total Level[/TD]
[TD]Exp[/TD]
[TD]HP[/TD]
[TD]PA[/TD]
[TD]PD[/TD]
[TD]SA[/TD]
[TD]SD[/TD]
[TD]SPD[/TD]
[TD]Total BP[/TD]
[/TR]
[TR]
[TD]forest gate[/TD]
[TD="align: right"]609[/TD]
[TD="align: right"]77[/TD]
[TD]0xc674d5f701bbd8a79315cd2434af18c75816856e[/TD]
[TD="align: right"]370[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]43672[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]17[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]137[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]669207[/TD]
[TD="align: right"]514[/TD]
[TD="align: right"]702[/TD]
[TD="align: right"]470[/TD]
[TD="align: right"]682[/TD]
[TD="align: right"]275[/TD]
[TD="align: right"]491[/TD]
[TD="align: right"]522[/TD]
[/TR]
[TR]
[TD]forest gate[/TD]
[TD="align: right"]609[/TD]
[TD="align: right"]77[/TD]
[TD]0xc674d5f701bbd8a79315cd2434af18c75816856e[/TD]
[TD="align: right"]370[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]38204[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]4487302[/TD]
[TD="align: right"]637[/TD]
[TD="align: right"]647[/TD]
[TD="align: right"]583[/TD]
[TD="align: right"]591[/TD]
[TD="align: right"]910[/TD]
[TD="align: right"]578[/TD]
[TD="align: right"]657[/TD]
[/TR]
[TR]
[TD]forest gate[/TD]
[TD="align: right"]609[/TD]
[TD="align: right"]77[/TD]
[TD]0xc674d5f701bbd8a79315cd2434af18c75816856e[/TD]
[TD="align: right"]370[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]37995[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]17[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]157[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]3414717[/TD]
[TD="align: right"]612[/TD]
[TD="align: right"]603[/TD]
[TD="align: right"]859[/TD]
[TD="align: right"]604[/TD]
[TD="align: right"]603[/TD]
[TD="align: right"]614[/TD]
[TD="align: right"]649[/TD]
[/TR]
[TR]
[TD]forest gate[/TD]
[TD="align: right"]609[/TD]
[TD="align: right"]77[/TD]
[TD]0xc674d5f701bbd8a79315cd2434af18c75816856e[/TD]
[TD="align: right"]370[/TD]
[TD="align: right"]258[/TD]
[TD="align: right"]45054[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]17[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD]forest gate[/TD]
[TD="align: right"]609[/TD]
[TD="align: right"]77[/TD]
[TD]0xc674d5f701bbd8a79315cd2434af18c75816856e[/TD]
[TD="align: right"]370[/TD]
[TD="align: right"]128[/TD]
[TD="align: right"]42677[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]74[/TD]
[/TR]
[TR]
[TD]forest gate[/TD]
[TD="align: right"]609[/TD]
[TD="align: right"]77[/TD]
[TD]0xc674d5f701bbd8a79315cd2434af18c75816856e[/TD]
[TD="align: right"]370[/TD]
[TD="align: right"]166[/TD]
[TD="align: right"]41949[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]80[/TD]
[/TR]
[TR]
[TD]TONKA⇒[/TD]
[TD="align: right"]638[/TD]
[TD="align: right"]84[/TD]
[TD]0xa9838c0f833d4e378fc937cc00d8b4080193815b[/TD]
[TD="align: right"]240[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]29654[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]12[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]12048271[/TD]
[TD="align: right"]662[/TD]
[TD="align: right"]977[/TD]
[TD="align: right"]972[/TD]
[TD="align: right"]405[/TD]
[TD="align: right"]684[/TD]
[TD="align: right"]661[/TD]
[TD="align: right"]726[/TD]
[/TR]
[TR]
[TD]TONKA⇒[/TD]
[TD="align: right"]638[/TD]
[TD="align: right"]84[/TD]
[TD]0xa9838c0f833d4e378fc937cc00d8b4080193815b[/TD]
[TD="align: right"]240[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]28096[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]16[/TD]
[TD="align: center"]FALSE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]2421726[/TD]
[TD="align: right"]555[/TD]
[TD="align: right"]312[/TD]
[TD="align: right"]560[/TD]
[TD="align: right"]826[/TD]
[TD="align: right"]812[/TD]
[TD="align: right"]557[/TD]
[TD="align: right"]603[/TD]
[/TR]
[TR]
[TD]TONKA⇒[/TD]
[TD="align: right"]638[/TD]
[TD="align: right"]84[/TD]
[TD]0xa9838c0f833d4e378fc937cc00d8b4080193815b[/TD]
[TD="align: right"]240[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]30214[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]12[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]3266507[/TD]
[TD="align: right"]579[/TD]
[TD="align: right"]308[/TD]
[TD="align: right"]583[/TD]
[TD="align: right"]842[/TD]
[TD="align: right"]596[/TD]
[TD="align: right"]616[/TD]
[TD="align: right"]587[/TD]
[/TR]
[TR]
[TD]TONKA⇒[/TD]
[TD="align: right"]638[/TD]
[TD="align: right"]84[/TD]
[TD]0xa9838c0f833d4e378fc937cc00d8b4080193815b[/TD]
[TD="align: right"]240[/TD]
[TD="align: right"]242[/TD]
[TD="align: right"]26869[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]53[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]71[/TD]
[/TR]
[TR]
[TD]TONKA⇒[/TD]
[TD="align: right"]638[/TD]
[TD="align: right"]84[/TD]
[TD]0xa9838c0f833d4e378fc937cc00d8b4080193815b[/TD]
[TD="align: right"]240[/TD]
[TD="align: right"]5749[/TD]
[TD="align: right"]29912[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]66[/TD]
[/TR]
[TR]
[TD]TONKA⇒[/TD]
[TD="align: right"]638[/TD]
[TD="align: right"]84[/TD]
[TD]0xa9838c0f833d4e378fc937cc00d8b4080193815b[/TD]
[TD="align: right"]240[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]30564[/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]71[/TD]
[/TR]
[TR]
[TD]¯\_(ツ)_/¯[/TD]
[TD="align: right"]557[/TD]
[TD="align: right"]72[/TD]
[TD]0x52e1319ecc564852b63ab200802c49b1d7140f93[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]42487[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]53[/TD]
[TD="align: right"]216923[/TD]
[TD="align: right"]429[/TD]
[TD="align: right"]446[/TD]
[TD="align: right"]402[/TD]
[TD="align: right"]404[/TD]
[TD="align: right"]601[/TD]
[TD="align: right"]378[/TD]
[TD="align: right"]443[/TD]
[/TR]
[TR]
[TD]¯\_(ツ)_/¯[/TD]
[TD="align: right"]557[/TD]
[TD="align: right"]72[/TD]
[TD]0x52e1319ecc564852b63ab200802c49b1d7140f93[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]29098[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]9[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]3281295[/TD]
[TD="align: right"]585[/TD]
[TD="align: right"]839[/TD]
[TD="align: right"]609[/TD]
[TD="align: right"]322[/TD]
[TD="align: right"]594[/TD]
[TD="align: right"]579[/TD]
[TD="align: right"]588[/TD]
[/TR]
[TR]
[TD]¯\_(ツ)_/¯[/TD]
[TD="align: right"]557[/TD]
[TD="align: right"]72[/TD]
[TD]0x52e1319ecc564852b63ab200802c49b1d7140f93[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]30129[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]3602117[/TD]
[TD="align: right"]602[/TD]
[TD="align: right"]580[/TD]
[TD="align: right"]583[/TD]
[TD="align: right"]861[/TD]
[TD="align: right"]602[/TD]
[TD="align: right"]612[/TD]
[TD="align: right"]640[/TD]
[/TR]
[TR]
[TD]¯\_(ツ)_/¯[/TD]
[TD="align: right"]557[/TD]
[TD="align: right"]72[/TD]
[TD]0x52e1319ecc564852b63ab200802c49b1d7140f93[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]48883[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]96[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]51[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD]¯\_(ツ)_/¯[/TD]
[TD="align: right"]557[/TD]
[TD="align: right"]72[/TD]
[TD]0x52e1319ecc564852b63ab200802c49b1d7140f93[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]30178[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]76[/TD]
[/TR]
[TR]
[TD]¯\_(ツ)_/¯[/TD]
[TD="align: right"]557[/TD]
[TD="align: right"]72[/TD]
[TD]0x52e1319ecc564852b63ab200802c49b1d7140f93[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]4677[/TD]
[TD="align: right"]23209[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]8[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]66[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]68[/TD]
[/TR]
[TR]
[TD]Mon complex[/TD]
[TD="align: right"]569[/TD]
[TD="align: right"]74[/TD]
[TD]0x9a81d4da7d0147f0163e4ecf95f67678c40a26a5[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]42610[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]8[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]511037[/TD]
[TD="align: right"]478[/TD]
[TD="align: right"]279[/TD]
[TD="align: right"]453[/TD]
[TD="align: right"]651[/TD]
[TD="align: right"]476[/TD]
[TD="align: right"]464[/TD]
[TD="align: right"]466[/TD]
[/TR]
[TR]
[TD]Mon complex[/TD]
[TD="align: right"]569[/TD]
[TD="align: right"]74[/TD]
[TD]0x9a81d4da7d0147f0163e4ecf95f67678c40a26a5[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]36194[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]8[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]2880461[/TD]
[TD="align: right"]584[/TD]
[TD="align: right"]561[/TD]
[TD="align: right"]560[/TD]
[TD="align: right"]817[/TD]
[TD="align: right"]569[/TD]
[TD="align: right"]578[/TD]
[TD="align: right"]611[/TD]
[/TR]
[TR]
[TD]Mon complex[/TD]
[TD="align: right"]569[/TD]
[TD="align: right"]74[/TD]
[TD]0x9a81d4da7d0147f0163e4ecf95f67678c40a26a5[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]33932[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]3311704[/TD]
[TD="align: right"]590[/TD]
[TD="align: right"]591[/TD]
[TD="align: right"]579[/TD]
[TD="align: right"]864[/TD]
[TD="align: right"]583[/TD]
[TD="align: right"]587[/TD]
[TD="align: right"]632[/TD]
[/TR]
[TR]
[TD]Mon complex[/TD]
[TD="align: right"]569[/TD]
[TD="align: right"]74[/TD]
[TD]0x9a81d4da7d0147f0163e4ecf95f67678c40a26a5[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]1319[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]16[/TD]
[TD="align: center"]FALSE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]118[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]130[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]72[/TD]
[/TR]
[TR]
[TD]Mon complex[/TD]
[TD="align: right"]569[/TD]
[TD="align: right"]74[/TD]
[TD]0x9a81d4da7d0147f0163e4ecf95f67678c40a26a5[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]1892[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD="align: center"]FALSE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]490[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]141[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]91[/TD]
[/TR]
[TR]
[TD]Mon complex[/TD]
[TD="align: right"]569[/TD]
[TD="align: right"]74[/TD]
[TD]0x9a81d4da7d0147f0163e4ecf95f67678c40a26a5[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]66[/TD]
[TD="align: right"]1971[/TD]
[TD="align: right"]18[/TD]
[TD][/TD]
[TD="align: center"]FALSE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]73[/TD]
[/TR]
[TR]
[TD]hagoromo[/TD]
[TD="align: right"]590[/TD]
[TD="align: right"]75[/TD]
[TD]0x057dc43af6187a931e78a56b3293912a5b42e5ec[/TD]
[TD="align: right"]324[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]38900[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]16[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]141[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]1670009[/TD]
[TD="align: right"]549[/TD]
[TD="align: right"]552[/TD]
[TD="align: right"]537[/TD]
[TD="align: right"]763[/TD]
[TD="align: right"]540[/TD]
[TD="align: right"]539[/TD]
[TD="align: right"]580[/TD]
[/TR]
[TR]
[TD]hagoromo[/TD]
[TD="align: right"]590[/TD]
[TD="align: right"]75[/TD]
[TD]0x057dc43af6187a931e78a56b3293912a5b42e5ec[/TD]
[TD="align: right"]324[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]41700[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]17[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]153[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]1217180[/TD]
[TD="align: right"]521[/TD]
[TD="align: right"]526[/TD]
[TD="align: right"]522[/TD]
[TD="align: right"]747[/TD]
[TD="align: right"]745[/TD]
[TD="align: right"]537[/TD]
[TD="align: right"]599[/TD]
[/TR]
[TR]
[TD]hagoromo[/TD]
[TD="align: right"]590[/TD]
[TD="align: right"]75[/TD]
[TD]0x057dc43af6187a931e78a56b3293912a5b42e5ec[/TD]
[TD="align: right"]324[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]30146[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]12[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]3436479[/TD]
[TD="align: right"]562[/TD]
[TD="align: right"]333[/TD]
[TD="align: right"]602[/TD]
[TD="align: right"]846[/TD]
[TD="align: right"]603[/TD]
[TD="align: right"]604[/TD]
[TD="align: right"]591[/TD]
[/TR]
[TR]
[TD]hagoromo[/TD]
[TD="align: right"]590[/TD]
[TD="align: right"]75[/TD]
[TD]0x057dc43af6187a931e78a56b3293912a5b42e5ec[/TD]
[TD="align: right"]324[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]47399[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]8[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]129[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]104[/TD]
[/TR]
[TR]
[TD]hagoromo[/TD]
[TD="align: right"]590[/TD]
[TD="align: right"]75[/TD]
[TD]0x057dc43af6187a931e78a56b3293912a5b42e5ec[/TD]
[TD="align: right"]324[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]41854[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]96[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]69[/TD]
[/TR]
[TR]
[TD]hagoromo[/TD]
[TD="align: right"]590[/TD]
[TD="align: right"]75[/TD]
[TD]0x057dc43af6187a931e78a56b3293912a5b42e5ec[/TD]
[TD="align: right"]324[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]30545[/TD]
[TD="align: right"]17[/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]164[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD]Lemongrass[/TD]
[TD="align: right"]709[/TD]
[TD="align: right"]94[/TD]
[TD]0x3c9c530d684a99cc39388c644f21ebeeb61c2839[/TD]
[TD="align: right"]705[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]26510[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]19771257[/TD]
[TD="align: right"]716[/TD]
[TD="align: right"]707[/TD]
[TD="align: right"]687[/TD]
[TD="align: right"]1012[/TD]
[TD="align: right"]702[/TD]
[TD="align: right"]711[/TD]
[TD="align: right"]755[/TD]
[/TR]
[TR]
[TD]Lemongrass[/TD]
[TD="align: right"]709[/TD]
[TD="align: right"]94[/TD]
[TD]0x3c9c530d684a99cc39388c644f21ebeeb61c2839[/TD]
[TD="align: right"]705[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]29604[/TD]
[TD="align: right"]16[/TD]
[TD][/TD]
[TD="align: center"]FALSE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]5985710[/TD]
[TD="align: right"]603[/TD]
[TD="align: right"]916[/TD]
[TD="align: right"]872[/TD]
[TD="align: right"]334[/TD]
[TD="align: right"]630[/TD]
[TD="align: right"]630[/TD]
[TD="align: right"]664[/TD]
[/TR]
[TR]
[TD]Lemongrass[/TD]
[TD="align: right"]709[/TD]
[TD="align: right"]94[/TD]
[TD]0x3c9c530d684a99cc39388c644f21ebeeb61c2839[/TD]
[TD="align: right"]705[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]38544[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]10589235[/TD]
[TD="align: right"]667[/TD]
[TD="align: right"]683[/TD]
[TD="align: right"]654[/TD]
[TD="align: right"]383[/TD]
[TD="align: right"]936[/TD]
[TD="align: right"]935[/TD]
[TD="align: right"]709[/TD]
[/TR]
[TR]
[TD]Lemongrass[/TD]
[TD="align: right"]709[/TD]
[TD="align: right"]94[/TD]
[TD]0x3c9c530d684a99cc39388c644f21ebeeb61c2839[/TD]
[TD="align: right"]705[/TD]
[TD="align: right"]8854[/TD]
[TD="align: right"]41555[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]8[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]5402[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]183[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]175[/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]183[/TD]
[TD="align: right"]145[/TD]
[/TR]
[TR]
[TD]Lemongrass[/TD]
[TD="align: right"]709[/TD]
[TD="align: right"]94[/TD]
[TD]0x3c9c530d684a99cc39388c644f21ebeeb61c2839[/TD]
[TD="align: right"]705[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]45335[/TD]
[TD="align: right"]16[/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2151[/TD]
[TD="align: right"]109[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]155[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]141[/TD]
[TD="align: right"]118[/TD]
[/TR]
[TR]
[TD]Lemongrass[/TD]
[TD="align: right"]709[/TD]
[TD="align: right"]94[/TD]
[TD]0x3c9c530d684a99cc39388c644f21ebeeb61c2839[/TD]
[TD="align: right"]705[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]44908[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]59[/TD]
[/TR]
[TR]
[TD]Mushroom Man[/TD]
[TD="align: right"]632[/TD]
[TD="align: right"]83[/TD]
[TD]0x85dc15b8cfc601da2b4cfd2d92da9721cbc2680b[/TD]
[TD="align: right"]509[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]29126[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]12[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]5569853[/TD]
[TD="align: right"]610[/TD]
[TD="align: right"]349[/TD]
[TD="align: right"]632[/TD]
[TD="align: right"]901[/TD]
[TD="align: right"]635[/TD]
[TD="align: right"]649[/TD]
[TD="align: right"]629[/TD]
[/TR]
[TR]
[TD]Mushroom Man[/TD]
[TD="align: right"]632[/TD]
[TD="align: right"]83[/TD]
[TD]0x85dc15b8cfc601da2b4cfd2d92da9721cbc2680b[/TD]
[TD="align: right"]509[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]38543[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]12[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]130[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]536866[/TD]
[TD="align: right"]678[/TD]
[TD="align: right"]676[/TD]
[TD="align: right"]473[/TD]
[TD="align: right"]466[/TD]
[TD="align: right"]285[/TD]
[TD="align: right"]476[/TD]
[TD="align: right"]509[/TD]
[/TR]
[TR]
[TD]Mushroom Man[/TD]
[TD="align: right"]632[/TD]
[TD="align: right"]83[/TD]
[TD]0x85dc15b8cfc601da2b4cfd2d92da9721cbc2680b[/TD]
[TD="align: right"]509[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]31911[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]12[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]18921829[/TD]
[TD="align: right"]714[/TD]
[TD="align: center"]###[/TD]
[TD="align: center"]###[/TD]
[TD="align: right"]397[/TD]
[TD="align: right"]703[/TD]
[TD="align: right"]704[/TD]
[TD="align: right"]758[/TD]
[/TR]
[TR]
[TD]Mushroom Man[/TD]
[TD="align: right"]632[/TD]
[TD="align: right"]83[/TD]
[TD]0x85dc15b8cfc601da2b4cfd2d92da9721cbc2680b[/TD]
[TD="align: right"]509[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]47023[/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]46[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]62[/TD]
[/TR]
[TR]
[TD]Mushroom Man[/TD]
[TD="align: right"]632[/TD]
[TD="align: right"]83[/TD]
[TD]0x85dc15b8cfc601da2b4cfd2d92da9721cbc2680b[/TD]
[TD="align: right"]509[/TD]
[TD="align: right"]114[/TD]
[TD="align: right"]47024[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]62[/TD]
[/TR]
[TR]
[TD]Mushroom Man[/TD]
[TD="align: right"]632[/TD]
[TD="align: right"]83[/TD]
[TD]0x85dc15b8cfc601da2b4cfd2d92da9721cbc2680b[/TD]
[TD="align: right"]509[/TD]
[TD="align: right"]257[/TD]
[TD="align: right"]46384[/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]78[/TD]
[/TR]
[TR]
[TD]ももちび0215[/TD]
[TD="align: right"]452[/TD]
[TD="align: right"]53[/TD]
[TD]0x798fc047b8628533d70544a24a9ea37f92c88b64[/TD]
[TD="align: right"]953[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]49264[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]148[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]8047[/TD]
[TD="align: right"]213[/TD]
[TD="align: right"]196[/TD]
[TD="align: right"]192[/TD]
[TD="align: right"]128[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]199[/TD]
[TD="align: right"]175[/TD]
[/TR]
[TR]
[TD]ももちび0215[/TD]
[TD="align: right"]452[/TD]
[TD="align: right"]53[/TD]
[TD]0x798fc047b8628533d70544a24a9ea37f92c88b64[/TD]
[TD="align: right"]953[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]39763[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]17[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]153[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]977652[/TD]
[TD="align: right"]514[/TD]
[TD="align: right"]523[/TD]
[TD="align: right"]508[/TD]
[TD="align: right"]717[/TD]
[TD="align: right"]720[/TD]
[TD="align: right"]525[/TD]
[TD="align: right"]584[/TD]
[/TR]
[TR]
[TD]ももちび0215[/TD]
[TD="align: right"]452[/TD]
[TD="align: right"]53[/TD]
[TD]0x798fc047b8628533d70544a24a9ea37f92c88b64[/TD]
[TD="align: right"]953[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]40377[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]154[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]1062980[/TD]
[TD="align: right"]523[/TD]
[TD="align: right"]529[/TD]
[TD="align: right"]733[/TD]
[TD="align: right"]734[/TD]
[TD="align: right"]536[/TD]
[TD="align: right"]544[/TD]
[TD="align: right"]599[/TD]
[/TR]
[TR]
[TD]ももちび0215[/TD]
[TD="align: right"]452[/TD]
[TD="align: right"]53[/TD]
[TD]0x798fc047b8628533d70544a24a9ea37f92c88b64[/TD]
[TD="align: right"]953[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]44172[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]8[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]83343[/TD]
[TD="align: right"]345[/TD]
[TD="align: right"]221[/TD]
[TD="align: right"]354[/TD]
[TD="align: right"]493[/TD]
[TD="align: right"]346[/TD]
[TD="align: right"]361[/TD]
[TD="align: right"]353[/TD]
[/TR]
[TR]
[TD]ももちび0215[/TD]
[TD="align: right"]452[/TD]
[TD="align: right"]53[/TD]
[TD]0x798fc047b8628533d70544a24a9ea37f92c88b64[/TD]
[TD="align: right"]953[/TD]
[TD="align: right"]46[/TD]
[TD="align: right"]40432[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]109[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]65[/TD]
[/TR]
[TR]
[TD]ももちび0215[/TD]
[TD="align: right"]452[/TD]
[TD="align: right"]53[/TD]
[TD]0x798fc047b8628533d70544a24a9ea37f92c88b64[/TD]
[TD="align: right"]953[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]30776[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]96[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]51[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]68[/TD]
[/TR]
</tbody>[/TABLE]


In another sheet I want to be able to have a dropdown menu where I can choose an opponent's username. For example, if I choose "forest gate" I want a table to be filled in a table like the one below. Mon 1 would be the first "forest gate" mon, Mon 2 the second, and so on: Table shown below.


[TABLE="width: 1016"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Username ___ [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mon 1[/TD]
[TD][/TD]
[TD]Mon 2[/TD]
[TD][/TD]
[TD]Mon 3[/TD]
[TD][/TD]
[TD]Mon 4[/TD]
[TD][/TD]
[TD]Mon 5[/TD]
[TD][/TD]
[TD]Mon 6[/TD]
[/TR]
[TR]
[TD]Total Lvl[/TD]
[TD][/TD]
[TD]Total Lvl[/TD]
[TD][/TD]
[TD]Total Lvl[/TD]
[TD][/TD]
[TD]Total Lvl[/TD]
[TD][/TD]
[TD]Total Lvl[/TD]
[TD][/TD]
[TD]Total Lvl[/TD]
[/TR]
[TR]
[TD]HP[/TD]
[TD][/TD]
[TD]HP[/TD]
[TD][/TD]
[TD]HP[/TD]
[TD][/TD]
[TD]HP[/TD]
[TD][/TD]
[TD]HP[/TD]
[TD][/TD]
[TD]HP[/TD]
[/TR]
[TR]
[TD]PA[/TD]
[TD][/TD]
[TD]PA[/TD]
[TD][/TD]
[TD]PA[/TD]
[TD][/TD]
[TD]PA[/TD]
[TD][/TD]
[TD]PA[/TD]
[TD][/TD]
[TD]PA[/TD]
[/TR]
[TR]
[TD]PD[/TD]
[TD][/TD]
[TD]PD[/TD]
[TD][/TD]
[TD]PD[/TD]
[TD][/TD]
[TD]PD[/TD]
[TD][/TD]
[TD]PD[/TD]
[TD][/TD]
[TD]PD[/TD]
[/TR]
[TR]
[TD]SA[/TD]
[TD][/TD]
[TD]SA[/TD]
[TD][/TD]
[TD]SA[/TD]
[TD][/TD]
[TD]SA[/TD]
[TD][/TD]
[TD]SA[/TD]
[TD][/TD]
[TD]SA[/TD]
[/TR]
[TR]
[TD]SD[/TD]
[TD][/TD]
[TD]SD[/TD]
[TD][/TD]
[TD]SD[/TD]
[TD][/TD]
[TD]SD[/TD]
[TD][/TD]
[TD]SD[/TD]
[TD][/TD]
[TD]SD[/TD]
[/TR]
[TR]
[TD]SPD[/TD]
[TD][/TD]
[TD]SPD[/TD]
[TD][/TD]
[TD]SPD[/TD]
[TD][/TD]
[TD]SPD[/TD]
[TD][/TD]
[TD]SPD[/TD]
[TD][/TD]
[TD]SPD[/TD]
[/TR]
[TR]
[TD]Class ID[/TD]
[TD][/TD]
[TD]Class ID[/TD]
[TD][/TD]
[TD]Class ID[/TD]
[TD][/TD]
[TD]Class ID[/TD]
[TD][/TD]
[TD]Class ID[/TD]
[TD][/TD]
[TD]Class ID[/TD]
[/TR]
[TR]
[TD]Type 1[/TD]
[TD][/TD]
[TD]Type 1[/TD]
[TD][/TD]
[TD]Type 1[/TD]
[TD][/TD]
[TD]Type 1[/TD]
[TD][/TD]
[TD]Type 1[/TD]
[TD][/TD]
[TD]Type 1[/TD]
[/TR]
[TR]
[TD]Type 2[/TD]
[TD][/TD]
[TD]Type 2[/TD]
[TD][/TD]
[TD]Type 2[/TD]
[TD][/TD]
[TD]Type 2[/TD]
[TD][/TD]
[TD]Type 2[/TD]
[TD][/TD]
[TD]Type 2[/TD]
[/TR]
[TR]
[TD]Gason Y/N[/TD]
[TD][/TD]
[TD]Gason Y/N[/TD]
[TD][/TD]
[TD]Gason Y/N[/TD]
[TD][/TD]
[TD]Gason Y/N[/TD]
[TD][/TD]
[TD]Gason Y/N[/TD]
[TD][/TD]
[TD]Gason Y/N[/TD]
[/TR]
</tbody>[/TABLE]


Ideally I'd like for the drop down to not have duplicates. If I don't use a custom formula I'd see each username 6 times. I'd also like the drop down to be able to show any usernames that appear (not have trouble if VBA imports more than X number of opponents. I'm stuck on how to start this. Any help is greatly appreciated. Thanks in advance.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Sort by date Sort by votes
You could use this formula option, assuming that your stats tab starts from A1;


Book1
ABCDEFG
1
2Player Name
3forest gate
4
5PlayerMon 1Mon 2Mon 3Mon 4Mon 5Mon 6
6Total Lvl658582111
7HP514637612875667
8PA7026476037682103
9PD470583859928287
10SA682591604567552
11SD2759106037883102
12SPD491578614626972
13Class ID137108157798097
14Type 111491416
15Type 2176171790
16Gason Y/NFALSEFALSEFALSEFALSEFALSEFALSE
Sheet2
Cell Formulas
RangeFormula
B6{=IF(COLUMNS(Sheet2!$B$6:B6)>COUNTIF(Sheet1!$A$2:$A$49,Sheet2!$A$3),"",INDEX(Sheet1!$O$2:$O$49,SMALL(IF(Sheet1!$A$2:$A$49=Sheet2!$A$3,ROW(Sheet1!$A$2:$A$49)-ROW(Sheet1!$A$2)+1),COLUMNS(Sheet2!$B$6:B6))))}
B7{=IF(COLUMNS(Sheet2!$B$6:B6)>COUNTIF(Sheet1!$A$2:$A$49,Sheet2!$A$3),"",INDEX(Sheet1!$Q$2:$Q$49,SMALL(IF(Sheet1!$A$2:$A$49=Sheet2!$A$3,ROW(Sheet1!$A$2:$A$49)-ROW(Sheet1!$A$2)+1),COLUMNS(Sheet2!$B$6:B6))))}
B8{=IF(COLUMNS(Sheet2!$B$6:B6)>COUNTIF(Sheet1!$A$2:$A$49,Sheet2!$A$3),"",INDEX(Sheet1!$R$2:$R$49,SMALL(IF(Sheet1!$A$2:$A$49=Sheet2!$A$3,ROW(Sheet1!$A$2:$A$49)-ROW(Sheet1!$A$2)+1),COLUMNS(Sheet2!$B$6:B6))))}
B9{=IF(COLUMNS(Sheet2!$B$6:B6)>COUNTIF(Sheet1!$A$2:$A$49,Sheet2!$A$3),"",INDEX(Sheet1!$S$2:$S$49,SMALL(IF(Sheet1!$A$2:$A$49=Sheet2!$A$3,ROW(Sheet1!$A$2:$A$49)-ROW(Sheet1!$A$2)+1),COLUMNS(Sheet2!$B$6:B6))))}
B10{=IF(COLUMNS(Sheet2!$B$6:B6)>COUNTIF(Sheet1!$A$2:$A$49,Sheet2!$A$3),"",INDEX(Sheet1!$T$2:$T$49,SMALL(IF(Sheet1!$A$2:$A$49=Sheet2!$A$3,ROW(Sheet1!$A$2:$A$49)-ROW(Sheet1!$A$2)+1),COLUMNS(Sheet2!$B$6:B6))))}
B11{=IF(COLUMNS(Sheet2!$B$6:B6)>COUNTIF(Sheet1!$A$2:$A$49,Sheet2!$A$3),"",INDEX(Sheet1!$U$2:$U$49,SMALL(IF(Sheet1!$A$2:$A$49=Sheet2!$A$3,ROW(Sheet1!$A$2:$A$49)-ROW(Sheet1!$A$2)+1),COLUMNS(Sheet2!$B$6:B6))))}
B12{=IF(COLUMNS(Sheet2!$B$6:B6)>COUNTIF(Sheet1!$A$2:$A$49,Sheet2!$A$3),"",INDEX(Sheet1!$V$2:$V$49,SMALL(IF(Sheet1!$A$2:$A$49=Sheet2!$A$3,ROW(Sheet1!$A$2:$A$49)-ROW(Sheet1!$A$2)+1),COLUMNS(Sheet2!$B$6:B6))))}
B13{=IF(COLUMNS(Sheet2!$B$6:B6)>COUNTIF(Sheet1!$A$2:$A$49,Sheet2!$A$3),"",INDEX(Sheet1!$N$2:$N$49,SMALL(IF(Sheet1!$A$2:$A$49=Sheet2!$A$3,ROW(Sheet1!$A$2:$A$49)-ROW(Sheet1!$A$2)+1),COLUMNS(Sheet2!$B$6:B6))))}
B14{=IF(COLUMNS(Sheet2!$B$6:B6)>COUNTIF(Sheet1!$A$2:$A$49,Sheet2!$A$3),"",INDEX(Sheet1!$H$2:$H$49,SMALL(IF(Sheet1!$A$2:$A$49=Sheet2!$A$3,ROW(Sheet1!$A$2:$A$49)-ROW(Sheet1!$A$2)+1),COLUMNS(Sheet2!$B$6:B6))))}
B15{=IF(COLUMNS(Sheet2!$B$6:B6)>COUNTIF(Sheet1!$A$2:$A$49,Sheet2!$A$3),"",INDEX(Sheet1!$I$2:$I$49,SMALL(IF(Sheet1!$A$2:$A$49=Sheet2!$A$3,ROW(Sheet1!$A$2:$A$49)-ROW(Sheet1!$A$2)+1),COLUMNS(Sheet2!$B$6:B6))))}
B16{=IF(COLUMNS(Sheet2!$B$6:B6)>COUNTIF(Sheet1!$A$2:$A$49,Sheet2!$A$3),"",INDEX(Sheet1!$J$2:$J$49,SMALL(IF(Sheet1!$A$2:$A$49=Sheet2!$A$3,ROW(Sheet1!$A$2:$A$49)-ROW(Sheet1!$A$2)+1),COLUMNS(Sheet2!$B$6:B6))))}
Press CTRL+SHIFT+ENTER to enter array formulas.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
VBA macro to search each sheet cell for specific text and print to PDF when true
Replies
6
Views
996
camerong
C
H
  • Question Question
Excel Table Representation Query: 2 columns in the data set with dates which needs to be aligned to get right result.
Replies
1
Views
566
GraH
GraH
J
  • Solved
how to random all numbers
Replies
7
Views
270
Fluff
Fluff
M
  • Solved
VBA Transpose data from one sheet into another
Replies
9
Views
589
madi1004
M
W
  • Solved
Removing Data Validation List Items Once Selected In Another Cell
Replies
3
Views
732
James006
James006

Forum statistics

Threads
1,223,896
Messages
6,175,265
Members
452,627
Latest member
KitkatToby

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