showing parts of data on a work sheets

R

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

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sort by date Sort by votes
Hi

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

Richard
 
Upvote 0
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?
 
Upvote 0
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).
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
<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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Inventory and cost management
Replies
4
Views
296
felixstraube
F
S
  • Question
Macro to add sum total to track percentages
Replies
0
Views
100
spenserallen7
S
P
  • Question
Summing Data based on a count of prior month data
2
Replies
12
Views
613
KRice
K
P
  • Question
Automating copying of columns within same sheet in excel using VBA.
Replies
1
Views
103
MountainFog
M
S
  • Question
Neep help setting up table for plot graph
Replies
0
Views
73
supermom28115
S

Forum statistics

Threads
1,214,641
Messages
6,120,694
Members
448,979
Latest member
DET4492

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