Collect Tab information to create a main list

C

CR9596

New Member
Joined
Aug 3, 2018
Messages
2
I am working with an excel workbook(google sheet) which has about 78 tabs. Each tab has information such as contact information, location, group name, etc. With all of that information I need to compose main list. As well as to reflect any information they add or remove. I thought of using the formula =(tabName)!(cellNum) and it does what its needed. The problem is that I have to set a number of rows. If I set it to list 10 and if the tab they add 20 then the main list will not reflect it. I also have to name every single tab name. Does anybody know a different way for this to be done?

Below is the example. First table is the main list(end result). Second table, Alphabet Studies its a tab example where the user will be entering the data. Third table, Drawing table its another tab for entry data.
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}


[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH]Studies type[/TH]
[TH]GroupID[/TH]
[TH]City1[/TH]
[TH]City2[/TH]
[TH]City3[/TH]
[TH]City4[/TH]
[TH]City5[/TH]
[TH]City6[/TH]
[TH]City7[/TH]
[TH]City8[/TH]
[TH]City9[/TH]
[TH]City10[/TH]
[TH]Region[/TH]
[TH]Member's Name[/TH]
[TH]Member Since[/TH]
[TH]Company[/TH]
[TH]Title[/TH]
[TH]Address[/TH]
[TH]City[/TH]
[TH]State[/TH]
[TH]Zip[/TH]
[TH]Email[/TH]
[TH]Phone[/TH]
[TH]Group President Name:[/TH]
[TH]Group President City Loc.:[/TH]
[TH]Group President Phone Num.:[/TH]
[TH]Group President Email:[/TH]
[TH]Group Tresuare Name:[/TH]
[TH]Group Tresuare City Loc.:[/TH]
[TH]Group Tresuare Phone Num.:[/TH]
[TH]Group Tresuare Email:[/TH]
[TH]Secretary Name:[/TH]
[TH]Secretary City Loc.:[/TH]
[TH]Secretary Phone Num.:[/TH]
[TH]Secretary Email:[/TH]
[/TR]
</thead><tbody> [TR]
[TD]Alphabet Studies[/TD]
[TD]ABC.DE[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]South[/TD]
[TD]Batman Guy[/TD]
[TD]28642[/TD]
[TD]xyz[/TD]
[TD]Business Relationship[/TD]
[TD]123 ABC Street[/TD]
[TD]Hollywood[/TD]
[TD]CA[/TD]
[TD]77788[/TD]
[TD]bat@xyz.com[/TD]
[TD]888-123-4545[/TD]
[TD]John Doe[/TD]
[TD]Hawaii[/TD]
[TD]123-444-5555[/TD]
[TD]jd@att.com[/TD]
[TD]Jack Brown[/TD]
[TD]sydney[/TD]
[TD]111-222-8888[/TD]
[TD]jb@abc.com[/TD]
[TD]Miss A[/TD]
[TD]canada[/TD]
[TD]888-999-888[/TD]
[TD]ma@net.com[/TD]
[/TR]
[TR]
[TD]Alphabet Studies[/TD]
[TD]ABC.DE[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]South west[/TD]
[TD]Robin Hood[/TD]
[TD]32070[/TD]
[TD]123[/TD]
[TD]CEO[/TD]
[TD]345 Stree C[/TD]
[TD]Seatle[/TD]
[TD]WA[/TD]
[TD]55236[/TD]
[TD]rb@123.com[/TD]
[TD]888-123-4546[/TD]
[TD]John Doe[/TD]
[TD]Hawaii[/TD]
[TD]123-444-5555[/TD]
[TD]jd@att.com[/TD]
[TD]Jack Brown[/TD]
[TD]sydney[/TD]
[TD]111-222-8888[/TD]
[TD]jb@abc.com[/TD]
[TD]Miss A[/TD]
[TD]canada[/TD]
[TD]888-999-888[/TD]
[TD]ma@net.com[/TD]
[/TR]
[TR]
[TD]Alphabet Studies[/TD]
[TD]ABC.DE[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]North[/TD]
[TD]Samuel Clements[/TD]
[TD]1797[/TD]
[TD]Bluebird[/TD]
[TD]Marketing specialist[/TD]
[TD]987 L. house Street[/TD]
[TD]Helena[/TD]
[TD]mt[/TD]
[TD]58964[/TD]
[TD]sc@bluebird.com[/TD]
[TD]888-123-4547[/TD]
[TD]John Doe[/TD]
[TD]Hawaii[/TD]
[TD]123-444-5555[/TD]
[TD]jd@att.com[/TD]
[TD]Jack Brown[/TD]
[TD]sydney[/TD]
[TD]111-222-8888[/TD]
[TD]jb@abc.com[/TD]
[TD]Miss A[/TD]
[TD]canada[/TD]
[TD]888-999-888[/TD]
[TD]ma@net.com[/TD]
[/TR]
[TR]
[TD]Alphabet Studies[/TD]
[TD]ABC.DE[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]Central[/TD]
[TD]Laura Ingalls[/TD]
[TD]40490[/TD]
[TD]Ford[/TD]
[TD]Data entry[/TD]
[TD]23B Detroit Lane[/TD]
[TD]jefferson city[/TD]
[TD]MO[/TD]
[TD]56894[/TD]
[TD]li@ford.com[/TD]
[TD]888-123-4548[/TD]
[TD]John Doe[/TD]
[TD]Hawaii[/TD]
[TD]123-444-5555[/TD]
[TD]jd@att.com[/TD]
[TD]Jack Brown[/TD]
[TD]sydney[/TD]
[TD]111-222-8888[/TD]
[TD]jb@abc.com[/TD]
[TD]Miss A[/TD]
[TD]canada[/TD]
[TD]888-999-888[/TD]
[TD]ma@net.com[/TD]
[/TR]
[TR]
[TD]Drawing Studies[/TD]
[TD]DFG.ZY[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]South[/TD]
[TD]Jackson River[/TD]
[TD]65167[/TD]
[TD]Yellow stone[/TD]
[TD]Busines Manager[/TD]
[TD]Arizona Street[/TD]
[TD]Hollywood[/TD]
[TD]CA[/TD]
[TD]77788[/TD]
[TD]jart@yellow.com[/TD]
[TD]888-123-4549[/TD]
[TD]Jefferson Williams[/TD]
[TD]Springfield[/TD]
[TD]888-444-5555[/TD]
[TD]jw@text.com[/TD]
[TD]Ken Frankfort[/TD]
[TD]Idianapolis[/TD]
[TD]211-555-8888[/TD]
[TD]kf@indiana.com[/TD]
[TD]Miss B[/TD]
[TD]Dayton[/TD]
[TD]333-999-888[/TD]
[TD]mb@jackson.com[/TD]
[/TR]
[TR]
[TD]Drawing Studies[/TD]
[TD]DFG.ZY[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]South west[/TD]
[TD]Susan Salter[/TD]
[TD]31956[/TD]
[TD]Civil War[/TD]
[TD]Sales Representative[/TD]
[TD]L Street[/TD]
[TD]Seatle[/TD]
[TD]WA[/TD]
[TD]55236[/TD]
[TD]ss@cwar.com[/TD]
[TD]888-123-4550[/TD]
[TD]Jefferson Williams[/TD]
[TD]Springfield[/TD]
[TD]888-444-5555[/TD]
[TD]jw@text.com[/TD]
[TD]Ken Frankfort[/TD]
[TD]Idianapolis[/TD]
[TD]211-555-8888[/TD]
[TD]kf@indiana.com[/TD]
[TD]Miss B[/TD]
[TD]Dayton[/TD]
[TD]333-999-888[/TD]
[TD]mb@jackson.com[/TD]
[/TR]
[TR]
[TD]Drawing Studies[/TD]
[TD]DFG.ZY[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]North[/TD]
[TD]Mary Hays[/TD]
[TD]1797[/TD]
[TD]Hilton Inc.[/TD]
[TD]Business Relationship[/TD]
[TD]95 beach house Street[/TD]
[TD]san francisco[/TD]
[TD]Ca[/TD]
[TD]58964[/TD]
[TD]mh@hilton.com[/TD]
[TD]888-123-4551[/TD]
[TD]Jefferson Williams[/TD]
[TD]Springfield[/TD]
[TD]888-444-5555[/TD]
[TD]jw@text.com[/TD]
[TD]Ken Frankfort[/TD]
[TD]Idianapolis[/TD]
[TD]211-555-8888[/TD]
[TD]kf@indiana.com[/TD]
[TD]Miss B[/TD]
[TD]Dayton[/TD]
[TD]333-999-888[/TD]
[TD]mb@jackson.com[/TD]
[/TR]
[TR]
[TD]Drawing Studies[/TD]
[TD]DFG.ZY[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]Central[/TD]
[TD]Alan shepard[/TD]
[TD]40490[/TD]
[TD]Hershey's[/TD]
[TD]Teacher[/TD]
[TD]85 Rio Avenue[/TD]
[TD]cordoba[/TD]
[TD]AL[/TD]
[TD]56894[/TD]
[TD]li@hersheys.com[/TD]
[TD]888-123-4552[/TD]
[TD]Jefferson Williams[/TD]
[TD]Springfield[/TD]
[TD]888-444-5555[/TD]
[TD]jw@text.com[/TD]
[TD]Ken Frankfort[/TD]
[TD]Idianapolis[/TD]
[TD]211-555-8888[/TD]
[TD]kf@indiana.com[/TD]
[TD]Miss B[/TD]
[TD]Dayton[/TD]
[TD]333-999-888[/TD]
[TD]mb@jackson.com[/TD]
[/TR]
[TR]
[TD]Drawing Studies[/TD]
[TD]DFG.ZY[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]South[/TD]
[TD]Robert Frost[/TD]
[TD]28642[/TD]
[TD]Zoo[/TD]
[TD]Animal Control[/TD]
[TD]930 Pluto Lane[/TD]
[TD]Hartford[/TD]
[TD]Ct[/TD]
[TD]77788[/TD]
[TD]bat@zoo.com[/TD]
[TD]0[/TD]
[TD]Jefferson Williams[/TD]
[TD]Springfield[/TD]
[TD]888-444-5555[/TD]
[TD]jw@text.com[/TD]
[TD]Ken Frankfort[/TD]
[TD]Idianapolis[/TD]
[TD]211-555-8888[/TD]
[TD]kf@indiana.com[/TD]
[TD]Miss B[/TD]
[TD]Dayton[/TD]
[TD]333-999-888[/TD]
[TD]mb@jackson.com[/TD]
[/TR]
[TR]
[TD]Drawing Studies[/TD]
[TD]DFG.ZY[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]North[/TD]
[TD]John Hancock[/TD]
[TD]32070[/TD]
[TD]Football hall[/TD]
[TD]Coach[/TD]
[TD]867 Alaska St.[/TD]
[TD]Orlando[/TD]
[TD]FL[/TD]
[TD]55236[/TD]
[TD]rb@football.com[/TD]
[TD]888-123-4554[/TD]
[TD]Jefferson Williams[/TD]
[TD]Springfield[/TD]
[TD]888-444-5555[/TD]
[TD]jw@text.com[/TD]
[TD]Ken Frankfort[/TD]
[TD]Idianapolis[/TD]
[TD]211-555-8888[/TD]
[TD]kf@indiana.com[/TD]
[TD]Miss B[/TD]
[TD]Dayton[/TD]
[TD]333-999-888[/TD]
[TD]mb@jackson.com[/TD]
[/TR]
[TR]
[TD]Drawing Studies[/TD]
[TD]DFG.ZY[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]North[/TD]
[TD]Lewis Clark[/TD]
[TD]1797[/TD]
[TD]Cardinal tech[/TD]
[TD]Field tech.[/TD]
[TD]494 Golden Gate[/TD]
[TD]Helena[/TD]
[TD]mt[/TD]
[TD]58964[/TD]
[TD]sc@cartech.com[/TD]
[TD]888-123-4555[/TD]
[TD]Jefferson Williams[/TD]
[TD]Springfield[/TD]
[TD]888-444-5555[/TD]
[TD]jw@text.com[/TD]
[TD]Ken Frankfort[/TD]
[TD]Idianapolis[/TD]
[TD]211-555-8888[/TD]
[TD]kf@indiana.com[/TD]
[TD]Miss B[/TD]
[TD]Dayton[/TD]
[TD]333-999-888[/TD]
[TD]mb@jackson.com[/TD]
[/TR]
[TR]
[TD]Drawing Studies[/TD]
[TD]DFG.ZY[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]West[/TD]
[TD]James Cook[/TD]
[TD]40490[/TD]
[TD]cherokee[/TD]
[TD]Sales Representative[/TD]
[TD]23B Detroit Lane[/TD]
[TD]jefferson city[/TD]
[TD]MO[/TD]
[TD]56894[/TD]
[TD]li@cherokeecom[/TD]
[TD]888-444-5555[/TD]
[TD]Jefferson Williams[/TD]
[TD]Springfield[/TD]
[TD]888-444-5555[/TD]
[TD]jw@text.com[/TD]
[TD]Ken Frankfort[/TD]
[TD]Idianapolis[/TD]
[TD]211-555-8888[/TD]
[TD]kf@indiana.com[/TD]
[TD]Miss B[/TD]
[TD]Dayton[/TD]
[TD]333-999-888[/TD]
[TD]mb@jackson.com[/TD]
[/TR]
[TR]
[TD]Drawing Studies[/TD]
[TD]DFG.ZY[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]South[/TD]
[TD]Eli Whitney[/TD]
[TD]28642[/TD]
[TD]National parks[/TD]
[TD]Director of plants[/TD]
[TD]123 ABC Street[/TD]
[TD]Hollywood[/TD]
[TD]CA[/TD]
[TD]77788[/TD]
[TD]bat@nationalparks.com[/TD]
[TD]0[/TD]
[TD]Jefferson Williams[/TD]
[TD]Springfield[/TD]
[TD]888-444-5555[/TD]
[TD]jw@text.com[/TD]
[TD]Ken Frankfort[/TD]
[TD]Idianapolis[/TD]
[TD]211-555-8888[/TD]
[TD]kf@indiana.com[/TD]
[TD]Miss B[/TD]
[TD]Dayton[/TD]
[TD]333-999-888[/TD]
[TD]mb@jackson.com[/TD]
[/TR]
[TR]
[TD]Drawing Studies[/TD]
[TD]DFG.ZY[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]North east[/TD]
[TD]Walt Disneyh[/TD]
[TD]32070[/TD]
[TD]health technologies[/TD]
[TD]Nurse Tech.[/TD]
[TD]345 Stree C[/TD]
[TD]Seatle[/TD]
[TD]WA[/TD]
[TD]55236[/TD]
[TD]rb@flower.com[/TD]
[TD]211-555-8854[/TD]
[TD]Jefferson Williams[/TD]
[TD]Springfield[/TD]
[TD]888-444-5555[/TD]
[TD]jw@text.com[/TD]
[TD]Ken Frankfort[/TD]
[TD]Idianapolis[/TD]
[TD]211-555-8888[/TD]
[TD]kf@indiana.com[/TD]
[TD]Miss B[/TD]
[TD]Dayton[/TD]
[TD]333-999-888[/TD]
[TD]mb@jackson.com[/TD]
[/TR]
[TR]
[TD]Drawing Studies[/TD]
[TD]DFG.ZY[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]East[/TD]
[TD]Noah Webster[/TD]
[TD]1797[/TD]
[TD]Flower delivery[/TD]
[TD]Gardener[/TD]
[TD]987 L. house Street[/TD]
[TD]Atlanta [/TD]
[TD]GA[/TD]
[TD]58964[/TD]
[TD]0[/TD]
[TD]211-555-8855[/TD]
[TD]Jefferson Williams[/TD]
[TD]Springfield[/TD]
[TD]888-444-5555[/TD]
[TD]jw@text.com[/TD]
[TD]Ken Frankfort[/TD]
[TD]Idianapolis[/TD]
[TD]211-555-8888[/TD]
[TD]kf@indiana.com[/TD]
[TD]Miss B[/TD]
[TD]Dayton[/TD]
[TD]333-999-888[/TD]
[TD]mb@jackson.com[/TD]
[/TR]
[TR]
[TD]Drawing Studies[/TD]
[TD]DFG.ZY[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]East[/TD]
[TD]Cody Bill[/TD]
[TD]40490[/TD]
[TD]Bird Academy[/TD]
[TD]Sales Representative[/TD]
[TD]23B Detroit Lane[/TD]
[TD]macon[/TD]
[TD]GA[/TD]
[TD]56894[/TD]
[TD]0[/TD]
[TD]211-555-8856[/TD]
[TD]Jefferson Williams[/TD]
[TD]Springfield[/TD]
[TD]888-444-5555[/TD]
[TD]jw@text.com[/TD]
[TD]Ken Frankfort[/TD]
[TD]Idianapolis[/TD]
[TD]211-555-8888[/TD]
[TD]kf@indiana.com[/TD]
[TD]Miss B[/TD]
[TD]Dayton[/TD]
[TD]333-999-888[/TD]
[TD]mb@jackson.com[/TD]
[/TR]
[TR]
[TD]Drawing Studies[/TD]
[TD]DFG.ZY[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]Central[/TD]
[TD]james marshall[/TD]
[TD]28642[/TD]
[TD]Telegraph[/TD]
[TD]Networking administrator[/TD]
[TD]123 ABC Street[/TD]
[TD]Charlotte[/TD]
[TD]NC[/TD]
[TD]25368[/TD]
[TD]sc@telegraph.com[/TD]
[TD]333-999-889[/TD]
[TD]Jefferson Williams[/TD]
[TD]Springfield[/TD]
[TD]888-444-5555[/TD]
[TD]jw@text.com[/TD]
[TD]Ken Frankfort[/TD]
[TD]Idianapolis[/TD]
[TD]211-555-8888[/TD]
[TD]kf@indiana.com[/TD]
[TD]Miss B[/TD]
[TD]Dayton[/TD]
[TD]333-999-888[/TD]
[TD]mb@jackson.com[/TD]
[/TR]
[TR]
[TD]Drawing Studies[/TD]
[TD]DFG.ZY[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]0[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]South west[/TD]
[TD]William Seward[/TD]
[TD]32070[/TD]
[TD]innovations technologies[/TD]
[TD]Web specialist[/TD]
[TD]345 Stree C[/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]78989[/TD]
[TD]li@InnoTech.com[/TD]
[TD]333-999-890[/TD]
[TD]Jefferson Williams[/TD]
[TD]Springfield[/TD]
[TD]888-444-5555[/TD]
[TD]jw@text.com[/TD]
[TD]Ken Frankfort[/TD]
[TD]Idianapolis[/TD]
[TD]211-555-8888[/TD]
[TD]kf@indiana.com[/TD]
[TD]Miss B[/TD]
[TD]Dayton[/TD]
[TD]333-999-888[/TD]
[TD]mb@jackson.com[/TD]
[/TR]
</tbody>[/TABLE]





