showing parts of data on a work sheets

Rpritts

New Member
Joined
Sep 21, 2006
Messages
21
I have a list of business units (business unit, person assinged and sales) that I am breaking out to diffent work sheets. I want each sheet to show the people assigned to the business unit and sales total for each unit. How can I do this other than paste and copy?

Thanks,
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi

You can do this via a custom macro utilising Autofilter. How many different business units are we talking?

Richard
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,300
Office Version
  1. 365
Platform
  1. Windows
You could use code to do this either using Richard's Autofilter suggestion, or using AdvancedFilter.

Do give you specific code we would need to know more about your setup.

Can you post some example data?
 

Rpritts

New Member
Joined
Sep 21, 2006
Messages
21

ADVERTISEMENT

I have no code and have had no luck using advance filter
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,300
Office Version
  1. 365
Platform
  1. Windows
Rpritts

I know you have no code.:)

But we have no further information as to what you exactly want to do either.

I could post some generic code that will filter data into seperate worksheets based on some criteria involving values in a particular column(s).
 

Rpritts

New Member
Joined
Sep 21, 2006
Messages
21

ADVERTISEMENT

We are looking at how set up for the next 3-4 years

I am displaying income and expenses for the next 4 years side by side and I need to list the staff below
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Could you possibly use the html maker (see link in my signature) to post some of your sample data - that will help out anybody (such as myself and Norie) who wants to make a suggestion as to how you could go about filtering the data to separate sheets.


Richard
 

Rpritts

New Member
Joined
Sep 21, 2006
Messages
21
<HTML><HEAD><Script Langage JavaScript><!---
function ViewSource() {
var HtmlSource;
HtmlSource = document.all.ForSubmit.innerHTML;
HtmlSource = RetDeleted(HtmlSource);
document.write('<HTML><BODY BGCOLOR=#E0F4EA><CENTER><FORM><TEXTAREA ROWS=30 COLS=90%>');
document.write(HtmlSource);
document.write('</TEXTAREA></FORM></CENTER></BODY></HTML>');
}
function CopyToClipBoard() {
var HtmlSource;
HtmlSource = document.all.ForSubmit.innerHTML;
HtmlSource=RetDeleted(HtmlSource);
window.clipboardData.setData("Text",HtmlSource);
alert('Html source of above image\n\nhas been copied to your clip board\n\nJust paste it into Message Body\n\nIf you cannnot paste source from clip board,\n\nclick [View Source] button and paste manually.');
}
function RetDeleted(targetstring) {
if (targetstring.indexOf(unescape('%0D%0A')) > -1) rcode = unescape('%0D%0A')
else if (targetstring.indexOf(unescape('%0A')) > -1) rcode = unescape('%0A')
else rcode = unescape('%0D');
i = 0;
p = '';
while (targetstring.indexOf(rcode,i) != -1) {
m = targetstring.indexOf(rcode,i);
p += targetstring.substring(i,m);
i = m + rcode.length;
}
p += targetstring.substring(i,targetstring.length);
return p;
}</Script></HEAD><BODY BGCOLOR=#E0F4EA><CENTER><FONT COLOR=#339966 SIZE=5>[HtmlMaker 2.42]</FONT></CENTER><HR><SPAN id='ForSubmit'>
HEAD.xls
ABCD
1POSPRGsales
2NYJohn6,000.00
3NYSam10,000.00
4ILBob9,000.00
5ILrob9,000.00
6ILchris28,000.00
7CATom10,000.00
8CAsue3,000.00
9CAkate4,500.00
10CAjudy10,000.00
11CAperry12,000.00
12CApaul1,500.00
13CAkelly12,500.00
14CAdon20,000.00
head2
</SPAN><CENTER><HR><FORM NAME='form1'><INPUT TYPE='Button' value='Please click this button to send the source to clipbord' onClick='CopyToClipBoard();'><INPUT TYPE='Button' value='View Source' onClick='ViewSource();'></FORM><FONT COLOR=#339966 SIZE=2> This free code was written by Colo and Ivan F Moala:[HtmlMaker 2.42] - 15th May 2003</FONT><FONT COLOR=#339966 SIZE=2>Code mods by Ivan F Moala - 15th May 2003</FONT></HR></BODY></HTML>

