Help with list

jcaptchaos2

Well-known Member
Joined
Sep 24, 2002
Messages
1,026
I want to be able to have information entered on the main sheet and then automatically transfer to the sheets 1,2,3 etc. I know that I could have each sheet look at the main sheet and then filter it or I could probably us pivot tables. I always seem to learn a better way on this website so I thought I would ask.
<table border = "1" cellspacing = "0" bordercolor="#999999">
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Main Sheet </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Code </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Name </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Color </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Number </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Jim </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Red </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Bob </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Blue </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">5 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Al </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Orange </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">John </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Green </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">56 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Ken </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Yellow </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Jan </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Purple </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Chris </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Red </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">155 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Lisa </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Blue </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">65 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Ben </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Orange </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">84 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Jim </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Green </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">632 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Bob </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Yellow </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">598 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Al </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Purple </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">45 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">John </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Red </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">48 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Ken </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Blue </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">96 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Bruce </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Orange </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">63 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Matt </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Green </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">67 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Terri </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Yellow </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">84 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Lyn </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Purple </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">85 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Mike </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Blue </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Bobby </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Orange </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">512 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Sheet 1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Code </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Name </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Color </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Number </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Jim </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Red </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Bob </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Blue </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">5 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Al </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Orange </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">John </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Green </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">56 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Ken </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Yellow </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Sheet 2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Code </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Name </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Color </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Number </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Jan </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Purple </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Chris </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Red </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">155 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Lisa </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Blue </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">65 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Ben </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Orange </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">84 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Jim </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Green </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">632 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Sheet 3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Code </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Name </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Color </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Number </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Bob </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Yellow </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">598 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Al </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Purple </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">45 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">John </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Red </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">48 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Ken </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Blue </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">96 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Bruce </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Orange </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">63 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Sheet 4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Code </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Name </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Color </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Number </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Matt </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Green </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">67 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Terri </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Yellow </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">84 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Lyn </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Purple </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">85 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Mike </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Blue </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Bobby </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Orange </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">512 </font></td></tr>
</table>
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,304
Office Version
  1. 365
Platform
  1. Windows
How automatic do you want this?
 

jcaptchaos2

Well-known Member
Joined
Sep 24, 2002
Messages
1,026
I would like to enter the information in the list on the main sheet and then when you go to the sheet it should be on it's there.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,304
Office Version
  1. 365
Platform
  1. Windows
It should be possibly using a worksheet change event, but you would need to work out what change would trigger the code.

For example would it be when a value was entered in the 4th column?

Or would you want to monitor all the columns, then whenever a change was made check if the record is complete and then transfer the data to the appropriate sheet.
 

jcaptchaos2

Well-known Member
Joined
Sep 24, 2002
Messages
1,026
Probably want to monitor all the columns, but I would willing to try anything
 

Forum statistics

Threads
1,141,718
Messages
5,708,074
Members
421,545
Latest member
TWR

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
Top