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