to<HTML><HEAD><Script Langage JavaScript><!---
function ViewSource() {
var HtmlSource;
HtmlSource = document.all.ForSubmit.innerHTML;
HtmlSource = RetDeleted(HtmlSource);
document.write('<HTML><BODY BGCOLOR=#E0F4EA><CENTER><FORM><TEXTAREA ROWS=30 COLS=90%>');
document.write(HtmlSource);
document.write('</TEXTAREA></FORM></CENTER></BODY></HTML>');
}
function CopyToClipBoard() {
var HtmlSource;
HtmlSource = document.all.ForSubmit.innerHTML;
HtmlSource=RetDeleted(HtmlSource);
window.clipboardData.setData("Text",HtmlSource);
alert('Html source of above image\n\nhas been copied to your clip board\n\nJust paste it into Message Body\n\nIf you cannnot paste source from clip board,\n\nclick [View Source] button and paste manually.');
}
function RetDeleted(targetstring) {
if (targetstring.indexOf(unescape('%0D%0A')) > -1) rcode = unescape('%0D%0A')
else if (targetstring.indexOf(unescape('%0A')) > -1) rcode = unescape('%0A')
else rcode = unescape('%0D');
i = 0;
p = '';
while (targetstring.indexOf(rcode,i) != -1) {
m = targetstring.indexOf(rcode,i);
p += targetstring.substring(i,m);
i = m + rcode.length;
}
p += targetstring.substring(i,targetstring.length);
return p;
}</Script></HEAD><BODY BGCOLOR=#E0F4EA><CENTER><FONT COLOR=#339966 SIZE=5>[HtmlMaker 2.42]</FONT></CENTER><HR><SPAN id='ForSubmit'><SCRIPT LANGUAGE="JavaScript" SRC="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE align=CENTER cellpadding=0 cellspacing=0><TR><TD COLSPAN=6 BGCOLOR=#0C266B style="border-left:.5pt solid #000000;border-right:.5pt solid #000000;border-top:.5pt solid #000000;"><TABLE ALIGN=CENTER BORDER=0 WIDTH=100%><TR><TD ALIGN=LEFT><FONT COLOR=WHITE>Microsoft Excel - PROJECTIONS.3 FY10.xls</FONT></TD><TD ALIGN=RIGHT style="font-size:9pt;color:#000000;font-family:caption;color:#ffffff;">___Running: xl2002 XP : OS = Windows XP</FONT></TD></TR></TABLE></TD></TR><TR><TD BGCOLOR=#D4D0C8 COLSPAN=6 style="border-left:.5pt solid #000000;border-right:.5pt solid #000000;height:25px;"><TABLE BORDER=0 ALIGN=CENTER VALIGN=MIDDLE WIDTH=100%><TR><TD style="font-size:10pt;color:#000000;font-family:caption;">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD ALIGN=RIGHT VALIGN=MIDDLE><FORM NAME='formCb605117'><INPUT TYPE='Button' NAME='btCb942116' value='Copy Formula' onClick='window.clipboardData.setData("Text",document.formFb202339.sltNb447362.value);'></FORM></TD></TR></TABLE></TD></TR><TR><TD BGCOLOR=WHITE COLSPAN=6 style="border-left:.5pt solid #000000;border-right:.5pt solid #000000;"><TABLE BORDER=0><TR><Form name='formFb202339'><TD ALIGN=CENTER BGCOLOR=White style="width: 60px;"><SELECT NAME='sltNb447362' onChange='document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value'><option value='=+D4+1'>E4<option value='=+E4+1'>F4<option value='=+F4+1'>G4<option value='=+D23'>D5<option value='=+E23'>E5<option value='=+F23'>F5<option value='=+G23'>G5<option value='=INDEX('Increased Assessments 50-50'!$B$108:$AN$125,MATCH($A6,'Increased Assessments 50-50'!$A$107:$A$125,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$107:$AN$107)-1,1)'>E6<option value='=INDEX('Increased Assessments 50-50'!$B$158:$AN$175,MATCH($A6,'Increased Assessments 50-50'!$A$157:$A$175,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$157:$AN$157)-1,1)'>F6<option value='=INDEX('Increased Assessments 50-50'!$B$208:$AN$225,MATCH($A6,'Increased Assessments 50-50'!$A$207:$A$225,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$207:$AN$207)-1,1)'>G6<option value='=SUM(D5:D6)'>D7<option value='=SUM(E5:E6)'>E7<option value='=SUM(F5:F6)'>F7<option value='=SUM(G5:G6)'>G7<option value='=+D10'>E10<option value='=+E10'>F10<option value='=+F10'>G10<option value='=INDEX('Increased Assessments 50-50'!$B$68:$AN$85,MATCH($A12,'Increased Assessments 50-50'!$A$67:$A$85,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$67:$AN$67)-1,1)'>D12<option value='=INDEX('Increased Assessments 50-50'!$B$108:$AN$125,MATCH($A12,'Increased Assessments 50-50'!$A$107:$A$125,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$107:$AN$107)-1,1)'>E12<option value='=INDEX('Increased Assessments 50-50'!$B$158:$AN$175,MATCH($A12,'Increased Assessments 50-50'!$A$157:$A$175,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$157:$AN$157)-1,1)'>F12<option value='=INDEX('Increased Assessments 50-50'!$B$208:$AN$225,MATCH($A12,'Increased Assessments 50-50'!$A$207:$A$225,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$207:$AN$207)-1,1)'>G12<option value='=INDEX('Increased Assessments 50-50'!$B$68:$AN$85,MATCH($A13,'Increased Assessments 50-50'!$A$67:$A$85,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$67:$AN$67)-1,1)'>D13<option value='=INDEX('Increased Assessments 50-50'!$B$108:$AN$125,MATCH($A13,'Increased Assessments 50-50'!$A$107:$A$125,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$107:$AN$107)-1,1)'>E13<option value='=INDEX('Increased Assessments 50-50'!$B$158:$AN$175,MATCH($A13,'Increased Assessments 50-50'!$A$157:$A$175,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$157:$AN$157)-1,1)'>F13<option value='=INDEX('Increased Assessments 50-50'!$B$208:$AN$225,MATCH($A13,'Increased Assessments 50-50'!$A$207:$A$225,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$207:$AN$207)-1,1)'>G13<option value='=INDEX('Increased Assessments 50-50'!$B$68:$AN$85,MATCH($A14,'Increased Assessments 50-50'!$A$67:$A$85,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$67:$AN$67)-1,1)'>D14<option value='=INDEX('Increased Assessments 50-50'!$B$108:$AN$125,MATCH($A14,'Increased Assessments 50-50'!$A$107:$A$125,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$107:$AN$107)-1,1)'>E14<option value='=INDEX('Increased Assessments 50-50'!$B$158:$AN$175,MATCH($A14,'Increased Assessments 50-50'!$A$157:$A$175,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$157:$AN$157)-1,1)'>F14<option value='=INDEX('Increased Assessments 50-50'!$B$208:$AN$225,MATCH($A14,'Increased Assessments 50-50'!$A$207:$A$225,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$207:$AN$207)-1,1)'>G14<option value='=INDEX('Increased Assessments 50-50'!$B$68:$AN$85,MATCH($A15,'Increased Assessments 50-50'!$A$67:$A$85,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$67:$AN$67)-1,1)'>D15<option value='=INDEX('Increased Assessments 50-50'!$B$108:$AN$125,MATCH($A15,'Increased Assessments 50-50'!$A$107:$A$125,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$107:$AN$107)-1,1)'>E15<option value='=INDEX('Increased Assessments 50-50'!$B$158:$AN$175,MATCH($A15,'Increased Assessments 50-50'!$A$157:$A$175,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$157:$AN$157)-1,1)'>F15<option value='=INDEX('Increased Assessments 50-50'!$B$208:$AN$225,MATCH($A15,'Increased Assessments 50-50'!$A$207:$A$225,1)-1,MATCH($D$2,'Increased Assessments 50-50'!$A$207:$AN$207)-1,1)'>G15<option value='=SUM(D10:D15)'>D16<option value='=SUM(E10:E15)'>E16<option value='=SUM(F10:F15)'>F16<option value='=SUM(G10:G15)'>G16<option value='=+D7-D16'>D18<option value='=+E7-E16'>E18<option value='=+F7-F16'>F18<option value='=+G7-G16'>G18<option value='=+D21'>E21<option value='=+E21'>F21<option value='=+F21'>G21<option value='=+D22'>E22<option value='=+E22'>F22<option value='=+F22'>G22<option value='=SUM(D21:D22)'>D23<option value='=SUM(E21:E22)'>E23<option value='=SUM(F21:F22)'>F23<option value='=SUM(G21:G22)'>G23</select></TD><TD WIDTH=3% ALIGN=RIGHT BGCOLOR=#D4D0C8 >=</TD><TD ALIGN=LEFT BGCOLOR=White><input type='text' name='txbFb150492' size='80' value='=+D4+1'></TD></form></TR></TABLE></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="border-top:.5pt solid #000000;border-left:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>C</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>D</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>E</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>F</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>G</CENTER></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>4</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Revenue</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2007</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2008</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2009</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">2010</FONT></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>5</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000; text-indent: 1em;">Income</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 16,000.00</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 16,000.00</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 16,000.00</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> 16,000.00</FONT></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>6</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000; text-indent: 1em;">Interest</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 12,000.00</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>7</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:1.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Total</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:1.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 28,000.00</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:1.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 16,000.00</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:1.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 16,000.00</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:1.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> 16,000.00</FONT></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>8</CENTER></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>9</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Expenses</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>10</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000; text-indent: 1em;">Salaries</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 15,000.00</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 15,000.00</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 15,000.00</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> 15,000.00</FONT></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>11</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000; text-indent: 1em;">Benefits</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 12,000.00</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 12,000.00</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 12,000.00</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> 12,000.00</TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>12</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000; text-indent: 1em;">Contractual</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>13</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000; text-indent: 1em;">Supplies</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>14</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000; text-indent: 1em;">Equipment</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>15</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000; text-indent: 1em;">Other</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> -</FONT></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>16</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:1.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Total</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:1.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 27,000.00</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:1.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 27,000.00</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:1.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 27,000.00</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:1.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> 27,000.00</FONT></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>17</CENTER></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>18</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000; text-indent: 1em;">Deficit</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 1,000.00</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> (11,000.00)</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> (11,000.00)</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> (11,000.00)</FONT></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>19</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000; text-indent: 1em;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>20</CENTER></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>21</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">John</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 6,000.00</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 6,000.00</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 6,000.00</FONT></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> 6,000.00</FONT></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>22</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Sam</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> 10,000.00</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"><A HREF='#javascript:void(0);' onClick='document.formFb202339.sltNb447362.
 

Forum statistics

Threads
1,136,613
Messages
5,676,813
Members
419,652
Latest member
jjakub33

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