microsoft.public.excel.newusers | Forum profile

  Instead of a Range like A1:A1500 with only the first 100 cells filled............ Use a dynamic range for your source list then only those cells with data will show in the dropdown. i.e. A1:A100 but will expand as more cells are filled. Instructions here at Debra Dalgleish's site. http://www.contextures.on.ca/xlNames01.html#Dynamic Gord On Wed, 7 Jan 2009 10:42:16 -0800, Bruce B <BruceB@discussions.microsoft.com>...

  ctl+m Medford 250 ctl+p PortLand 150 ctl+a Ashland 275 So I can go to any cell and use the Macro to fill with data  

  Something like this Assuming A2 contains the kg value =IF(A2="","",<formula involving A2>) -- Max Singapore http://savefile.com/projects/236895 Downloads:22,000 Files:370 Subscribers:66 xdemechanik --- "Dave Horne" <davehorne@home.nl> wrote in message news:uxHelbLcJHA.1184@TK2MSFTNGP05.phx.gbl... > Someone here was kind enough to provide a...

  The following are terrific step-by-step instructions for importing excel files into outlook. http://www.outlookpower.com/issues/issue200703/00001954001.html I was able to import 8 of the 10 columns, unfortunately the names of the contacts were left off. Tried again and now I get am Odbc (or is it obdc) error saying Outlook can't import because it can't map. Something about too much information. Aren't these both...

  I presume you mean by the fifth column the one that starts off with 188, 135. If so, you appear to be missing the value for this column in the third row. Did you accidentally leave out the value? Is it really supposed to be an empty cell? Should it have been a 0? If it was deliberately left out, should it be treated as a 0 or should it be ignored completely? -- Rick (MVP - Excel) "Bad_Shot"...

  Any ideas? Mike  

  See http://www.mcgimpsey.com/excel/removepwords.html for internal passwords, or http://www.mcgimpsey.com/excel/fileandvbapwords.html for file passwords. In article <E4828E5D-1FD8-48A4-83A4-AF639834F9A4@microsoft.com>, tatty07 <tatty07@discussions.microsoft.com> wrote: > how do i retrieve password in excel as i cannot unlock workbook as i have > forgotton password  

  In columns A and B I have some names. The ones that interest us are A1: John Doe and B4: John K. Doe A2: Robert E Lee and B3: Robert Lee In C1 I have a long formula: =LEFT(A1,FIND(" ",A1,1)-1)&IF(ISNUMBER(FIND(" ",A1,FIND(" ",A1)+1)),MID(A1,FIND(" ",A1,FIND(" ",A1)+1),255),MID(A1,FIND(" ",A1,1),255)) And a formula in...

  Hi, Launch a second copy of Excel and move that to the second monitor. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "ValD2009" <ValD2009@discussions.microsoft.com> wrote in message news:B391405B-F5F4-4D7E-88FE-3665F0B76912@microsoft.com... > When I open two excel worksheets they open up in a excel window. I can't > seperate them to view them on seperate...

  In cell K5, enter: =E5-SUM(G5:K5) and copy down -- Gary''s Student - gsnu200825 "onemulligan" wrote: > I am new to Excel and am trying to make a formula for items I am selling. > After 2 hours of trying I am asking for help. I need starting entries in E5 > which has a price to then subtract G5,H5,I5,J5,K5 and have total in K5. I > would like this formula to work for 100 rows....