Posts by logisticswoman

    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?

    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.

    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!!!!

    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"&gt;</SCRIPT&gt;<CENTER&gt;<TABLE align=center cellPadding=0 cellSpacing=0&gt;<TBODY&gt;<TR&gt;<TD bgColor=#0c266b colSpan=5 style="BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid"&gt;<TABLE align=center border=0 width="100%"&gt;<TBODY&gt;<TR&gt;<TD align=left&gt;<FONT color=white&gt;Microsoft Excel - Thank YOU.xls</FONT&gt;</TD&gt;<TD align=right style="COLOR: #ffffff; FONT-FAMILY: caption; FONT-SIZE: 9pt"&gt;___Running: xl2000 : OS = Windows NT 4 </FONT&gt;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD bgColor=#d4d0c8 colSpan=5 style="BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid; HEIGHT: 25px"&gt;<TABLE align=center border=0 width="100%" VALIGN="MIDDLE"&gt;<TBODY&gt;<TR&gt;<TD style="COLOR: #000000; FONT-FAMILY: caption; FONT-SIZE: 10pt"&gt;(<U&gt;F</U&gt;)ile (<U&gt;E</U&gt;)dit (<U&gt;V</U&gt;)iew (<U&gt;I</U&gt;)nsert (<U&gt;O</U&gt;)ptions (<U&gt;T</U&gt;)ools (<U&gt;D</U&gt;)ata (<U&gt;W</U&gt;)indow (<U&gt;H</U&gt;)elp <A href="#javascript:void(0)" onclick=show_popup();&gt;(<U&gt;A</U&gt;)bout</A&gt;</TD&gt;<TD align=right vAlign=center&gt;<FORM name=formCb755237&gt;<INPUT name=btCb873980 onclick='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);' type=button value="Copy Formula"&gt;</FORM&gt;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD bgColor=white colSpan=5 style="BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid"&gt;<TABLE border=0&gt;<TBODY&gt;<TR&gt;<FORM name=formFb078704&gt;<TD align=middle bgColor=white style="WIDTH: 60px"&gt;<SELECT name=sltNb935705 onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value"&gt;<OPTION selected value=""&gt;B3</OPTION&gt;</SELECT&gt;</TD&gt;<TD align=right bgColor=#d4d0c8 width="3%"&gt;<B>=</B&gt;</TD&gt;<TD align=left bgColor=white&gt;<INPUT name=txbFb426622 size=80 value="Thanks alot for your help!!!!! Richie"&gt;</TD&gt;</FORM&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<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%"&gt;<BR&gt;</TD&gt;<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"&gt;<CENTER&gt;A</CENTER&gt;</TD&gt;<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"&gt;<CENTER&gt;B</CENTER&gt;</TD&gt;<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"&gt;<CENTER&gt;C</CENTER&gt;</TD&gt;<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"&gt;<CENTER&gt;D</CENTER&gt;</TD&gt;</TR&gt;<TR&gt;<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%"&gt;<CENTER&gt;1</CENTER&gt;</TD&gt;<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"&gt;THANK&nbsp;YOU!!!!!!!!!!!!!!!!!!!!!!!!!</TD&gt;<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"&gt;&nbsp;</TD&gt;<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"&gt;&nbsp;</TD&gt;<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"&gt;&nbsp;</TD&gt;</TR&gt;<TR&gt;<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%"&gt;<CENTER&gt;2</CENTER&gt;</TD&gt;<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"&gt;&nbsp;</TD&gt;<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"&gt;&nbsp;</TD&gt;<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"&gt;&nbsp;</TD&gt;<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"&gt;&nbsp;</TD&gt;</TR&gt;<TR&gt;<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%"&gt;<CENTER&gt;3</CENTER&gt;</TD&gt;<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"&gt;&nbsp;</TD&gt;<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"&gt;&nbsp;</TD&gt;<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"&gt;&nbsp;</TD&gt;<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"&gt;&nbsp;</TD&gt;</TR&gt;<TR&gt;<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%"&gt;<CENTER&gt;4</CENTER&gt;</TD&gt;<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"&gt;&nbsp;</TD&gt;<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"&gt;&nbsp;</TD&gt;<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"&gt;&nbsp;</TD&gt;<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"&gt;&nbsp;</TD&gt;</TR&gt;<TR&gt;<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"&gt;<TABLE align=left width="100%" VALIGN="TOP"&gt;<TBODY&gt;<TR&gt;<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"&gt;<U&gt;Sheet1</U&gt;</TD&gt;<TD&gt;&nbsp;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;<BR&gt;<FONT color=#339966 size=1&gt;[HtmlMaker 2.42] </FONT&gt;<FONT color=#339966 size=1&gt;To see the formula in the cells just click on the cells hyperlink or click the Name box</FONT&gt;<BR&gt;<FONT color=red size=1&gt;PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</FONT&gt;</CENTER&gt;

    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 1000


    Work 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 1000


    QUESTION:
    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.

    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 7


    Please help!!!!!!!