[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH]Alphabet Studies[/TH]
[TH] [/TH]
[TH] [/TH]
[TH]City1[/TH]
[TH]City2[/TH]
[TH]City3[/TH]
[TH]City4[/TH]
[TH]City5[/TH]
[TH]City6[/TH]
[TH]City7[/TH]
[TH]City8[/TH]
[TH]City9[/TH]
[TH]City10[/TH]
[/TR]
</thead><tbody> [TR]
[TD]GroupID[/TD]
[TD]ABC.DE[/TD]
[TD]City[/TD]
[TD]x[/TD]
[TD] [/TD]
[TD]x[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]x[/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]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Name:[/TD]
[TD]City Loc.:[/TD]
[TD]Phone Num.:[/TD]
[TD]Email:[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Group President[/TD]
[TD]John Doe[/TD]
[TD]Hawaii[/TD]
[TD]123-444-5555[/TD]
[TD]jd@att.com[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Group Tresuare[/TD]
[TD]Jack Brown[/TD]
[TD]sydney[/TD]
[TD]111-222-8888[/TD]
[TD]jb@abc.com[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Secretary[/TD]
[TD]Miss A[/TD]
[TD]canada[/TD]
[TD]888-999-888[/TD]
[TD]ma@net.com[/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]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Region[/TD]
[TD]Member's Name[/TD]
[TD]Member Since dd/mm/yyyy[/TD]
[TD]Company[/TD]
[TD]Title[/TD]
[TD]Address[/TD]
[TD] [/TD]
[TD]City[/TD]
[TD]State[/TD]
[TD]Zip[/TD]
[TD]Email[/TD]
[TD] [/TD]
[TD]Phone[/TD]
[/TR]
[TR]
[TD]South[/TD]
[TD]Batman Guy[/TD]
[TD]6/1/1978[/TD]
[TD]xyz[/TD]
[TD]Business Relationship[/TD]
[TD]123 ABC Street[/TD]
[TD] [/TD]
[TD]Hollywood[/TD]
[TD]CA[/TD]
[TD]77788[/TD]
[TD]bat@xyz.com[/TD]
[TD] [/TD]
[TD]888-123-4545[/TD]
[/TR]
[TR]
[TD]South west[/TD]
[TD]Robin Hood[/TD]
[TD]10/20/1987[/TD]
[TD]123[/TD]
[TD]CEO[/TD]
[TD]345 Stree C[/TD]
[TD] [/TD]
[TD]Seatle[/TD]
[TD]WA[/TD]
[TD]55236[/TD]
[TD]rb@123.com[/TD]
[TD] [/TD]
[TD]888-123-4546[/TD]
[/TR]
[TR]
[TD]North[/TD]
[TD]Samuel Clements[/TD]
[TD]Dec-04[/TD]
[TD]Bluebird[/TD]
[TD]Marketing specialist[/TD]
[TD]987 L. house Street[/TD]
[TD] [/TD]
[TD]Helena[/TD]
[TD]mt[/TD]
[TD]58964[/TD]
[TD]sc@bluebird.com[/TD]
[TD] [/TD]
[TD]888-123-4547[/TD]
[/TR]
[TR]
[TD]Central[/TD]
[TD]Laura Ingalls[/TD]
[TD]11/8/2010[/TD]
[TD]Ford[/TD]
[TD]Data entry[/TD]
[TD]23B Detroit Lane[/TD]
[TD] [/TD]
[TD]jefferson city[/TD]
[TD]MO[/TD]
[TD]56894[/TD]
[TD]li@ford.com[/TD]
[TD] [/TD]
[TD]888-123-4548[/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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[TD] [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>


























[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH]Drawing Studies[/TH]
[TH] [/TH]
[TH] [/TH]
[TH]City1[/TH]
[TH]City2[/TH]
[TH]City3[/TH]
[TH]City4[/TH]
[TH]City5[/TH]
[TH]City6[/TH]
[TH]City7[/TH]
[TH]City8[/TH]
[TH]City9[/TH]
[TH]City10[/TH]
[/TR]
</thead><tbody> [TR]
[TD]GroupID[/TD]
[TD]DFG.ZY[/TD]
[TD]City[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]x[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD] [/TD]
[TD]x[/TD]
[TD]x[/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]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Name:[/TD]
[TD]City Loc.:[/TD]
[TD]Phone Num.:[/TD]
[TD]Email:[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Group President[/TD]
[TD]Jefferson Williams[/TD]
[TD]Springfield[/TD]
[TD]888-444-5555[/TD]
[TD]jw@text.com[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Group Tresuare[/TD]
[TD]Ken Frankfort[/TD]
[TD]Idianapolis[/TD]
[TD]211-555-8888[/TD]
[TD]kf@indiana.com[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Secretary[/TD]
[TD]Miss B[/TD]
[TD]Dayton[/TD]
[TD]333-999-888[/TD]
[TD]mb@jackson.com[/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]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Region[/TD]
[TD]Member's Name[/TD]
[TD]Member Since[/TD]
[TD]Company[/TD]
[TD]Title[/TD]
[TD]Address[/TD]
[TD] [/TD]
[TD]City[/TD]
[TD]State[/TD]
[TD]Zip[/TD]
[TD]Email[/TD]
[TD] [/TD]
[TD]Phone[/TD]
[/TR]
[TR]
[TD]South[/TD]
[TD]Jackson River[/TD]
[TD]6/1/2078[/TD]
[TD]Yellow stone[/TD]
[TD]Busines Manager[/TD]
[TD]Arizona Street[/TD]
[TD] [/TD]
[TD]Hollywood[/TD]
[TD]CA[/TD]
[TD]77788[/TD]
[TD]jart@yellow.com[/TD]
[TD] [/TD]
[TD]888-123-4549[/TD]
[/TR]
[TR]
[TD]South west[/TD]
[TD]Susan Salter[/TD]
[TD]6/28/1987[/TD]
[TD]Civil War[/TD]
[TD]Sales Representative[/TD]
[TD]L Street[/TD]
[TD] [/TD]
[TD]Seatle[/TD]
[TD]WA[/TD]
[TD]55236[/TD]
[TD]ss@cwar.com[/TD]
[TD] [/TD]
[TD]888-123-4550[/TD]
[/TR]
[TR]
[TD]North[/TD]
[TD]Mary Hays[/TD]
[TD]Dec-04[/TD]
[TD]Hilton Inc.[/TD]
[TD]Business Relationship[/TD]
[TD]95 beach house Street[/TD]
[TD] [/TD]
[TD]san francisco[/TD]
[TD]Ca[/TD]
[TD]58964[/TD]
[TD]mh@hilton.com[/TD]
[TD] [/TD]
[TD]888-123-4551[/TD]
[/TR]
[TR]
[TD]Central[/TD]
[TD]Alan shepard[/TD]
[TD]11/8/2010[/TD]
[TD]Hershey's[/TD]
[TD]Teacher[/TD]
[TD]85 Rio Avenue[/TD]
[TD] [/TD]
[TD]cordoba[/TD]
[TD]AL[/TD]
[TD]56894[/TD]
[TD]li@hersheys.com[/TD]
[TD] [/TD]
[TD]888-123-4552[/TD]
[/TR]
[TR]
[TD]South[/TD]
[TD]Robert Frost[/TD]
[TD]6/1/1978[/TD]
[TD]Zoo[/TD]
[TD]Animal Control[/TD]
[TD]930 Pluto Lane[/TD]
[TD] [/TD]
[TD]Hartford[/TD]
[TD]Ct[/TD]
[TD]77788[/TD]
[TD]bat@zoo.com[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]North[/TD]
[TD]John Hancock[/TD]
[TD]10/20/1987[/TD]
[TD]Football hall[/TD]
[TD]Coach[/TD]
[TD]867 Alaska St.[/TD]
[TD] [/TD]
[TD]Orlando[/TD]
[TD]FL[/TD]
[TD]55236[/TD]
[TD]rb@football.com[/TD]
[TD] [/TD]
[TD]888-123-4554[/TD]
[/TR]
[TR]
[TD]North[/TD]
[TD]Lewis Clark[/TD]
[TD]Dec-04[/TD]
[TD]Cardinal tech[/TD]
[TD]Field tech.[/TD]
[TD]494 Golden Gate[/TD]
[TD] [/TD]
[TD]Helena[/TD]
[TD]mt[/TD]
[TD]58964[/TD]
[TD]sc@cartech.com[/TD]
[TD] [/TD]
[TD]888-123-4555[/TD]
[/TR]
[TR]
[TD]West[/TD]
[TD]James Cook[/TD]
[TD]11/8/2010[/TD]
[TD]cherokee[/TD]
[TD]Sales Representative[/TD]
[TD]23B Detroit Lane[/TD]
[TD] [/TD]
[TD]jefferson city[/TD]
[TD]MO[/TD]
[TD]56894[/TD]
[TD]li@cherokeecom[/TD]
[TD] [/TD]
[TD]888-444-5555[/TD]
[/TR]
[TR]
[TD]South[/TD]
[TD]Eli Whitney[/TD]
[TD]6/1/1978[/TD]
[TD]National parks[/TD]
[TD]Director of plants[/TD]
[TD]123 ABC Street[/TD]
[TD] [/TD]
[TD]Hollywood[/TD]
[TD]CA[/TD]
[TD]77788[/TD]
[TD]bat@nationalparks.com[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]North east[/TD]
[TD]Walt Disneyh[/TD]
[TD]10/20/1987[/TD]
[TD]health technologies[/TD]
[TD]Nurse Tech.[/TD]
[TD]345 Stree C[/TD]
[TD] [/TD]
[TD]Seatle[/TD]
[TD]WA[/TD]
[TD]55236[/TD]
[TD]rb@flower.com[/TD]
[TD] [/TD]
[TD]211-555-8854[/TD]
[/TR]
[TR]
[TD]East[/TD]
[TD]Noah Webster[/TD]
[TD]Dec-04[/TD]
[TD]Flower delivery[/TD]
[TD]Gardener[/TD]
[TD]987 L. house Street[/TD]
[TD] [/TD]
[TD]Atlanta [/TD]
[TD]GA[/TD]
[TD]58964[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]211-555-8855[/TD]
[/TR]
[TR]
[TD]East[/TD]
[TD]Cody Bill[/TD]
[TD]11/8/2010[/TD]
[TD]Bird Academy[/TD]
[TD]Sales Representative[/TD]
[TD]23B Detroit Lane[/TD]
[TD] [/TD]
[TD]macon[/TD]
[TD]GA[/TD]
[TD]56894[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]211-555-8856[/TD]
[/TR]
[TR]
[TD]Central[/TD]
[TD]james marshall[/TD]
[TD]6/1/1978[/TD]
[TD]Telegraph[/TD]
[TD]Networking administrator[/TD]
[TD]123 ABC Street[/TD]
[TD] [/TD]
[TD]Charlotte[/TD]
[TD]NC[/TD]
[TD]25368[/TD]
[TD]sc@telegraph.com[/TD]
[TD] [/TD]
[TD]333-999-889[/TD]
[/TR]
[TR]
[TD]South west[/TD]
[TD]William Seward[/TD]
[TD]10/20/1987[/TD]
[TD]innovations technologies[/TD]
[TD]Web specialist[/TD]
[TD]345 Stree C[/TD]
[TD] [/TD]
[TD]Tampa[/TD]
[TD]FL[/TD]
[TD]78989[/TD]
[TD]li@InnoTech.com[/TD]
[TD] [/TD]
[TD]333-999-890[/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]
[TD] [/TD]
[TD]333-999-891[/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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[TD] [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
Cross posted https://www.excelforum.com/for-othe...bs-in-excel-to-create-a-list.html#post4952716

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Locked
  • Question Question
Collect Tab information to create a main list
Replies
1
Views
821
Fluff
Fluff

Forum statistics

Threads
1,224,822
Messages
6,181,164
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