Posts by logisticswoman
-
-
Hi,
How do I create page breaks for each entry on a report?
Thanks in advance for your help.
-
I would like to change a color of an unlocked cell when the worksheet is protected. I would like to keep the sheet protected so that I would miss up any formulas when I an inserting new data.
Thanks for all your help!!!!!!!!!!!
-
Yes that is what I meant...
I tried that, but it doesn't work like that. Once the worksheet is protected, I am unable to change the formating of a unlocked cell. Is there a way to changed the formating of the unlocked cells while the sheet is still protected?
-
I am using 2000 version of Excel.
-
Hi everyone:):):)
Quick Question:
How do I protection the formulas within a worksheet? I want to be able to protect the formulas within a worksheet, but still be able to change background color of the cells that are unprotect.
Thanks in advance for your help.
-
Thanks for your help:):):)
-
Ok,
I follow the directions, but I am still coming up with an error message when I open up the main file. The error message states, "FILE NOT FOUND." How do prevent that message from coming up?
Thanks for your help
-
How do I change the links to a page from Automatic to Manual?
The problem that I am having is that I only want to open up the linkpage without opening the page where all the links belong too? Please help!!!
I was thinking if I could change from Automatic to Manual that may help my problem, but I don't know how.
Thanks in advance for your help!!!!
-
-
Hello
How do I create a formula that answer the below question?
IF I only wanted to sum up answers on a certain group of people. How will I setup the formula?
Thanks in advance for helping.
-
-
What type of formulas would I used to calculate the numbers that I put into the grid. The sheet are located on different sheets. Bascially, I need the greatest amount of overall sales from each Person, Jack and Jill, listed by the year. Thanks for your assistance in advance. Also, I know that it would be easier to run a marco, but I don't know how. I am looking more for Excel formulas. Thanks again!!!!!!!!!!
Please look at sheet!!!!!!!!
-
<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE align=center cellPadding=0 cellSpacing=0><TBODY><TR><TD bgColor=#0c266b colSpan=5 style="BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid"><TABLE align=center border=0 width="100%"><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - Thank YOU.xls</FONT></TD><TD align=right style="COLOR: #ffffff; FONT-FAMILY: caption; FONT-SIZE: 9pt">___Running: xl2000 : OS = Windows NT 4 </FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD bgColor=#d4d0c8 colSpan=5 style="BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; HEIGHT: 25px"><TABLE align=center border=0 width="100%" VALIGN="MIDDLE"><TBODY><TR><TD style="COLOR: #000000; FONT-FAMILY: caption; FONT-SIZE: 10pt">(<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 <A href="#javascript:void(0)" onclick=show_popup();>(<U>A</U>)bout</A></TD><TD align=right vAlign=center><FORM name=formCb755237><INPUT name=btCb873980 onclick='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);' type=button value="Copy Formula"></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD bgColor=white colSpan=5 style="BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid"><TABLE border=0><TBODY><TR><FORM name=formFb078704><TD align=middle bgColor=white style="WIDTH: 60px"><SELECT name=sltNb935705 onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value"><OPTION selected value="">B3</OPTION></SELECT></TD><TD align=right bgColor=#d4d0c8 width="3%"><B>=</B></TD><TD align=left bgColor=white><INPUT name=txbFb426622 size=80 value="Thanks alot for your help!!!!! Richie"></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid" width="2%"><BR></TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>A</CENTER></TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>B</CENTER></TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>C</CENTER></TD><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: black; FONT-FAMILY: menu; FONT-SIZE: 10pt"><CENTER>D</CENTER></TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; FONT-SIZE: 10pt" width="2%"><CENTER>1</CENTER></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: left; VERTICAL-ALIGN: bottom">THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!</TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; FONT-SIZE: 10pt" width="2%"><CENTER>2</CENTER></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; FONT-SIZE: 10pt" width="2%"><CENTER>3</CENTER></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD></TR><TR><TD align=middle style="BACKGROUND-COLOR: #d4d0c8; BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; FONT-SIZE: 10pt" width="2%"><CENTER>4</CENTER></TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD><TD style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: Arial; FONT-SIZE: 10pt; TEXT-ALIGN: right; VERTICAL-ALIGN: bottom"> </TD></TR><TR><TD colSpan=5 style="BACKGROUND-COLOR: #d4d0c8; BORDER-BOTTOM: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #808080 0.5pt solid"><TABLE align=left width="100%" VALIGN="TOP"><TBODY><TR><TD align=left style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #808080 0.5pt solid; WIDTH: 120pt"><U>Sheet1</U></TD><TD> </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><BR><FONT color=#339966 size=1>[HtmlMaker 2.42] </FONT><FONT color=#339966 size=1>To see the formula in the cells just click on the cells hyperlink or click the Name box</FONT><BR><FONT color=red size=1>PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</FONT></CENTER>
-
If I was to ask a question on this site, how do I post a sample worksheet in Excel format on the site.
-
WORK SHEET ONE
OVERALL Mar Apr May
Jack Product 101
2003 15000 4000 9000 2000
2002 12000 3000 8000 1000
2001 14000 6000 7000 1000
JILL - Product 201
2003 19000 4000 7000 8000
2002 16000 3000 6000 7000
2001 13000 2000 5000 6000
Jack - Product 301
2003 21000 9000 6000 6000
2002 18000 8000 5000 5000
2001 15000 7000 4000 4000
JILL - Product 401
2003 12000 5000 5000 2000
2002 9000 4000 4000 1000
2001 10000 6000 3000 1000Work Sheet Two
OVERALL Mar Apr May
Jack 2003 21000 9000 6000 6000
2002 18000 8000 5000 5000
2001 14000 6000 7000 1000
Jill 2003 19000 4000 7000 8000
2002 16000 3000 6000 7000
2001 10000 6000 3000 1000QUESTION:
What type of formulas would I used to calculate the numbers that I put into the grid. The sheet are located on different sheets. Bascially, I need the greatest amount of overall sales from each Person, Jack and Jill, listed by the year. Thanks for your assistance in advance. -
Thanks for your assistance...
RE Question here is the answer...
=MAXA(SUMIF($A$10,"=5",V10:AJ10),SUMIF($A$15,"=5",V15:AJ15),SUMIF($A$20,"=5",V20:AJ20),SUMIF($A$25,"=5",V25:AJ25),SUMIF($A$30,"=5",!V30:AJ30))
-
Questions???????
How do I format a cell formula to give me something like this:
I need a sum total for Count cells that are in cell A1, A2, and A3, which would allow Column A to be the title column. The answer should look something like this 9,11, and 18. The cells in column A are always changing. I want excel to understand that whenever Column changes the info is sum up on another table...
A B C D
1 7 2 2 5
2 7s 5 4 2
3 8 6 5 7Please help!!!!!!!
-
Thanks,
It worked:):):):)
-
OK...
The answer is still coming as average; the computer is not taking out the unwanted info.Please advise.
