http://help.wugnet.com/office/forum-c2.html Top 15 Messages on help.wugnet.com http://help.wugnet.com/office/Excel-2007-setting-mouse-scroll-formulas-ftopict1180518.html#3731175 By: kirsty - thanks for the reply: I have never, in any incarnation of office, had "allow editing directly in cells" ticked, as I like the double click to take me to the subject cells. However, irritatingly, this seems to correct the problem with scrolling to an "out of view" cell reference for a formula. (The "Zoom on roll with IntelliMouse" was already unchecked.) Is there any oth... http://help.wugnet.com/office/Conditional-Multiple-Time-Ranges-ftopict1180474.html#3731174 By: KT - Perfect solution. Thanks. "Ashish Mathur" wrote: > Hi, > > Type the text in a cell (say A5) and colour the font to white (the text > should not be visible). Then apply the following conditional formatting rule > to the cell - Formula is > > =and(mod(now(),1)=time(8,0,0)). Apply the font > to colour black > > Now when you refresh th... http://help.wugnet.com/office/Password-Protect-columns-passwords-ftopict1112966.html#3731173 By: Gord Dibben - Not considered intermeddling and any help in these groups is appreciated. Sometimes I may be away for a day or two and OP needs an answer sooner rather than later. Gord On Sat, 21 Nov 2009 13:10:47 +0800, "MRT" wrote: >Sorry for intermeddling, Gord. :-) > >"Gord Dibben" wrote in message news:7rmdg553sce3nncec627isp2jf85... http://help.wugnet.com/office/Forms-ftopict1180522.html#3731170 By: MarkOffice2007 - I have a worksheet and would like to create a form and link the worksheet to it. Then, if I enter information into the worksheet it would also appear in the form and vise versa. Does anyone know how to do this and also create a data form please? http://help.wugnet.com/office/Validation-Employee-Timesheet-ftopict1180516.html#3731166 By: JLatham - On the offchance that you do end up going with the VBA solution, I've modified the code based on your 2nd posting. This will first check to make sure that only one cell changed (so you can use a bunch, nothing happens ' #2 - change took place in rows 3:369 If Target.Cells.Count > 1 Then Exit Sub ' multiple cells selected End If If Target.Row < 3 Or Target.Ro... http://help.wugnet.com/office/avoid-appearing-VLOOKUP-ftopict1134624.html#3731158 By: Carolina - In two formulas like mine where would I put the iserror statement??? I've tried it and I get errror messages =IF(D5=Sheet2!$A$1874,Sheet2!$B$1874) Thanks! Carolina "-a" wrote: > I use an If (error( statement like: > The error captures the #N/A Result. It should... http://help.wugnet.com/office/Strange-Excel-problem-Jump-List-ftopict1180520.html#3731153 By: Jack Wiggins - I am running Windows 7 and Office 2007. When I open an Excel file from the Jump List, none of the commands on the ribbon are clickable. It is just as though the program is frozen. I can make changes to the worksheet but I cannot save them. I can close the program by clicking the "x" in the upper right-hand corner but changes are not saved. If I open Excel first, t... http://help.wugnet.com/office/Converting-standard-time-military-time-ftopict1180508.html#3731146 By: CellShocked - On Fri, 20 Nov 2009 10:49:40 -0800 (PST), "C." wrote: >On Nov 20, 1:18pm, "Joe User" wrote: >> "C." wrote: >> > I do have two different types of dates: >> > Sep 1 2009 4:45PM >> > and >> > Sep 18 2009 11:15AM >> > [....] >> > I tried your second suggestion in a parallel >> > column "=--SUBSTITUTE(A1, " ", ", ", 2)" but >> ... http://help.wugnet.com/office/excel-spreadsheet-2003-wont-show-content-moved-par-ftopict1180514.html#3731136 By: Paul C - I had a similar issue with some files. What happened was that somehow the windows for the files got minimized or dragged out of view somehow (not sure how this happened). Users would open a file and see nothing. This fixed it for me. Goto the Window item on toolbar, Select Arrange and then select tiled. If your file window somehow got moved to a non visible posit... http://help.wugnet.com/office/Statement-ftopict1180511.html#3731121 By: Luke M - The way you wrote that, you are overwriting the date/date that was already in the A column with new information? Is that really what you want? I will assume that you actually want the new information in B column. In B18: =IF(A18=D$3,"Effective Date","Not Effective") Guessing again, you might want: =IF(A18<=D$3,"Effective Date","Not Effective") if you actually are che... http://help.wugnet.com/office/Automatic-update-data-excel-charts-ftopict1180444.html#3731099 By: shantz - I am still working for a living :) "Gord Dibben" wrote: > Good to hear. > > Thanks for the feedback and thanks to Stephen. > > He saved my butt with this many years ago when I was still working for a > living. > > > Gord > > On Tue, 17 Nov 2009 18:28:02 -0800, shantz > wrote: > > >Thanks Gord - the link clearly explains ho... http://help.wugnet.com/office/insert-picture-statement-ftopict1109377.html#3731096 By: mahir ibrahim - Hi, I have 3 pictures but only want to display one dependant on what infomation is in cell a1 is this possible using a IF statement?? nivek0 wrote: can i insert a picture with a if statement 02-Jun-08 I have 2 pictures but only want to display one dependant on what infomation is in cell a1 is this possible using a IF statement?? Previous Posts In This Th... http://help.wugnet.com/office/Blank-Cells-Data-ftopict1180501.html#3731089 By: T. Valko - If the "empty" cells contain unseen space characters, this macro will remove them: http://www.mvps.org/dmcritchie/excel/join.htm#trimall The macro also removes other whitespace characters so you might want to try that first on a copy of your file. -- Biff Microsoft Excel MVP "John Calder" wrote in message news:46D14F8E... http://help.wugnet.com/office/Comparison-popular-Blu-ray-rippers-ftopict1180499.html#3731080 By: flssm2008 - Blu-ray as a new disc format has greater storage capacity, faster reading and writing speed, and more safe data storage function. It becomes more and more popular in nowadays. However, there are so many Blu-ray products, then how to choose the right Blu-ray Ripper? In order to solve this problem, I chose three best-selling Blu-ray Rippers to make a comparative analysis on its pr... http://help.wugnet.com/office/Save-DBF-ftopict1103429.html#3731073 By: Gyula - Dear Fellow DBF Users, The latest upgrade of the SaveDBF Excel 2007 add-in (used to be called XLSX2DBF) can be tried at thexlwiz.blogspot.com. The changes include fixes related to minor bugs in Microsoft's OLEDB engine and some improved field type identification for users who start out with an Excel file. Future plans: I plan one more upgrade in Jan/Feb 2010. This ... http://help.wugnet.com/office/Analyzing-Bank-Statements-Pivot-Tables-ftopict1180487.html#3731061 By: Fred Smith - Change the function from Count to Sum. Right-Click on the column of numbers, and it will give you an option to change. The specific instructions will depend on what version of Excel you are using. Regards, Fred. "Sleuth" wrote in message news:D9698421-2217-4426-A54E-85D3D7F8F0AF@microsoft.com... >I would like to perform analysis ...