vba procedure, actc, excel 2000: Hi Vern How are you? Please edit your macro and change it accotding to the following VBA procedure Sub namingactivecell() Dim ActC As Range Set ActC = Selection ActiveWorkbook.Names.Add Name:= test , RefersToR1C1:=ActC End Sub Cheers Adelaid...

Excel: Excel 2000, excel 2000, manipulation

excel 2000, manipulation, cells: The code below will create a range named test for the range of cells currently selected at the time it is run. It deletes the range named test before it re-creates it. See if this helps Dim R As Range On Error Resume Next ActiveWorkbook.Names(...

Excel: Excel 2000, range selection, book2

range selection, book2, ogilvy: Vern, To create a named range that refers to the selected cells selection.Name = MyRange will create a named range MyRange Let me illustrate from the immediate window: Select B9 to E18 Range( B9 ).Resize(10,4).Select demonstrate what is...

Excel: Excel 2000, excel vba help, code application

excel vba help, code application, strange behavior: Hello Vern Application.ScreenUpdating = False for each sh in thisworkbook.Worksheets sh.Activate sh.Unprotect Password:= ABC process this sheet sh.Protect Password:= ABC Next Application.ScreenUpdating = True For a lot of things, you...

Excel: Excel 2000, douglas m smith, brainbench

douglas m smith, brainbench, loop through: Hi Vern, Here s a routine that will loop through all the sheets in the active workbook and unprotect them, assuming they all have the same password: Sub Unprotector() For Each x In Sheets x.Unprotect whateveryourpasswordis Next x End Sub ...

Excel: Excel 2000, password protection, excel 2000

password protection, excel 2000, macros: You can use two macros like these: Sub ProtectSheets() Dim mySheet As Worksheet For Each mySheet In ThisWorkbook.Worksheets mySheet.Protect Pass Next End Sub Sub UnprotectSheets() Dim mySheet As Worksheet ...

Excel: Excel 2000, visual basic menu, select tools

visual basic menu, select tools, password protection: Hi Vern, Open your workbook with password protection that you want to add the Macro to and press Alt+F11 to open the Visual Basic Editor. Then from the Visual Basic menu select Insert then Module then in the right-hand blank pane paste the following...

Excel: Excel 2000, password protection, excel 2000

password protection, excel 2000: Sub Protect() Dim Sh As Worksheet For Each Sh In ThisWorkbook.Sheets On Error Resume Next Sh.Protect Password:= Test Next Sh End Sub Sub UnProtect() Dim Sh As Worksheet For Each Sh In ThisWorkbook.Sheets On Error Resume Next Sh.UnProtect...

Excel: Excel 2000, macro code, password protection

macro code, password protection, excel 2000: You don t need code for that, just go into the visual basic editor then the tools menu, project properties and use the protection tab - lock project for viewing and set a password - job done! When you close the workbook and then reload it, you will not be...

Excel: Excel 2000, conditional formatting, vlookup formula

conditional formatting, vlookup formula, blank cell: Adrienne, It can be done by nesting the function in an IF statement. For example: =IF(ISNA( Your Formula ), , Your Formula ) Will display a blank cell or, =IF(ISNA( Your Formula ), - , Your Formula ) will display a dash. Obviously, copy and paste...

Excel: Excel 2000, password protection, excel 2000

password protection, excel 2000, pw: Sub Answer() Dim pw as string, Sh as Worksheet pw= ThePasswordGoesHere For each sh in Sheets sh.activate not really nec. but not sure what else you want to do sh.Unprotect pw DO YOUR MANIPULATION HERE sh.Protect pw ...

Excel: Excel 2000, single board, excel 2000

single board, excel 2000, plywood: Do you mean you calculate the total area required the need to divide that by the area of a single board/ Perhaps =(100*15)/(10*4) Where the first bracket calculates the total required & the second calculate the board area, then divides total by boar...

Excel: Excel 2000, left hand corner, excel expert

left hand corner, excel expert, upper left hand corner: I hate to choose the beyond my expertise... for a question like this, but it IS. However, I like to tell you that it CAN be done using VBA. You can ask another Excel expert who states that they have VBA programming experience, or you can ask at www.vbaexpress.com...

Excel: Excel 2000, ogilvy, excel 2000

ogilvy, excel 2000, vern: Vern, JE McGimpsey has written most of the code for you already. See his page on this topic: http://www.mcgimpsey.com/excel/lookuppics.html You will probably need to make a few modifications to get exactly what you want. -- Regards, Tom Ogilv...

Excel: Excel 2000, camera object, dynamic ranges

camera object, dynamic ranges, current sheet: In this case, you may want to use macros. The following code will remove the latest picture added on the active sheet, and include the one that is passed as parameter, appending its name to a fixed path: Sub BringImage(strImage As String) Const gPath...

Excel: Excel 2000, excel 2000, vern

excel 2000, vern, filenames: Hello Vern I did send an answer to this question yesterday, unfortunately you appear not to have received it. I can help achieve what you want . Can you tell me what format the the graphics would be in and how and where you would want them displayed....

Excel: Excel 2000, vbe, excel 2000

vbe, excel 2000, filenames: Press Alt F11 to get to the VBE, where macros live. Double click the sheet name where you will type the file name in the Project Explorer window. On the right side look for General in the top left wide drop down and then click Worksheet. In the top right...

Excel: Excel 2000, cell a1, picviewer

cell a1, picviewer, cell b1: Hi Vern, You might try a couple of different ways. First is to use Hyperlinks. If you use cell A1 to type in your code to select a graphic. Then if you have a table with codes in column C and corresponding hyperlinks in column D then in cell B1 you...

Excel: Excel 2000, conditional formatting, vlookup formula

conditional formatting, vlookup formula, excel 2000: Conditional formatting should work fine - you need to choose Formula Is , then, using the active cell as a reference, enter =ISERROR(D1) [if D1 is the active cell]. Then click Patterns, and on the font tab, select the color which matches the background (probably...

Excel: Excel 2000, default filename, folder path

default filename, folder path, documents and settings: Hi Vern, I recommend having the macro change the current working directory so that the path doesn t have to be entered or browsed to. You can do this two ways: 1. Use the ChDir() VBA function to change the working folder. If you want to change it to...

Excel: Excel 2000, fileexists, filesystemobject

fileexists, filesystemobject, fso: I am not sure if this will fit with what you would like to do later, but at least this code may give you some ideas. It will prompt the user for a file name, and it will check if it exists on a given directory, fixed in the code: Sub TestFile() Const...

Excel: Excel 2000, change directory command, file open dialog box

change directory command, file open dialog box, excel 2000: Sorry for not being clearer the FileToOpen = Application.GetOpenFilename( Text Files (*.txt), *.txt ) will store in the variable FileToOpen the name of the file the user selected. The filter I ve used here (*.txt) should be changed to jpg or gif,...

Excel: Excel 2000, fname, chdir

fname, chdir, graphics files: Wow, methinks you misinterpreted me -- I wasn t critical at all (but that doesn t help matters if you did think I was being so) -- I was actually trying to help. I am always in good spirits, but you can t tell that, I guess! Sorry if you misread what I typed...

Excel: Excel 2000, excel 2000, macros

excel 2000, macros, free time: Sorry, as politely as possible, I don t write macros for people on this site who need one, want one, and/or seem to think I am expected to do so unless they are very short, quick, and simple. Perhaps someone else on this site would. 99% of all macros are...

Excel: Excel 2000, example routine, spath

example routine, spath, c data: This example routine will prompt for a file name and subsequently save the active workbook using that name (and location): Sub GetSaveAsFileNameExample() Dim vFilename As Variant Dim sPath As String sPath = c:data emp vFilename...

Excel: Excel 2000, conditional formatting, vlookup formula

conditional formatting, vlookup formula, error indicators: Adrienne, there are two ways to take care of this. Let s say that the VLOOKUP formula is in J10. 1) Using conditional formatting Conditional formatting actually is one way to handle this. In the dialog box, you can use the formula =ISERROR(J10) and...

Excel: Excel 2000, download open office, sony vaio

download open office, sony vaio, virtual memory: Peter I have tried a variety of different op systems but it opens on all of them here. I would suggest trying one thing, go to openoffice.org and download open office for vista on the laptop, then try opening it, this will give you a better idea as to...

Excel: Excel 2000, cell b3, cell b1

cell b3, cell b1, word pie: not with a vlookup. You need to array-enter* this formula: =INDEX(C:C,MATCH( CherryPie ,A1:A3&B1:B3,0)) or, if the keyword Cherry is in D1 & Pie is in D2, then =INDEX(C:C,MATCH(D1&D2,A1:A3&B1:B3,0)) *array-enter means to press ctrl+shift before pressing...

Excel: Excel 2000, cell b3, cell b1

cell b3, cell b1, word pie: Hi Adrienne, As far as I know VLOOKUP will not lookup two Items. I believe part of the reason is that VLOOKUP is made to find unique items in a database. What you have explained is more of a filtering of the data. I think my question would be what would...

Excel: Excel 2000 Autofilter and Status Bar message, pet peeves, status bar message

pet peeves, status bar message, autofilter: Oh, Jan, this is one my pet peeves with Excel. It has frustrated many people, so you re in good company. The problem is that you have automatic calculation turned on. Though Excel does indeed flash the number of filtered records in the status bar, it then...

Excel: Excel 2000, Complicated Lookup formula, cell b2, cell c3

cell b2, cell c3, cell c2: Hi Greg, How are you? What about the following for E3 cell of Concad sheet =HLOOKUP(C3,Ac2:Ak202,MATCH(B3,Sheet2!B3:B202,)+1) it looks up C3 in the percentage table and retrieves the value that fits this column and the row that B3 occupies in the...

Excel: Excel 2000 Complicated VB for Combo box, blank cells, blank cell

blank cells, blank cell, column count: To find the first blank cell in the range G31:G43 Dim rng as Range, rng1 as Range, rng2 as Range set rng = Worksheets( Sheet1 ).Range( G31:G43 ) if application.CountA(rng) = rng.count then msgbox No blank cells in range exit sub End if set rng1...

Excel: Excel 2000-Copy and Past Row to Column, array formula, fb 3

array formula, fb 3, eb: Excellant description of the problem! I love it when people put before and after examples into their question. Okay, I know this works in the later versions of Excel, so bear with me while we find out if it works in version 2000. 1) Select cells A1...

Excel: Excel 2000 & Copying, vba code, button work

vba code, button work, wb1: OK, try this 1 - Tools/Addins -- if anything is there, deselect it. 2 - Window/Unhide - if anything is there, unhide it and close it 3 - Alt/F11, then F4 - if anything is there aside from the workbook(s) you opened, close them. Now, try copy from 1 workbook...

Excel: Excel 2000 - change column left to right, array formula, change column

array formula, change column, fb 3: Jaz: Excel does not provide a way to transpose in that manner, but you can do a Sort to reorder the data. First you will need to number all of the rows, or columns, depending on which type of switch you are attempting. Lets use this as an example...

Excel: Excel 2000 - change column left to right, change column, selection area

change column, selection area, mr nathan: I have uploaded a sample spreadsheet to the following location: http://home.swbell.net/nate-sus/excel/sortinfo.xls 1) B1 through D4 contains the data we want to sort. 2) In column A – I added a numerical sequence; an index or key. This provides a basis...

Excel: Excel 2000 - change column left to right, eb, change column

eb, change column, fb 3: here is a simple code loop to reverse any number of columns starting with Column A: Option Explicit Sub ReverseColumns() Dim numCols As Integer Number of Columns to roll Dim i As Integer Set the number of Columns to Roll numCols...

Excel: Excel 2000 - Excel 2003 and Vista, xl2000, excel 2000

xl2000, excel 2000, macros: None that I know of (Vista specific) -- I use that combination all the time. One xl2003 issue which has nothing to do with Vista is that this works in xl2000 and not in xl2003: Range( A1:B5 ).Calculate That is, range(...).Calculate no longer works in xl2003,...

Excel: Excel 2000 & Excel 97, activex controls, xl2000

activex controls, xl2000, demod: Private Sub Combobox1_Click() ActiveCell.Activate your code End Sub for commandbuttons, change the takefocusonclick property to false. for all other activeX controls, use the activecell.activate as the first command in the event. (demod above in the...

Excel: Excel 2000 - filename and path in the footer, dialog boxes, custom button

dialog boxes, custom button, copy button: Jan, there are a couple of ways to do this. The most versatile, I think, is to place some code in VBA and create a toolbar button to insert the Path into the active cell. So let s walk this through: First thing, we want to make this available to all workbooks...

Excel: Excel 2000 If/Then formula, cell b1, cell a1

cell b1, cell a1, cell c1: Hi Dorothy, Yes you can. Let us assume that cell A1 contains the amount of hours worked. cell B1 contains the regular 40 hour rate. cell C1 contains the overtime rate. then in cell D1 place the following formula. =IF(A1 =40,A1*B1,IF(A1 40,40*B1+(A1-40)*C1,...

Excel: Excel 2000 help, ogilvy, excel 2000

ogilvy, excel 2000, csv: Modify one of the code sets on this page to do this: http://www.rondebruin.nl/copy5.htm You could put in your column to calculate the workbook name and page, then filter on this column with the code for each unique location and copy all the records for...

Excel: Excel 2000, index & Match on two cells, array dimensions, spreadsheet programs

array dimensions, spreadsheet programs, hlookup: Greg, You need to use one of the LOOKUP functions if you want to match items. Here s a quote from help: =========================================================== The LOOKUP function has two syntax forms: vector and array. The array form of LOOKUP...

Excel: Excel 2000 Linking Problem, excel 2000, hth

excel 2000, hth, windows explorer: I tried dummying up the situation in excel 2000 but I m not getting the condition you describe. Maybe the version of 2000 wasn t with all the service packs installed? But you say that if you do this in 2003 you don t get the problem. So the solution would...

Excel: Excel 2000 linkage problem, linkage problem, excel 2000

linkage problem, excel 2000, new location: (1) when you open the sheet you should be prompted to update the links - select NO to this (although you MAY have set the document up to not prompt you at which point you are stuck) (2) use the edit menu and choose the edit links option to set them to the...

Excel: Excel 2000 linkage problem, linkage problem, excel 2000

linkage problem, excel 2000, simple search: 1. Try Tools, Options. Under the Edit tab uncheck Ask to update automatic links . Since you did not say what version of EXCEL you are using this will vary from version to version. 2. Just a simple search and replace searching for old path and replacing...

Excel: Excel 2000, linkage problem, linkage problem, change source

linkage problem, change source, excel 2000: Hi Sy, When you open a linked workbook it should give you the option to update links. You can press Don t update button to cancel links for that session of Excel. Once open you can go to the Excel menu and select Edit then Links you can press Change...

Excel: Excel 2000 lists, dave edwards, vlookup

dave edwards, vlookup, dave walker: Send the spreadsheet or a sample to rmadsen@iname.com and I can tailor the answer for you. I assume you have a table somewhere of people s names and phone numbers. Normally I would suggest using vlookup, but this function only works if the key information...

Excel: Excel 2000 Macro, macro in excel, left hand side

macro in excel, left hand side, excel 2000: Hi Connie, How are you? Please do the following: Run Excel Open the file where the macro was stored Tools - Macro - Visual Basic Editor Select Module1 ( the Project explorer is on the left-hand side of the screen) File - Remove - Module1 No ...

Excel: Excel 2000/Merging data from 2 worksheets, musical genres, vlookup

musical genres, vlookup, product numbers: vlookup will do this for you - it s =vlookup(WHAT,WHERE,WHICH,LOGICAL) WHAT is the value you want to look up - so the product number WHERE is the data you are looking up - the product number needs to be in the first column of the range WHICH is...

Excel: Excel 2000/Merging worksheet info, vlookup formula, musical genres

vlookup formula, musical genres, product numbers: If I correctly understand the scenario you describe, this can be done with a vlookup formula from the smaller list to the larger list. See excel help on Vlookup for details. You would probably want a 4th argument of false for an exact match. -- ...

Excel: Excel 2000/merging data from 2 worksheets, musical genres, product numbers

musical genres, product numbers, time copy: Les Sorry it took so long, been a little busy up here, anyway without looking at the layout a bit more I would be hesitant to advise one option over another, however, if you would like to send a copy to richard@littlewingweb.com I will look at it and get...

Excel: Excel 2000 Password Protection, douglas m smith, third party software

douglas m smith, third party software, sheet cells: Hi Robert, You can try copying the sheet cells to an unprotected sheet. This may or may not get you what you want depending on the links, macros and other sheet complexities that may be involved. There is third party software available for Excel password...

Excel: Excel 2000 Prompt save every sheet close, excel sheet, excel 2000

excel sheet, excel 2000, yahoo: I suspect you didn t place the code in the appropriate place. It MUST go in the Thisworkbook events: Right-click the Excel LOGO near the File Menu, select View Code, put it there. If you DID this, then the only way it wouldn t work is if your application.enableevents...

Excel: Excel 2000 problem - custom toolbar and macros, custom toolbar, initial question

custom toolbar, initial question, excel 2000: Typically, the *.XLB filename is somthing like USERNAME.XLB where the username depends on your network or the users PC settings. If you search for *.XLB files on the users PC and delete every one of them (typically there s only one) Excel will default to...

Excel: Excel 2000 - Trendline in chart, linegraph, trendline

linegraph, trendline, quarterly data: Richard As far as I can tell there isn t a way to do this using the existing data for the current chart, you can however create another table to create two data tables and combine them in one chart using a linegraph, you would have to create a trendline...

Excel: Excel 2000 - some thing like Conditional Formatting, conditional formatting, mr nathan

conditional formatting, mr nathan, max 2: Good morning JAZ! As you suspected, this can be done with conditional formatting. I have placed a sample spreadsheet with the conditional formats here: http://home.swbell.net/nate-sus/excel/conditional.xls Basically, you want to add the two conditions...

Excel: Excel 2000 time problem, cell b2, cell a1

cell b2, cell a1, flight log: Eric I was a little surprised to find that it didn t work as expected. When I put a value in cell a1 like .07291, and then format the cell b2 to show time, and run this code ARR1 = Range( A1 ).Text Range( B2 ).Value = ARR1 it displays this time: 1:44:59...

Excel: Excel 2000 used in Windows XP, dell xps, office 2000 premium

dell xps, office 2000 premium, older computer: The older versions of Adobe created files by PRINTING to them (I m remembering back to get this) so this MIGHT be the issue - HOWEVER, key to this problem is the fact that it ISN T an Excel issue - it s an adobe one - although I do notice from the query that...

Excel: Excel 2000 VBA, box gutter, victorian conservatory

box gutter, victorian conservatory, a74: I isolated the code you said wasn t working Sub AA() If Lflag = 0 Then If Worksheets( quote ).Range( G13 ).Value = a3 Then Lsupport = MsgBox( Is a Lean Too Support system Required , vbYesNo, Lean Too Support Question ) End If End If...

Excel: Excel 2000 vba code lookup problem, matrix report, vba code

matrix report, vba code, input boxes: It s not clear from the code example where the choices are being stored and I ve never looked in detail at these but I m GUESSING that the values don t update on the change event of the control, but probably the exit event - however, you can always set the...

Excel: Excel 2000 & WordArt, hp laserjet printers, hp printers

hp laserjet printers, hp printers, hp website: If the version of Office remains the same, then the issue is with the Operating System - my GUESS would be the printer driver in use - it would be worth checking on the HP website for updated drivers (OR possibly going back to an OLDER driver - we had a similar...

Excel: Excel 2000 Workbook Links, change source, source button

change source, source button, excel workbook: Hi Bethanne, In Excel 2002 they have a break links button to get rid of the links. This has been a problem for Excel for a long time, how to get rid of old links. Before the Excel 2002 version what I always did was open the Links menu and select the link...

Excel: Excel 2000, external reference, click tools

external reference, click tools, excel 2000: One way is to click Tools, Options and select the Edit tab. Uncheck Ask to update automatic links Or, you can reference the current workbook instead of the original workbook when you edit the link. Once the link is to the current workbook, the prompt...

Excel: Excel 2002, frequency formula, manual additions

frequency formula, manual additions, age bands: Ruth I do very little work with staistical functions which the FREQUENCY formula is, so I m not sure that I m a good on e to answer your question. However--Not knowing exactly what your data looks like --If you simply want to count the number of respondents...

Excel: Excel 2002, table wizard, pivot table

table wizard, pivot table, excel 2002: A pivot cache can hold more the 65536 records, so you could move the data to an access database and combine it there. then link a pivot table to the access database. When you start the pivot table wizard, you can specify that you want Multiple Consolidation...

Excel: Excel 2002, selection type, type option

selection type, type option, excel 2002: Sorry, I was thinking of multicolumn that is not supported. Here is code for getting the selected items. Note that these listboxes start with 1 rather than 0. Assign this to the listbox (or use in other code). Sub listbox1_click() j = 1 With ActiveSheet.ListBoxes(...

Excel: Excel 2002, microsoft excel solver, solver users

microsoft excel solver, solver users, excel 2002: Never tried it, but I would assume you could do it using VBA. If nothing else, you could set screenupdating to off and unhide the sheet, run the macro, hide the sheet and turn screenupdating back on. Here is a source of information on working with Solver...

Excel: Excel 2002, excel 2002, bolding

excel 2002, bolding, ogilvy: This is called rich text formatting, but it only works with text that is hard coded - it doesn t work with formulas. The only alternative would be to use a calculate or change event to run code that builds the string, places it in the cell and bolds the...

Excel: Excel 2002, calendar control, control icon

calendar control, control icon, caption property: Hi Laurie, In Excel 2002 there is no built-in way to do this. I think the Excel developers definitely should have provided this feature. Fortunately, there is a way to add this capability using a simple userform with a Calendar control. Here s how: ...

Excel: Excel 2002, input values, pre filter

input values, pre filter, target: Hi Steven Yes, but if there are more than a few input values the numbers become astronomic. If I wanted to check 16 numbers for all combinations that sum to x, I would have to look at 65536 different combinations (2^16). You will need a Macro or Function...

Excel: Excel 2002, chip pearson, conditional formatting

chip pearson, conditional formatting, waste of my time: You don t talk about any criteria in terms of which rows would be colored or how updated would affect this or what the updates would be. In any event, Chip Pearson has presented some ideas on how you could do this using formulas and conditional formatting...

Excel: Excel 2002, format button, hi bob

format button, hi bob, waste of my time: Select everything (Ctrl/A) Use Format/Conditional Formatting Change Cell Value Is to Formula Is in the formula, enter: =MOD(ROW(),2)=0 then click the format button, then the Patterns Tab. Click on a color for every EVEN row. Click OK, then Click...

Excel: Excel 2002 - 4 day work week, analysis toolpak, man days

analysis toolpak, man days, excel 2002: The nice to have is actually a clue to the best way to do this - you will need to install the Analysis toolpak (tools, addins, check the analysis toolpak option) which will then allow you to use the NetWorkDays function - this calculates the working days between...

Excel: Excel 2002, flag changes, waste of my time

flag changes, waste of my time, excel 2002: Not really I m afraid - you can use tools track changes to flag changes, but it doesn t put the stripes on that you want - you could POSSIBLY use the change event of the workbook to change the background of cells when changed, but this would give you more...

Excel: Excel 2002, problem occured, odd rows

problem occured, odd rows, format button: select all the cells use Format/Conditional Format change Cell value is to Formula Is enter =MOD(ROW(),2)=0, then click FOrmat button, then Patterns tab, and pick a color for even # d rows Click OK Click Add, enter =MOD(ROW(),2)=1 and repeat the process...

Excel: Excel 2002, grave accent, history worksheet

grave accent, history worksheet, menu point: Directly from Help when hide formulas and show formulas was typed in the search box Display or hide formulas Switch between displaying formulas and their values on a worksheet Press CTRL + (grave accent). Prevent a formula from displaying in...

Excel: Excel 2002, john walkenbach, support dates

john walkenbach, support dates, single quote: Excel doesn t support dates before 1900. You can enter such a date (preceed it with a single quote), but must be treated as a string. John Walkenbach wrote an addin that works with earlier dates. It might do what you want. http://j-walk.com/ss/excel/files/xdate.htm...

Excel: Excel 2002, floating point arithmetic, floating point numbers

floating point arithmetic, floating point numbers, math packages: No, it isn t really a bug. Excel complies with IEEE standard for floating point numbers (#754 I believe). You are well aware, I am sure that numbers in a computer are stored in binary. Just like we can t represent all numbers exactly in decimal (take...

Excel: Excel 2002, 3d graph, graph chart

3d graph, graph chart, chart wizard: A 3D graph is one of the choices in the graph/chart wizard. You have to lay out your data x and y values on the left and top of a table in the worksheet and z-values at the intersection. Both the x and Y axes are category axes (like a line chart) rather...

Excel: Excel 2002 - Formula Audit, douglas m smith, brainbench

douglas m smith, brainbench, excel 2002: Hi Judy, If you just want to see the formulas themselves, hold down the Control key and hit the key (it s on the left side of the 1 key). To toggle back to the normal mode, do it again. The instructions you describe will draw arrows between all the...

Excel: I have Excel 2002 installed..., keyboard method, excel 2002

keyboard method, excel 2002, spreadsheet: Sorry, not familiar with a fast save feature thats is suspose to be included . Is that your name for it or EXCEL s name for the feature you are looking for? What does fast save do that the diskette tool on the toolbar not do? Using the diskette tool...

Excel: Excel 2002 SP3 or ??, data labels, text boxes

data labels, text boxes, quality indicators: I don t know of another program you should use, but drawings (including text boxes) are notoriously bad for staying where you put them. You can actually use a data point label to contain the entire text of what you want to show in the text box instead. Depends...

Excel: Excel 2002, manual additions, layout window

manual additions, layout window, age bands: Ruth, I would say that you have two options. The first is to use multiple pivot tables to keep track of the data. To do that, you would select the data, and that can just be the age column (the whole column would be best) - make sure it has a title in the...

Excel: Excel 2003, cell1, sh2

cell1, sh2, sheet1: Hello David, Sub CopyData() Dim sh1 As Worksheet, rng1 As Range, cell1 As Range Dim sh2 As Worksheet, cell2 As Range Dim i As Long Set sh1 = Worksheets( Sheet1 ) Set sh2 = Worksheets( Sheet2 ) i = 1 Set rng1 = sh1.Range( A6,C5,E11,G10 ) Set cell2...

Excel: Excel 2003 (11.5612.5703), colums, column number

colums, column number, different numbers: Sounds very much like VLOOKUP to me - this is a very useful function (so useful I ve explained it in full at my own website - www.aidanheritage.co.uk/Excel ) - however, to recap briefly it s =vlookup(what,where,which,logical) WHAT is the value you want...

Excel: Excel 2003, bessy, apostle

bessy, apostle, sorts: austin You cant unless you remove them, Excel sorts on the first character in each cell. You can parse the column into individual columns, then sort them on the main column but that will only work if you have the same amount of characters in all the columns....

Excel: Excel 2003, swbell, spreadsheet

swbell, spreadsheet, lotus: Kathi: I speculate you are running into some issues with how Excel handles time. Please send your spreadsheet to Lotus@swbell.net and I will take a look. Notes on how Excel handles time: 1 = 1 Day 1/24 = 0.041666667 = 1 Hour 1/24/60 = 0.000694444...

Excel: Excel 2003, cell c5, time bank

cell c5, time bank, lunch time: Fernando I just looked up Castro Verde on my world map--isn t the internet amazin we can talk all over the world to each other, and its also amazing to me that so many people speak or at least type english, I know that would be very difficult for me. ...

Excel: Excel 2003, cell b2, data validation

cell b2, data validation, microsoft excel: What other cells? Suppose you have a dropdown in cell B2. When you choose from that, you d like the price to show in C2 and the part number to show in D2? Here s a tutorial on that: http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm...

Excel: Excel 2003, control toolbox, calendar object

control toolbox, calendar object, date selection: Lisa, Yes it is possible. Click Insert Object and select Calendar Control 11.0 (may be slightly different depending on your version of Excel and the options you loaded with it). This will insert the calendar object in a spreadsheet - move or resize...

Excel: Excel 2003, cell b2, array array

cell b2, array array, counta: Dave, I regret that my answer did not satisfy your needs. The manner in which you asked the question left me with the impression that VBA might have been out of the scope of your knowledge base and therefore not worth my time to develop. I mean no offsense...

Excel: Excel 2003, alternative school, quarterly reports

alternative school, quarterly reports, cells: Phylis I tried to answer your question earlier but couldn t get on the allexperts web site. In any event here it is. I believe the following formula will work for you. =+WEEKNUM(B8,2)-WEEKNUM(A8,2)+1 Where B8 is the ending date and A8 is the beginning...

Excel: Excel 2003, numeric portion, hi bob

numeric portion, hi bob, k1: You need to set up 3 criteria ranges - one for each type of item. I ll use item title as being in A7. in K1 (outside your range) enter =$A7 in K2 enter onw of the items, like Item1 fill K1:K2 to M1:M2 - change the values in L2 and M2 to the other item...

Excel: Excel 2003, ppmt, ipmt

ppmt, ipmt, mathematical ability: I m afraid this function is outside my area of mathematical ability - the help file in excel explains this function, but as it uses mathematical formula that means I cannot copy it across here (it also explains why I cannot help as as soon as the symbols go...

Excel: Excel 2003, vlookup function, student names

vlookup function, student names, student numbers: Jeanne In the Second sheet you can use the Vlookup function, which means that the Students need to be sorted in ascending order and those with the same name will make the vlookup non functional. The formula will look like this =VLOOKUP(B8,[vlookuplink.xls]Sheet1!$A$1:$B$10,2)...

Excel: Excel 2003, company materials, control tab

company materials, control tab, link option: Display the FORMS toolbar and add a checkbox. Assign any cell to it by using the cell link property of the checkbox. Right click the checkbox and left click Format control. Under the Control tab, in EXCEL 2003, you will find the cell link option. Assuming...

Excel: Excel 2003, target cells, target value

target cells, target value, novist: Versions of Excel prior to 2007 only allow 3 Conditional Formats, so the only option would be VBA. The usual way is to use the WorkSheet_Change event. Quick Instructions On How to Add Code to a Sheet Object Open the VBE (Alt+F11) and then double click...

Excel: Excel 2003 bell curve, bell curve, excel 2002

bell curve, excel 2002, mistake: Iain: It really does not matter to me if you rate me poorly or not. But, I d suggest that in the future you learn to ask better questions and/or phrase your questions better. If you ask a question that would only require a Yes/No answer then you should...

Excel: Excel 2003 Cell Population, prayer leader, group attendance

prayer leader, group attendance, prayer leaders: It can be done without macros, the following solution only requires an additional column to be used on the Fall PG attendance worksheet. For the case, I have filled up the first 30 rows of the Dorm Information sheet with data, so all the formulas have...

Excel: Excel 2003 - Changing Case, case option, change case

case option, change case, cells: Vicki There isn t a real simple way to do the conversion as there is in word, but you can use the UPPER function and it will do the job for you. For example-- Assume that in cells A1 thru C14 you have your text. In another part of the worksheet create...

Excel: Excel 2003 - Compound Interest, analysis toolpak, compound interest

analysis toolpak, compound interest, excel 2000: A1: Blank A2: 1 B1: 1000 B2: =Round(B1*1.02,2) C1: =B2-B1 drag C1 down to C2 select A2:C2 and drag down to 300 cells. I don t understand this comment ( if possible, Rounding off 1041. 21.00) but perhaps you can adjust the rounding formula...

Excel: Excel 2003 - Compound Interest, cell b2, principle and interest

cell b2, principle and interest, ipmt: Terry There are a couple of ways that you can do what you want. I assume you need a schedule that tells you what the value is at the end of each day, so I d approach it as follows. In column A starting with row 2 place the number 1. then copy down...

Excel: Excel 2003: copy sheet to another workbook, updating links, apples and bananas, macro menu

apples and bananas, macro menu, entire department: One way of doing it is to use the menu Edit- Replace, and replace the name of the workbook ([Bananas.xls]) with the empty string. This way the references will change to the current workbook.If you want to automate it, you can record a macro (menu Tools- Macros-...

Excel: Excel 2003 data series problem, speadsheet, default user

speadsheet, default user, microsoft excel: The only thing I can suggest is that you run Excel troubleshooting while logged in as the user. See: http://www.officearticles.com/excel/troubleshooting_microsoft_excel.htm Perhaps it s the XLB file? Not sure. Do the steps in the order given. See if it...

Excel: Excel 2003 Error, proper parameters, oracle client

proper parameters, oracle client, oracle db: It doesn t look like the error is on Excel or XP, but on the ODBC configuration to Oracle on the computer. It looks like it is properly configured in the XP computer, but needs to be set up on the other computer. Without entering in much detail, you will...

Excel: Excel 2003 or earlier VBA, libararies, object browser

libararies, object browser, extensibility: Gregory, You can do it in xl97 or later. Here is an article that tells how: http://support.microsoft.com/default.aspx?scid=kb;en-us;160647&Product=xlw97 XL97: How to Programmatically Create a Reference The reference has a remove method as well....

Excel: Excel 2003 email links, e mail address, mail link

e mail address, mail link, draft message: Two solutions. 1. HOLD your mouse pointer down after clicking to keep it from following the hyperlink. 2. Use a macro to remove the hyperlinks in the entire worksheet. Run it as often as you like, or as often as necessary. See: http://vbaexpress.com/kb/getarticle.php?kb_id=73...

Excel: Excel 2003 formulas, excel 2003 formulas, anwer

excel 2003 formulas, anwer, merry christmas: The only reason it would raise an error that I can think of would be if the item you wanted to exclude was not a value. The AVERAGE formula you proposed is fine. It s great that you were able to come up with something that works on your own. Merry Christmas,...

Excel: Excel 2003 - Highlight cells in a column that are not values x,y,z, cell a2, cell values

cell a2, cell values, months of the year: Hi Sam, You should be able to use conditional formatting using OR in your formula should let you do an example with the 12 months. In that example, highlight the column (except for the title) so that you pick up existing as well as potential new entries....

Excel: Excel 2003, level of expertise - 5, vlookup formula, nonzero values

vlookup formula, nonzero values, countif: Hi Joann, If I understand your question, your VLOOKUP is returning zeros for the portion of the month that other areas of sheet haven t been filled in for yet. So you want the graph to just plot the portion of the month for which the VLOOKUP is returning...

Excel: Excel 2003 - lookup, currency rate of exchange, cell b6

currency rate of exchange, cell b6, currency conversion: CDP I m not real clear on how your data is set up, etc. but try this. Use the VLOOKUP function to look up the exchange rate of the value in B7 to US dollars. I assume you have this exchange rate in your table D4 thru F17. Then multiply or divide (depending...

Excel: Excel 2003 Macro, row header, col1

row header, col1, data columns: If the cells will be blank after the to date entry, then Sub ABC() Dim col1 As Long, col2 As Long ActiveSheet.Columns.Hidden = False col = Cells(2, IV ).End(xlToLeft).Column col1 = Cells(2, col).Offset(0, -13).Column If col1 6 Then Cells(2, 7).Resize(1,...

Excel: Excel 2003 mulitple worksheets, brick wall, final score

brick wall, final score, f 90: Hi CDP How are you? Let s assume that you have - the exams types and weights in Sheet1, range A1:B4 - the overall mark and grade in Sheet1, range F3:G8 ( in col F the lower limits of the intervals and grades in col G) - The exams marks of the 1st student...

Excel: Excel 2003 - noncontiguous data in array formulas, array formulas, array function

array formulas, array function, multiple regression: ay Greg well, as you probably already know, linest is an array function. x values has to be in an array, so they have to be in one worksheet, unless i understand arrays wrong. that does not mean that you havre to redo the whole thing though, destroying...

Excel: Excel 2003 - noncontiguous data in array formulas, array formulas, going in the right direction

array formulas, going in the right direction, multiple regression: Good afternoon Greg! Okay, you got me - I have never used LINEST before. As such, I ll play around and see what happens: Test#1 - Two columns of data in same workbook - A1:B2 contains the values: A B 5 6 6 8 =LINEST(A1:A2,B1:B2) Answer = 0.5...

Excel: Excel 2003 Plotting, real time data, blank cells

real time data, blank cells, conditional formatting: You can use conditional formatting to hide the errors, using a formula similar to this in the menu Format- Conditional formatting area: =ISNA(A1) And then set the ink to white, or whatever your cell color is. Regarding dynamic ranges, that can work if...

Excel: Excel 2003 Question, format menu, add button

format menu, add button, a3: Steve You can use the Conditional Formatting option from the Format Menu. Select your cells that you want the formatting to apply to and go to Format Conditional Formatting Select the Drop Down option for Condition 1 and click on Formula is, A3...

Excel: Excel 2003 Question, douglas m smith, cell reference

douglas m smith, cell reference, personal bills: I have a saying, an ounce of structure prevents a ton of programming . If that cell is going to move around, it s going to be far more difficult to find it, including the possibility of a macro being necessary. You might trym naming the balance cells...

Excel: Excel 2003 (SP3 installed) Graph Axis Tic Marks, minor axis, chart updates

minor axis, chart updates, ticks: Hi Charles, I do not have Excel 2003 available (I m still at Excel 2000) so cannot easily check to see if a new chart feature may have been added that would give more flexibility in the way tick marks are drawn, but I suspect that the demand for this capability...

Excel: Excel 2003-Speedy Vlookup Function, vlookup function, daily basis

vlookup function, daily basis, bpo: First of all I have no idea what a BPO is and really don t know how that affects the question and/or my answer. Secondly, there is no way any function can really return its value any faster. The fact that you have so much data is what is causing the...

Excel: Excel 2003, SUMIF, b100, xyz

b100, xyz, cells: I d prefer a more exact example -- are you looking for xyz in any PART of any cell in rows x to y and in any columns? can you supply me with exact ranges and text (making it easier for me to understand what you re trying to do, instead of x & y) so for example...

Excel: Excel 2003 on XP-code fails for ADO connection, microsoft active x, jet oledb

microsoft active x, jet oledb, open table: You need to reference the ADODB library. To do so, in the Visual Basic window of your book, go to Tools- References, locate Microsoft Active X Data Objects 2.8 Library and activate the checkbox beside it. If you don t have that version you can select a...

Excel: Excel 2003 on XP-compile error with ADO connection, activex data objects, jet oledb

activex data objects, jet oledb, microsoft activex: This means that one of your variable declarations declares a varibale type that EXCEL does not recognize. Scroll thru your libraries and look for one that has a question mark next to it or something different like that. I forget what VBA shows when there...

Excel: Excel 2003, hh mm ss, target value

hh mm ss, target value, autofit: Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Count 1 Then Exit Sub If Target.Value = Then Exit Sub If Target.Column = 1 Then Application.EnableEvents = False Target.Offset(0, 1).Value = Now Target.Offset(0, 1).NumberFormat...

Excel: Excel 2004, cell cursor, g4 powerbook

cell cursor, g4 powerbook, windows keyboard: Sounds like you have scroll locking on? On my Windows keyboard, it s a key much like NumLock or CapsLock... Otherwise, check under Tools-- Options (Is that preferences on the Mac?) and make sure that the Transition settings are all for Excel, and not...

Excel: Excel 2004 for Macintosh, array formula, adelaide australia

array formula, adelaide australia, four digits: Hi Graeme, I m a little confused about your specific set up but I can throw out general information about date math that may be of help to you. Excel has a number useful date-related functions. If you have a date in cell A1, you can read it s month...

Excel: Excel 2004 operating slooooooow!, ms windows operating system, excel 1997

ms windows operating system, excel 1997, mac powerbook: Michelle I don t have the 04 version of excel nor do I have a Mac so my experiences may not be the same as yours. In the past with my versions of excel (1997 and 2003) and with a PC, MS windows operating system either 98, ME, or XP, this type of problem...

Excel: Excel 2007, empty cells, creating a survey

empty cells, creating a survey, survey questionnaire: Nena - From your question, I am not sure if you want to delete the columns to the left, or just make them appear as a blank section with no gridlines. So I will answer both questions. To delete columns: Click on the column head, where the letter...

Excel: Excel 2007, color target, target address

color target, target address, macro editor: Hi - I realised that you only wanted to change the active cell, unfortunately, the only way I could think of to do it was with VBA -AND it only applies to the worksheet it is set on, so it s not ideal. The selectionchange event is in the macro editor - press...

Excel: Excel 2007 color palette, backgrounds and borders, theme colors

backgrounds and borders, theme colors, color palette: 1 - If you MUST use the old colors, you should use the format painter to copy them wherever. For any new colors, use the themes. 2 - Themes can t contain 40 colors, so that s not an option. 3 - to use the old colors you d need a file probably created in...

Excel: Excel 2007 data entry, format cells, menu format

format cells, menu format, menu tools: You can use the worksheet protection to achieve this. First, select the columns B and C, go to menu Format- Cells, and on the Protection tab clear the check box Locked. Then, go to menu Tools- Protection- Protect sheet, and accept the default by clicking...

Excel: Excel 2007 AND Excel 2003, regserver, click this icon

regserver, click this icon, excel exe: Find the .exe file for Excel 2003, right-click it and use Send To/Create Shortcut. Then right-click THIS file, select properties, put in /regserver at the end, something like this (your path may be a little different): C:Program FilesMicrosoft OfficeOFFICE11EXCEL.EXE...

Excel: Excel 2007- If Statements, bonus bonus, initial money

bonus bonus, initial money, bonus money: Ginger I don t think your telling me all the conditions. There is no need for an if statement in your description a1: 60 b1: 10 c1: =A1+B1 Let s say that if Sean earns more than 50 dollars, then he gets a bonus. If he earns 50 or less, then...

Excel: Excel 2007, xls file, pivot table

xls file, pivot table, vbe: That s why I said you really should do the work in the environment you ll be using it in. There is no ActiveWorkbook.PivotCaches.Create in Excel 2003. If you re-record the macro from xl2003 you d see ActiveWorkbook.PivotCaches.Add and there are probable other...

Excel: Excel, text import wizard, csv file

text import wizard, csv file, ogilvy: Ian, With the minimal information provided, I will assume this is a .CSV file. If so, change the extension to .txt, then open it in excel and use the text import wizard. Select Fixed width rather than delimited. This will allow you to make the decisions...

Excel: Excel, analysis toolpak, cell a1

analysis toolpak, cell a1, workday: From the main Excel menu, choose Tools, Add-Ins, make sure that Analysis ToolPak is checked, then click OK. Try this example. Select Col A and format it as dates. In cell A1, type in today s date. In cell A2, enter: =WORKDAY(A1,5) to return the date...

Excel: Excel, current sheet, unitil

current sheet, unitil, command button: If I understand the question the easiest way is to have the macro insert the formula, calculate the result and then set the value to the resultant value - record the macro to make it easiest to set up, but basically you are going to get something like ...

Excel: Excel, target value, vba programmer

target value, vba programmer, dc discharge: Private Sub Worksheet_Change(ByVal Target As Range) If target.count 1 then exit sub If Not Application.Intersect(Range( A1 ), _ Target) Is Nothing Then If Target.Value = CL Then YourMacroName End If end if End Sub...

Excel: Excel, sum function, apostrophe

sum function, apostrophe, cells: Hi Vickie, Yes, I believe that its purpose is to show text of what is entered in the cell. Another good use for it is if you have a list of numbers and you want to exclude one of them from the sum function, but you want to retain the number in the list...

Excel: Excel, b6, a6

b6, a6, f2: First, get a unique list of what s in A (Data/Filter/Advanced Filter, use only col A, click Unique values, click copy to another location). Let s assume that location is F1. Since F1 is likely a heading of some sort, put this in G2: =COUNTIF($A$1:$A$100,F2)...

Excel: Excel, cell reference, data areas

cell reference, data areas, pivot table: Easiest way to do it is via a pivot table (on sheet1, use the data menu, then pivot table and chart report - then follow the wizard - drop the row, column and data areas you want onto the chart and it will be created. To refresh, right click). Alternatively,...

Excel: Excel, cell a1, spreadsheets

cell a1, spreadsheets, spreadsheet: This is really strange, as the formula you are using should bring the value that is shown in the cell directly, and I cannot think on a better formula that the present one. If you want, you can send me a copy of the spreadsheet to m4zapic [at] yahoo [dot]...

Excel: Excel, indoor bowls club, format painter

indoor bowls club, format painter, format menu: I m chairman of Stevenage Leisure Centre Indoor Bowls Club! what you need to do is to use the FORMAT menu, then conditional formatting - this will allow you to use formulas, or just values to test against, and set various formats - should be reasonably clear...

Excel: Excel, mp 3 players, mp 3 music

mp 3 players, mp 3 music, type mp: Hi Sean Put your category data in columns elsewhere (like Sheet2): A B MP-3 Music CD Music DVD Film RC Car Toys ... and use the VLookup function. You type MP-3 into a cell in column K of sheet1 and a VLookup equation...

Excel: Excel, cmnt, visual basics

cmnt, visual basics, code space: Hi Carol First one is easy. Enter Design Mode (Select the toolbar icon with the ruler, set-square and pencil). Right-click on the control and select Properties. A pop-up window appears; select Font and set the desired size. Close the pop-up and deselect...

Excel: Excel, macros excel, xls file

macros excel, xls file, networked machine: The easiest way to share both of these is to give the people the spreadsheet that contains the chart and the macros. Excel stores user-defined custom chart types in XLUSRGAL.XLS on an individuals machine, but the chart is ALSO stored on the spreadsheet concerned....

Excel: Excel, countif, sumif

countif, sumif, repair time: Leo You can use the SUMIF and COUNTIF formulas to get you averages as follows. assuming the data you gave me is in rows 1 thru 5 to get the average of W repair time =SUMIF(C1:K5, w ,K1:K5)/COUNTIF(C1:C5, w ) To get the average of S repair time...

Excel: Excel, stock price, current value

stock price, current value, thanks in advance: Not clear how the data is refreshed, which would govern the nature of the reply - BASICALLY, there is no before update event, so if a macro can be used to refresh the data, it can move the existing data to another place - IF it is an automatic process, POSSIBLY...

Excel: Excel, customer account number, credit card numbers

customer account number, credit card numbers, vba macro: Hi, Dianne. I presume you have a list of names, credit card numbers, and account numbers. I also presume you want to enter, perhaps somewhere ELSE their credit card number and have it show their name and account number or something...so...are you looking to...

Excel: Excel, data validation, exact data

data validation, exact data, option button: OK, starts to get clear now. If you always select just ONE of these three options, you could use either: 1. An option button - rightclick the menu and select the Forms toolbar - Click the option button button and draw three of them on your worksheet...

Excel: Excel, task time, decimal representation

task time, decimal representation, time on task: It s not a problem, except that presumably a piece of work could feature in both day and night (eg started at 5pm, finished at 7pm). The calculation would therefore need to use the start/end times and check these against the times for day and night - I m...

Excel: Excel -, data validation, collumn

data validation, collumn, target: There is no click event for the worksheet, so the macro is never called - however, why not use Data Validation for the column which would remove the need for the macro? If you want to use a macro, then try the selectionchange event of the worksheet Private...

Excel: Excel, reasion, hello tom

reasion, hello tom, blank cell: I don t see an issue. Even more reason to follow that approach. once you enter the formula in C2, then select the cell and double click on the little square in the lower right corner of the cell outline and it will fill down the column. After you filter,...

Excel: Excel, data validation, reasion

data validation, reasion, emi: Here are two links that detail how to do what you want to do. They describe how to use Data Validation to prevent a duplicate entry from being typed in a range, which is in essence what you want, in a different way. I did not want to have to type/explain...

Excel: Excel, target value, reasion

target value, reasion, sheet tab: Right-click the sheet tab, select view code, enter this: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Then current column is B Application.EnableEvents = False Set exists = Range( A:A ).Find(Target.Value)...

Excel: Excel, reasion, unique records

reasion, unique records, emi: I can think of various ways of doing it - one method is to copy both sets of data into one column (probably on another sheet), then use the data, filter, advanced filter to filter on unique records only - copy this result back to the first column. Using...

Excel: Excel, relevent data, goal sheet

relevent data, goal sheet, f7 key: you ve given me a little conflicting information. The original question says ...on the next months goal sheet and the followup says ...another workbook for each month... So are they separate workSHEETS or separate workBOOKS? Big difference. Feel free...

Excel: Excel, s1 s2, string s1

s1 s2, string s1, sstr: You said import a text file, so this macro allows you to browse to and select the file AND open it on the current sheet starting AA12. (handles a file such as you show) Sub GetAndReadTextFile() Dim LineofText As String Dim rw As Long, bSpace As Boolean...

Excel: Excel, format cells, best bet

format cells, best bet, drop down list: Hi Tony, I think your best bet is to password protect the sheet, but if you have cells that you want to be edited, you can select those (highlight or choose individually) format cells/ protection and uncheck the locked selection prior to protecting the...

Excel: Excel, tab sheet, macro button

tab sheet, macro button, sheet tab: It is hard for me to suggest anything specific since you have only shown a few lines of code and none that would indicate how you added a sheet and named it Dec. So best I can assume is you now haf a sheet named Dec and you want to change the heading in C1...

Excel: Excel, digit number, excel 2000

digit number, excel 2000, glitch: Heather Excel s number precision is limited to 15 digits, which basically means that any digits over 15 will show as a number to a power ie 1.1111E+16 and drop the last numbers to 0. If you aren t using the numbers in a calculation change them to text,...

Excel: Excel, data2, data1

data2, data1, sucess: Hi Daniel, How are you? Please try the following 1st TOOLS - MACRO - VISUAL BASIC EDITOR 2nd insert-module 3rd copy the following Public Function AvR(A As Range) Dim data1 As Date, data2 As Date data1 = 01/01/2003 : data2 = 01/01/2004 c = A.Rows.Count...

Excel: Excel, cell a1, string place

cell a1, string place, cell b1: Dear Amanullah, There is another macro at the end of this email. You will need to copy the macro then open Excel and press Alt+F11 (or hover your mouse pointer over sheetname and right-click and select View Code )then select Insert from the menu then...

Excel: Excel, target value, target address

target value, target address, value application: Hi Bruce How are you? I know that this is not what you want, but maybe you can work out the solution from that Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim Keepvalue As Range Set Keepvalue = Range( A22 ) A = Keepvalue.Cells(1, 1)...

Excel: Excel, b4, free time

b4, free time, a1: Sorry I do not write code for people on this site. Since I do this in my free time then that is all I would be doing. Moreover, requests like this are always more involved than what they appear to be and always take longer to write. I am sure you can understand...

Excel: Excel, c cells, b cells

c cells, b cells, column c: Hi Daniel, How are you? Please try the following 1. TOOLS - MACRO - VISUAL BASIC EDITOR 2. INSERT - MODULE 3. COPY Sub inAbutnotB() Dim A As Range, B As Range, c As Range Set A = Range( a1:A20 ) Set B = Range( b1:B10 ) Set c = Range( c1:C20...

Excel: Excel, different colors, critical situation

different colors, critical situation, rng: Hi Aman, Go to the sheet where you want to type the names and press Alt+F11 Paste the following Macro into the blank right side of the Visual Basic Editor. Close Editor and type in Column A the names Michael , George , Ken . You can change the macro...

Excel: ############## in Excel, hi tim, cell a1

hi tim, cell a1, character limit: Hi Tim, I don t know what version Excel you are running. But in Excel 2000 and on. The character limit of a cell to display is 1024. The formula bar will hold 32767 characters. This all varies due to font, size, formatting, etc...To find out more about...

Excel: Excel, target address, blank window

target address, blank window, question the question: Hi Aman, I am sorry I wasn t clear. You can download an example workbook with this macro at. www.squish.com/cloverleaf/adda.xls Here are clearer instructions to use this macro. Copy macro at the end of this email. Go to workbook where you want to...

Excel: Excel, vlookup, time chris

vlookup, time chris, excel 97: If you have these Numbers & names in cells H1:I50, for example, then assuming you re going to enter the number in cell A2, put this formula in B2 to automatically fill with the name: =IF(A2= , ,VLOOKUP(A2,$H$1:$I$50,2,FALSE)) and fill down as far as necessary....

Excel: Excel, keyboard shortcut, shortcut menu

keyboard shortcut, shortcut menu, previous question: Hi, Brian, I see on that date a message I answered to a Janie, but I cannot find any previous message about that subject. However, I m happy to explain how to put a shortcut on the toolbar. 1) Point anywhere up on a toolbar, and right-click. A shortcut...

Excel: Excel, microsoft knowledge base article, microsoft knowledge base

microsoft knowledge base article, microsoft knowledge base, knowledge base article: I ve set out below a knowledge base article on this issue - the ONLY certain way to change the calculation is to have a macro run on the OPEN event of the workbook which changes the calculation mode (at least, that is my experience) (this is taken from...

Excel: Excel, target address, dear sir

target address, dear sir, good health: Hi Aman, Here is the corrected Macro, It will only work in Column A now. Also like I said if you enter a formula in a cell such as =20*12 it will return a result of 240 and add it to the column total. Let me know if you need something else. Private Sub...

Excel: Excel, double quotation marks, apple trees

double quotation marks, apple trees, column label: S I would start by saying that I think the Help files in Excel are great for this topic, so that s what I m using as a reference here. DSUM(database,field,criteria) Database is the range of cells that makes up the list or database. A database is...

Excel: Excel, column right, a3

column right, a3, explanations: Hi Mutthuvel, How are you? I think that the best thing you have to do is to look up these functions in trhe Excel help. The help explanations are better than those I could give to you. E.G. 1. Type HERE IN A9 2. Type =OFFSET(A7,2,1,1,1) in A3 you...

Excel: IF in Excel, 111111, a11

111111, a11, a10: Paul The rest is just math If 18 units equal a basket, and 9 baskets equal a stack, then 9 times 18 is how many units in a stack or 162 units. the 37.1111 we calculated is the number of stacks so we now need to calculate how many units .1111 of a...

Excel: Excel, numerical data entry, douglas m smith

numerical data entry, douglas m smith, minute segments: Hi John, This can be done but I would advise against using this convention. 7.1 and 7.10 look different but are the same numerically. Having them as text and them would make them different but it adds extra layers of complexity when ever you want to do...

Excel: Excel, change colors, thrue

change colors, thrue, office xp: Alma You need to use conditional formatting. Go to toolbar/format/conditional formatting. I think you will see from the conditional formatting window how to do it. If not let me know. You are limited to three different conditional formats in the...

Excel: Excel, ms excel macro, ms office document

ms excel macro, ms office document, test xls: I m not sure I understand the question, and I m not familiar with Image Writer which probably wont help, but an Excel macro CAN change the path or save a file to ANY path ( eg activeworkbook.SaveAs filename:= c: est.xls would save to the root of C...

Excel: Excel, douglas m smith, data validation

douglas m smith, data validation, brainbench: Hi Randy, I hate it when that happens! You want the Data Validation feature. Select the cell(s) to apply the list to and then select Validation from the Data menu. On the settings tab, select List from the first dropdown box and the enter (or point...

Excel: Excel, conditional formatting, cell b1

conditional formatting, cell b1, cell a1: Here s what I would do. Put =A1-1976 in cell b1. Then, use conditional formatting to make the font of b1 white if no value is in cell a1 and black otherwise. To set up conditional formatting, select the cell, click Format Conditional Formatting and follow...

Excel: Excel, quotation marks, explaination

quotation marks, explaination, madam: I think I understand now, Aman. You have values in A1:A3. You would like to sum those values in A4, and add on some words to the end of the sum. That s very easy. You need to use the & sign to concatenate (or paste together) a value with a piece of text....

Excel: Excel, paste details, excel sheet

paste details, excel sheet, pat pat: Pat, I can t say for sure, but I would guess that the answer would be not easily. I know it s possible to set up links to sites, and download data on a recurring basis, but I think there would be issues with having to provide a login and password through...

Excel: Excel, nam nguyen, target value

nam nguyen, target value, necessary range: You COULD convert them to hyperlinks (try recording a macro to do so & see what you get), or, you can do this: Right/click the sheet tab, select View code, enter this: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If IsNumeric(Target.Value)...

Excel: Excel, cell b1, debug error

cell b1, debug error, mr ken: Hi Amanullah, Excel will not let you have an input in cell B1 and have a formula in cell B1. Because you are asking to either input the value of 2 in cell B1 or have cell B1 value change if cell C1 value changes. This is not logical for excel. I do not...

Excel: Excel, digits number, excel 2002

digits number, excel 2002, decimal places: =ROUNDUP(your current formula,1). From help: Rounds a number up, away from 0 (zero). Syntax ROUNDUP(number,num_digits) Number is any real number that you want rounded up. Num_digits is the number of digits to which you want to round number....

Excel: What is Excel?, squares rectangles, cheers

squares rectangles, cheers, homework: Hi Temitope, Excel is a powerful calculator that allow to compute complex calculations by resorting to built in mathematical, statistical, textual etc functions. It mimicks traditional sheet of paper, by dividing the working area into small squares/rectangles,...

Excel: Excel, madam, a3

madam, a3, a2: Here is the formula you put in A4: =SUM(A1:A3)& USD Unfortunately, you can t format only part of a formula s result. There isn t a way to bold the USD and leave the sum normal. If the cell contained the text 20USD you d be able to do so. But...

Excel: Excel, visual basic programming, vb excel

visual basic programming, vb excel, www tutorials: Dear Aman, I am doing fine. How are you? I know Visual Basic programming only at a beginner level. All my Excel knowledge is self-taught. I believe the books that I recieved the most help from was written by John Walkenbach. His book on Power programming...

Excel: Excel, excell 2000, copy paste

excell 2000, copy paste: Michelle I m not really sure what the question is. But let me try. Sounds like you have a total for the month that you don t want to change once you have entered the information for the month. One way would be to create a template that you use for...

Excel: Excel, douglas m smith, menu filter

douglas m smith, menu filter, autofilter: Hi Mike, I about to head out of town for the week so I won t have time to give as detailed of a solutions as I normally would but this should get you started. Here is a low tech solution. I would add a column for the number of items you want to order...

Excel: Excel, format cells, menu bar

format cells, menu bar, madam: Hello, Aman, You can format the cell to display its value with some text alongside it. Follow these steps: 1) Enter the number 45 in A1. 2) On the menu bar, go to Format Cells. 3) Make sure that you re on the Number tab, and choose the Category called...

Excel: Excel, cell a1, dear madam

cell a1, dear madam, format cells: Hello, Aman, Follow these steps closely: 1) Click in cell A1. 2) On the menu bar, go to Format/Cells. 3) In the Format Cells box, go to the Number tab. 4) Under Category, select Custom at the bottom. 5) In the Type field (it currently says...

Excel: Excel, windows 2000 professional, allexperts

windows 2000 professional, allexperts, word document: Kathy My understanding from your question is--- The worksheets/workbooks you are trying to open have not been protected so that you cannot open them, and when you turn your computer off and then back on you can access the files. Sounds like potentially...

Excel: Excel, ms office 2000, xlstart directory

ms office 2000, xlstart directory, dublin ireland: You d need a macro to do it as a shortcut. You ll like this macro: If you have a personal.xls then make it visible (window/unhide) and right-click the Excel LOGO near the file menu, select View Code and put this in - if you do NOT have a personal.xls then...

Excel: Excel, microsoft excel 97, sr 2

microsoft excel 97, sr 2, creating a new workbook: I can almost guarantee that EXCEL is not doing this on its own just to have fun. There is something else involved that either you are just not aware of or that you have not told me. Perhaps you are importing or copying and pasting data or filtering the...

Excel: Excel, format cells, amanullah

format cells, amanullah, sheet input: I just received notice that you did not receive my original reply so I m sending again. Select A2 and go to Format/Cells. On the Protection tab, turn on both Locked and Hidden. Click OK. Now go to Tools/Protection/Protect Sheet. Input a password, and...

Excel: Excel, ms office 2002, documents folder

ms office 2002, documents folder, double click: I have experienced exactly the same problem BUT cannot find it documented anywhere on the MS Site! My experience is that IF I start Excel, I can then open shortcuts or double click the file in Explorer with no problem but IF Excel is not running then the...

Excel: Excel, ms office 2002, regserver

ms office 2002, regserver, excel exe: 2 things you can try. with excel open, go into tools= Options= General tab and make sure ignore other applications is not checked. If it is checked, then uncheck it. The other is to close excel and then go to the windows start menu and choose RUN...

Excel: Excel, exact instructions, column c

exact instructions, column c, runyon: Hello, Seretha, Yes, it s very possible. Since you didn t give me much information about your spreadsheet, it s difficult for me to give you exact instructions, but I can give you some tips here to follow. Let s say that the vehicle age is in number...

Excel: Excel, excel spreadsheet, form letters

excel spreadsheet, form letters, packing slip: Yes, you can use VBA to bring in specific data, but probably easier is to use mail merge - sounds as though you are BASICALLY wanting to produce the form letters option (even though it isn t a letter) - just drop the fields you need in and set the filter options...

Excel: Excel, row headings, using ms office

row headings, using ms office, programming option: Hi, Jon, The only way to actually *select* cells that meet certain criteria is to program a macro to do so. But there s another non-programming option that may meet your needs: filtering your data. AutoFiltering is one of my favorite features in all...

Excel: Excel, cell d2, transcription business

cell d2, transcription business, michelle king: Hi Michelle, It s only complicated if you don t know how to do it. Fortunately, Excel is well equiped to handle this task. First, we ll need to build a table of your pricing information. Start it in column M2 to keep it away from your list of entries....

Excel: Excel, stock ticker symbols, quick excel

stock ticker symbols, quick excel, matt phillips: Yes - very possible A macro for JUST the situation you describe would be Sub ticker() For Each cell In Range( a1:a10 ) If cell.Value = bby Then cell.Offset(0, 1).Value = long term growth Next End Sub An alternative and better one is...

Excel: Excel, column spreadsheet, new computer system

column spreadsheet, new computer system, spreadsheet column: You could certainly have a formula, but unless I ve misunderstood the question I think you will find tha the Pivot table option on the Data Menu will do what you want a whole lot faster, as it can return the count for each item (or the sum of the quantities!...

Excel: Excel, column spreadsheet, new computer system

column spreadsheet, new computer system, target value: Right-click the sheet tab, select View Code, paste this in: Private Sub Worksheet_Change(ByVal Target As Range) Dim n As Integer On Error Resume Next If Target.Column 1 Then Exit Sub Application.EnableEvents = False n = 0 ...

Excel: Excel, address line, spreadsheet

address line, spreadsheet, comcast: Fran, What type of form is it? VBA form? Spreadsheet Form? Control Toolbox Form? My answer depends on what method you used to create the form. Perhaps the easiest way is for you to send me the file. If you wish to do that, you can send it to xeon{theone}flux@comcast.net....

Excel: Excel, excel spreadsheets, dbf file

excel spreadsheets, dbf file, blank rows: Not really enough information to provide a proper answer, but I m GUESSING that if you press Ctrl End you will get to row 65k ish - which may be the problem. Personally, I would live with the data and run a query on the DBF file to delete all completely blank...

Excel: Excel, cell a2, cell a1

cell a2, cell a1, georgette: Hi Georgette, Assume that you have a number in cell A1 and you want to divide it by a number in cell A2...in the cell that you want the answer to appear place this formula: =IF(A2= , ,A1/A2) It will show the result if there is a number in cell A2....

Excel: Excel, mirror image, thanks in advance

mirror image, thanks in advance, f1: either one at a time, or all at once then sort the columns by putting a dummy series at the top or bottom and sorting left-to-right by that row, or via a formula which does something like this: assuming your data is in A:F and you want the mirror image...

Excel: Excel, dataset, several ways

dataset, several ways, d3: Mike There are several ways to do this. The simplest may be this formula: =B3&C3&D3 for row 3 assuming the Sta is in column B, etc. Then just double click the lower right corner of the cell to autofill to the bottom of the congruous data set. You...

Excel: Excel, blank rows, payables

blank rows, payables, blank lines: Vee Since I don t know how you set up the worksheets to automatically get the data from the sales sheet, I can t really say how to fix what you have. What I would say is that you can use VBA code to allow more flexibility with where the data is placed...

Excel: Excel 7.0, excel 7, logging data

excel 7, logging data, excel 5: IF you are getting files from other people that you need to process, then an upgrade is probably sensible. IF however the program you have does the job you want, then stick with it - at the Insurance company I work for, we still have Excel 5 sheets in use...

Excel: Excel, category labels, excel microsoft

category labels, excel microsoft, well thanks: Alex, Without seeing your spreadsheet, I d recommend keeping all the items in one list and using an alternate descriptor in an adjacent column. For example, in my master list in column B, I have a list of items: Apple Pear Orange Gatorade Milk ...

Excel: Excel, format cells, savvy user

format cells, savvy user, excel worksheet: The EASIEST way to not show the math, etc is View/Formula Bar. But a savvy user can simply display it again. Another way is to select all cells, use Format/Cells, select Protection Tab, select Hidden. But then you d have to protect the worksheet and that MAY...

Excel: Excel, cd autoplay, excel sheet

cd autoplay, excel sheet, excel worksheet: An install wizard sounds like overkill for a spreadsheet, but you could probably make the CD autoplay (this is outside my area of expertise although I know it s possible). You could also get the Excel sheet to recognize that it is currently read-only when...

Excel: Excel, hh mm ss, timesheet calculator

hh mm ss, timesheet calculator, ss format: exactly what are you typing to enter 6 hours, 30 minutes? You should enter 6:30 - the colon is necessary. Entering this into a never-used cell will also format it as h:mm. The issue isn t necessarily how you format it, it s what it contains. I need to know...

Excel: Excel, format cells, dollar signs

format cells, dollar signs, plaes: Abby How do you format a cell to have dollar signs next to the numbers? Select the cells you want the formatting in and go to Format Cells and select Currency, this will format to the non accounting $ format. How do you add the contents of cells...

Excel: Excel, real choices, move selection

real choices, move selection, f5 key: If you want to stay in the same cell, you can hit ctrl/enter instead of enter, or, you can use tools/options/edit and deselect Move selection after enter To move to a specific cell, your real choices are up/down/left/right, as from above. But to go from...

Excel: Excel, vlookup function, functions in excel

vlookup function, functions in excel, cell contents: The EASIEST and QUICKEST way of handling this is to put the list on to a worksheet/workbook - it s only temporary, so can be deleted later. Then use a vlookup function to look up the values - any cases that match will show data, any that fail will show #n/a...

Excel: Excel, invoice number, myinvoice

invoice number, myinvoice: unique from what? You can always take all the values you have so far and add 1. If it s historical and you don t have all the others handy, you can keep the last invoice used in the registry (thru VBA): NextInvoice = GetSetting( MyInvoice , MyInvoice ,...

Excel: Excel, city of morro bay, umbrella agency

city of morro bay, umbrella agency, drive crash: diane Sorry I m slow getting back to you I had a hard drive crash on my computer. Anyway---You need to have the A column names appear in all of the rows so that you might do a sort based on column A and then on column B. Sorry to give you that news, but...

Excel: Excel, excel spreadsheet, lookat

excel spreadsheet, lookat, office location: One thing that can increase the size of a file is when people apply formatting to entire rows or columns - you can soon find out if this is the case by pressing Ctrl End to get to what Excel regards as the physical end of the workbook. IF it is this that...

Excel: Excel, list of names, xls

list of names, xls, sample book: Hi Steve, Sorry I have been busy and it took some time to get back to you. I have worked out a sheet that will sort out if the names appear in all three columns. Here is the formulas that I used. Column D =IF(COUNTIF($A$1:$A$100,B1) 0,B1, ) Column...

Excel: Excel, autofilter, excel microsoft

autofilter, excel microsoft, personal issue: Hi, Alex, Please excuse the delay. I had a personal issue to take care of. Are you familiar with AutoFilter? You can AutoFilter your master list, and see smaller lists from it at any moment. That way, you don t need to maintain any kinds of smaller lists....

Excel: Excel, run time error, history worksheet

run time error, history worksheet, stack space: 1. Probably the easiest way to clear the info is to manually select ALL the fields you want cleared EXCEPT any cells containing formulas, then give the resultant selection a name (Insert/Name/Define). Suppose you call this range ClearMe . The VBA is Sub...

Excel: Excel, cell b2, cell a2

cell b2, cell a2, cell c2: Tina Not knowing exactly how your document is set up I m gonna make some assumptions as follows: You have columns that list column A department number column B the number of Part time employees column C the number of full time employees So...

Excel: Excel, left mouse button, spell checker

left mouse button, spell checker, mouse pointer: Hi Shaun, You can insert a short Macro to handle this. Sub SpellCheckIt() Sheets( Sheet1 ).Unprotect password ActiveSheet.CheckSpelling Sheets( Sheet1 ).Protect password End Sub You will need to modify it. Change the word password to your...

Excel: Excel, word data, spread sheet

word data, spread sheet, b1: There are a variety of ways one might go about doing this, but I think CONCATENATE will be the simplest and most elegent solution. For example, A1 is blank, B1 is blank, C1 contains the word Data , D1 is blank, E1 is blank, and F1 is blank. Place the...

Excel: Excel, disc cleanup, internal hd

disc cleanup, internal hd, extraneous files: Jacques It could be one of many things, to little RAM ie 256 ram as opposed to 512 ram. Or you may want to run the cleanup in Start Programs Accessories System Tools Disc Cleanup to get rid of all the extraneous files that can appear on you pc,...

Excel: Excel, service pack updates, hardware conflict

service pack updates, hardware conflict, internal hd: I will admit upfront that this sounds like a hardware/software problem between office and the hard drive. As such, this is a little out of my area of expertiese - nevertheless, I ll ramble on with some of my various ideas... I did some searches on the...

Excel: Excel, disk compression utility, internal hd

disk compression utility, internal hd, chkdisk: Not sure, but if you re having the same problem with the other programs, it s likely you re running low -- 300MB is pretty small, these days. Try running Chkdisk or some disk compression utility, or browse your files & get rid of unnecessary data - or clear...

Excel: Excel, appearance tab, using windows 98

appearance tab, using windows 98, default format: ...Is there a way to link comments from Sheet 1 within a workbook to sheet 2?... To my knowledge, No To change the default format of a cell Comments: 1. Press +M (the key is located between the Ctrl and Alt keys) to minimize Excel and any other open...

Excel: Excel, outer border, column headers

outer border, column headers, ogilvy: Hello Willee You can hide the rows or columns you don t want viewed Go to the outer border of the sheet where the row or column headers are located and select the rows or columns you want to hide. Then do format= Row= Hide or Format= column= Hide ...

Excel: Excel, open office, aidan

open office, aidan, ms office: Difficult to answer, as it s not clear what would have caused Excel to want to be re-installed. The normal solution would be to do exactly that, but as you don t have the CD that s going to be hard. Alternatives are (1) use whatever backup process you use...

Excel: Excel, excel microsoft, cell a1

excel microsoft, cell a1, well thanks: Alex I don t know what your data looks like or what your criteria are for your smaller lists, but you can use an if then formula in the smaller lists and identify the criteria and link to the master list. The formula in the smaller list might look like...

Excel: Excel, cell addresses, blank row

cell addresses, blank row, n20: Not sure of the layout of your data, but if it s in A1:N20, for example, you should select A1:N21 (include the blank row at the bottom), and one click of the sum tool will do it. If this doesn t match your data, describe more clearly how it s laid out (include...

Excel: Excel, infinite series, aidan

infinite series, aidan, infinity: OK, that helps - though not sure what you need to do here - are you trying to run a calculation as many times as is necessary to get a particular value - if so the GOAL SEEK from the TOOLS menu may be what you need - otherwise, if you can clarify further I...

Excel: Excel, microsoft office 2000, triangular object

microsoft office 2000, triangular object, excel spreadsheet: I m not 100% sure, but I SUSPECT it s something like smart tags - if you click on the triangle it will PROBABLY give some clues as to what it is doing there! If it helps to mail a sample file (or perhaps a screen shot?) you can get me at aidan.heritage@virgin.net...

Excel: Excel, shets, staff location

shets, staff location, staff name: This is not a question per se because the key word here is system , which can involve quite a bit. You want me to develop/design a system for you for free or explain ALL that would need to be done if you do it yourself? All volunteers on this site answer...

Excel: Excel, windows 2000, dawn

windows 2000, dawn, cells: The easiest way in my opinion is to write two little macros that chanage the font color of the cell you do not want to print to white and then back to black after you print Sheets( Sheet1 ).Range( A1 ).Font.Color = vbWhite Sheets( Sheet1 ).Range( A1...

Excel: Excel, countif, sumif

countif, sumif, excel user: In cells A1:A3 put the number 1. In cells A4:A6 put the number 2. In A8 put 1; in A9 put 2. Then in cells B1:B6, put any numbers you like; these are the numbers you want to average. In cell B8 put the fomula: =SUMIF($A$1:$A$6,$A9,B$1:B$6)/COUNTIF($A$1:$A$6,$A9)...

Excel: Excel, track grades, homework assignments

track grades, homework assignments, t scores: If your spreadsheet is set up like this: column A: student name or ID columns B-P: scores for the 15 tests that count as 60% of the grade columns Q and R: scores for the tests that are 15% each columns S and T: scores for the 2 homework assignments that...

Excel: Excel 97, personal computer tutor, xls workbook

personal computer tutor, xls workbook, three keys: Hi Phillip, Ah Yes, I see. If you can get a file to your laptop that would be great. In Microsoft Word you can enter cents with the three keys Ctrl, forward slash and c. Ctrl+/+c then copy and paste to excel. You can also try a simple macro that...

Excel: Excel '97, sort function, excel 97

sort function, excel 97, swbell: I suspect I do not understand the question. If you have the following data in rows 1 thorugh 3 of columns A through C: A B C Green 1/1/06 Bob Blue 2/2/06 Bill Red 3/3/06 Brandy If I were to select B1 (1/1/06) and click the sort descending...

Excel: Excel 97, good answer, excel 97

good answer, excel 97, file extension: Joe Iam afraid I don t have a good answer for you. I have not had that happen and don t know what the .xlsm extension file type is. Of course creating a shortcut or using the old extension won t work if the file extension in the shortcut isn t the same...

Excel: Excel 97 Compatability Notification, microsoft excel 97, message boxes

microsoft excel 97, message boxes, type microsoft: The only fix I can find is to use Excel 97, create a copy of each worksheet in the workbook to a NEW workbook, then save that workbook - because it s done in Excel 97, you then have solved the problem. Otherwise, excel will recognize that a later version...

Excel: Excel 97 - Links, douglas m smith, manual option

douglas m smith, manual option, brainbench: Hi Lisa, Tracking down links like this are part science, part art. They can lurk just about anywhere. Try looking in your defined names. One (or more) of them could be referring to another workbook. If you still come up empty, look at charts or other...

Excel: Excel ('97) Macro Involving the Solver App, excel 97 macro, record language

excel 97 macro, record language, valueof: Though this may be what was exactly and initally recorded, which I doubt, then you have syntax errors. VBA can not interpret $E$12 , for example. It should be Range( $E$12 ) in every situation So, try changing, for example SetCell:= $E$12 to be ...

Excel: Excel 97 - Multiple if statements?, cell b1, cell a2

cell b1, cell a2, cell a1: I m not sure what you need to do for the comparision with B1, so I ve left that part of the formula as B1, but =IF(NOT(ISBLANK(A3)),B1,IF(NOT(ISBLANK(A2)),B1,IF(NOT(ISBLANK(A1)),B1, No Values ))) should do it for you if I ve understood correctl...

Excel: Excel 97 & Pivot Tables, table charts, pivot tables

table charts, pivot tables, pivot table: You can give it a auto-defining name, like Database, which refers to: +OFFSET($A$1,0,0,COUNTA($A:$A),6) which would grow as info is added. This would be from A1:Fx where x would be the last row. Once data is added, you can click the red exclamation mark...

Excel: Excel 97 rows & columns resizing themselves, financial worksheets, excel 97

financial worksheets, excel 97, courier new: Joe, unfortunately, I don t have a copy of 97 to check this with, and I can t remember this ever happening. I would be a little curious which font you are using. It used to be that Windows reported some fonts so that Excel wouldn t recognize how much space...

Excel: Excel 97 SR-2 - date format getting changed, excel xls, excel template

excel xls, excel template, date formats: Bob Well that takes the easy answer away. The only other option I can think of is that your windows may be set to a different date format than what you are using in excel. Excel takes from windows for its date formats. Make sure windows is set to that...

Excel: Excel 97, best bet, excel 97

best bet, excel 97, programmatically: Luis The easy way would be to use Access which would allow you to create one table and then queries for each store which would automatically include any new information you imported into the access database, however the next best bet would be some sort...

Excel: Excel, greek sigma, keith thomas

greek sigma, keith thomas, danville ca: KEITH Tell her to try this =SUM(A1:A5) This is usually on the toolbar using the greek sigma or sum sign Clic on that sign and then paint the cells that you want to sum then hit enter. Or of course you can type it. Hope this helps Richar...

Excel: Excel, blank cells, option works

blank cells, option works, menu choice: Use the data menu, then the Text to Columns option (works for Excel 97 onwards - you didn t give me a version, so hopefully the answer will work for you) - NOTE that you will need blank cells to the right of the data for this to work, and you should select...

Excel: Excel or Access, tables access, personal detail

tables access, personal detail, detail results: If the data can be represented in a single table, Excel can be a easier solution, but it depends on your familiarity with both programs. The size of the database is not going to be a issue, even if you have 100 times more students, Excel could be efficient...

Excel: Excel or Access inventory tracking, data validation, access inventory

data validation, access inventory, database type: You can certainly create a database type file in either application - probably easiest with Excel as you are simply recording the file name and it s location - I m assuming we are talking physical files here, rather than computer files. If the location is...

Excel: Excel: Add dates, format cells, leap year

format cells, leap year, tricky question: Hi Chante How are you? You have to convert 3.7 into days and then sum up to your date For example if you want to sum 3 years (there are no leap year in this interval) in A1 type the date in B1 type =3*365 in C1 type A1+B1 The problem is to convert...

Excel: Excel Add-ins, excel spread sheet, aidan

excel spread sheet, aidan, cells: I don t quite follow the question - certainly you can add formulas to your sheet that refer to other cells, which presumably would contain the data from the add-in. If you can clarify the question I may be able to help further - my email if it helps is aidan.heritage@virgin.ne...

Excel: Excel -- Adding Cells from different worksheets together, cell a1, time kevin

cell a1, time kevin, excel 2002: Kevin You need to use a linking formula that looks like this: =Sheet1!A1+Sheet2!A1 The formula is in worksheet three and says Go to worksheet 1 and add cell A1 from worksheet 1--- then go to worksheet 2 and add cell A1 from worksheet 2. You can...

Excel: Excel Adding Question, cell b2, column c

cell b2, column c, cell c2: Hi Terry, I just wanted one clarification on your question. Are the values in column C dependent on column B?... If both columns are independent of each other then your question can be answered in 2 steps. Step 1: Since you want the amount to increase...

Excel: Excel Addition Question, sum function, column c

sum function, column c, eldon: Hi Terry, To sum the values of column B use the sum() function and to round down the output use the rounddown() function. It should look something like this... =ROUNDDOWN(SUM(B1:B2),0) However, I need some clarification on what you mean by reduce...

Excel: Excel - Adjust cell size to contents, macro recorder, column width

macro recorder, column width, ogilvy: You can turn on the macro recorder and then select the entire row and do Format= Row= Autofit Turn off the macro recorder and you will have the code for executing an autofit. If autofit doesn t work as you want, then I am afraid VBA itself doesn t offer...

Excel: Excel Algebra, graph equations, algebra 1

graph equations, algebra 1, algebra problems: Perform Algebra 1 formulas? Like what? Excel is not a solution engine for Algebra problems. You re not going to find anything that will move a variable from one side of the equal sign to the other. Graphing equations, yes. There are some examples...

Excel: Excel - Alternate Units, metric conversion, simplest form

metric conversion, simplest form, a1: It is possible, using the & operator and repeating the formula that gives the result. In the simplest form, you can do something like this: =A1 & ( & A1*25.4 & ) Instead of the reference to A1, you will normally have the formula that yields the number...

Excel: Excel Amount in Word., len, job

len, job: This isn t available in Excel in the built in functions, so you will need to create your own function - I ve had to do this for other people, so here is a function that will do the job Function ft(n) n = Int(n) Dim convert$ convert$ = Trim$(Str(n))...

Excel: Excel Amount in Word., sorry jeff, excel sheet

sorry jeff, excel sheet, word one: Razzak, I do not know of a function that will make that happen for you. I know there is a function named BAHTTEXT that will convert a value to its word format, but in Thai Baht dollars. I don t know of any other function that is similar. Sorry Jef...

Excel: Excel API call, chris rae, hidden password

chris rae, hidden password, vba code: I believe these are one and the same. So, if you are using Mr. Erlandsen s code, it should still work. I don t have a disconnected machine to test with, so I can t verify it. However, I checked the SDK documentation and didn t see any other API function...

Excel: Excel API call, hidden password, logon id

hidden password, logon id, case statement: Bill, I m not sure if you really need to use an API. If the user logs in to the machine, does Excel change the active name of the user (it should)? If so, then you should be able to just check with Excel to see who the user is, like this: If Application.UserName...

Excel: Excel Array, google spreadsheets, range names

google spreadsheets, range names, google: I don t really follow (an example would help greatly -- feel free to send a sample wb to me at bobumlas@yahoo.com with the subject AllexpertsQ), but in general, to get more than one cell returned with more than one value, you must first select all the cells...

Excel: Excel: Array & Countif, array formula, array formulas

array formula, array formulas, sumproduct: Hi, Philip, There are two ways to accomplish this. #1: Array formula The array formula that you need looks like this: (=SUM(($F$2:$F$30= Unavailable )*($B$2:$B$30 =TIMEVALUE( 6:00 )))} #2: SUMPRODUCT By using SUMPRODUCT, you don t need an...

Excel: Excel Array Formulas, array formula, array formulas

array formula, array formulas, b100: Hi Betsy, Yes you can write an array formula in one sheet based on data in another sheet. Here is an example array formula. =SUM((Sheet1!A1:A100=A1)*(Sheet1!B1:B100=A2)) You can place this formula in Sheet2 and it will draw data from Sheet1 notice...

Excel: Excel Array Formulas, array formula, array formulas

array formula, array formulas, breakfast lunch: Are you sure you want an array formula? In the first part of your question you mentioned you wanted to copy the contents of B3, C3 and J3 to another sheet. That sounds more like an automated copy/paste macro in which case I have lots of examples of how...

Excel: Excel Array, array formula, cell a1

array formula, cell a1, position text: Robert Not sure if this is the best answer, but since the array formula won t work very well with FIND. or SEARCH, because they will produce the VALUE error message when the sarched for text isn t found, here is what I would do. First (copy the data...

Excel: Excel's Auto Filter Limitation, question column, client names

question column, client names, unique items: Hi Robert, Yes, you can trust the B filter. You could also test this by running a COUNTA formula on each of your three countries and then going back and doing the filter on USA, highlighting the column of USA and right-clicking down in the lower right...

Excel: Excel - Auto fill function, blank fields, blank field

blank fields, blank field, excel 5: Hi Jay! How are you today? Please try the following program in VBA 1. TOOLS - MACRO - VISUAL BASIC EDITOR 2. INSERT - MODULE 3. COPY Sub fillingGap() On Error Resume Next Dim A As Range Set A = Range( A1:A20 ) change the range to fit your need...

Excel: Excel Auto Numbering, excel template, pono

excel template, pono, newpo: THe parameters for GetSetting and SaveSetting are Appname,Section,Key,Default -- I used arbitrary names for the first 3 items -- you can use whatever you like. But whatever you use for the SaveSetting you should also use to retrieve it from the GetSetting....

Excel: Excel Auto sum...., format cells, row numbers

format cells, row numbers, sum function: Alex Sounds like a formatting issue--You can format the cells that are a problem for you by painting the cells that you want to format, then going to toolbar/format/cells/select number/number and clic on the 1,000 spacers box. This will put the spacers...

Excel: Excel Autocomplete, autocomplete feature, data validation

autocomplete feature, data validation, many thanks: Hi, Linda, As you can imagine, AutoComplete does not work with numbers. It is designed to work only with text. That s logical. All is not lost, however. I suggest you type the first couple of characters and then press Alt/ down arrow . A list of the...

Excel: Excel AutoFilter, office xp profesional, excel autofilter

office xp profesional, excel autofilter, ms office xp: Hi Amajit Basu! How are you? Yes,there is something wrong with Autofilter.It does not work with numbers but it works with strings. You can solve the problem using maths. 1. Type your numbers in A2:A10 2. in B2 compute the number of digits of A2...

Excel: Excel Autofill, excel autofill, data2

excel autofill, data2, cell a1: Bob Autofill is used to fill a series of dates, numbers, etc. where there is a logical progression of the series. In your example your series of data doesn t flow progresively. Sound like what you want to do is a simply copy/paste, which you can do...

Excel: Excel Autofilter default, excel autofilter, caption bar

excel autofilter, caption bar, filter criteria: Hello Veli-Antti Murrinen, Since the selections in the Autofilter require manual action, the only why I could think to do that would be to place a macro in the workbook that would reset the filters in the workbook_Open event. Private Sub Workbook_Open()...

Excel: Excel Autofilter, excel autofilter, pivot table

excel autofilter, pivot table, input box: I m not aware of any way of doing this that is automatically built into Excel - it would be possible to have a macro set the autofilter criteria and store this information in a given cell, which MAY be the way to go. You could record most of this macro, and...

Excel: Excel "Automatic text" check box, xy scatter chart, data labels

xy scatter chart, data labels, chart options: Hi Andy I hope you are well. I would do the following: 1. Type X, Y and label in C5:D5 2. Type x values in B6:B9 3. Type y values in C6:C9 4. type labels for x points in D6:D9 5. Plot the xy scatter chart considering the range B6:C9 6. Select D5:D9...

Excel: Excel: Automatically Search one sheet and populate entire row into another based on customer id, macros vba, cell a2

macros vba, cell a2, vba code: Here s a sample of code that you should be able to customize to do whatever you d like. This code assumes that on the summary sheet, the Customer ID is entered in cell A1. Then it assumes that on the address sheet, the Customer IDs begin in cell A2, and are...

Excel: Excel: Automatically Search one sheet and populate entire row into another based on customer id, macros vba, cell b2

macros vba, cell b2, vba code: You should be able to do this by using the vlookup formula in your summary for. for example, if your summary sheet contained the customer ID in cell B2 and you wanted the customers last name in cell C5, then in c5 you would put in the formula =if(B2= ...

Excel: Excel: How to Autopopulate aftter selection from drop-down menu, microsoft excel, drop down menu

microsoft excel, drop down menu, half hour: Hi, Rachel! I have the perfect example of a workbook like this as a tutorial. It s here: http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm It may take you a half-hour, but you ll understand EXACTLY what to do...

Excel: Excel AutoSave add-in, default settings, latest versions

default settings, latest versions: I m not aware of any way to change this, but thats partly because I m using the latest versions of office - from XP onwards it s NOT an add-in, but part of the standard build! I only have a limited number of PC s available, and have XP, 2003 and 2007 installed...

Excel: Excel Average Gridlines, axis values, continuous curve

axis values, continuous curve, shape objects: Hi Todd, If I understand you correctly, you would like to have Excel automatically mark the average value of a chart data series using a line (or lines if you have a continuous curve and want both the x- and y-axis values marked). There are several ways...

Excel: Excel Average Question, msoffice xp, bottom rows

msoffice xp, bottom rows, row numbers: Hi Randy, I m sorry I don t have enough time to spend on your interesting problem right now. I m going to be offline for a few days but I think I can give you some help that may get you to a solution. The OFFSET function appears to return a value but...

Excel: Excel - How to access Workbook Properties, douglas m smith, vba help

douglas m smith, vba help, informational type: Hi Joe, This information is only accessible through VBA. I ve included the VBA help text for BuiltinDocumentProperties which is how these properties are accessed. There is a short macro at the end that reads the available values and writes them to a worksheet....

Excel: Excel acting up, informational files, excel spreadsheet

informational files, excel spreadsheet, microsoft excel: Hi! Is this occurring in ONLY this workbook? Or in every workbook? If every workbook: http://www.officearticles.com/excel/troubleshooting_microsoft_excel.htm If only this workbook: http://www.officearticles.com/excel/troubleshoot_your_workbook_in_microsoft_excel.htm...

Excel: Excel adding 30 days to date, paste values, string functions

paste values, string functions, yyyy: You have got the right formula, the problem may be that the date is not a date, but a text. There is an easy way to check that, just copy the cell (select the cell, and go menu Edit- Copy), select a cell with no format, and paste values (menu Edit- Paste...

Excel: Excel adding question, left mouse button, cell b2

left mouse button, cell b2, cell c2: Hi Terry, If you type in cell B1 8.00 and in cell B2 8.05 and in cell C1 400 and in cell C2 402.5 then select all four cells B1:C2 and then drag the fill handle down as far as you want to continue the sequence. In case you have not used the fill handle...

Excel: Excel application that will generate the return of investment., risk profile, return of investment

risk profile, return of investment, excel application: Anna Send me your e-mail address (we don t get the address through allexperts) and I ll send you a spreadsheet that I think will answer your question. Once you have checked it out, you can alter it as necessary to look exactly like you want it to. My...

Excel: Excel auto fill colors, army aviation, aviation units

army aviation, aviation units, final risk: You are right, there is not enough information to give a detailed answer, but at least I will try to give some advice. First, linking the behavior of the spreadsheet to clicks on cells will force you to use macros. I hope that you are comfortable with them,...

Excel: Excel auto save of dde transferred data, steam flow, boiler room

steam flow, boiler room: I guess it would just about be possible - you would have to have a macro that copied the worksheets to a new workbook, then saved that workbook and closed it - it could be set to run on the change event of the original workbook - you can record most of this...

Excel: Excel autoassign ID#, address phone number, head of household

address phone number, head of household, vlookup function: yes, I would store the names in a seperate area of the workbook and assign the numbers here, then when you need to reference it use the VLOOKUP function to return the value you need (using the autofilter to filter out the blank records) - once done, you can...

Excel: Excel autofill, cell d5, target address

cell d5, target address, excel autofill: It is easier to make the autofill than detect it. I am not sure if this will work for you, the code uses the worksheet_selectionChange event to detect if the student has selected the cell D5, after that selected the range D5:D10 (that would be the autofill),...

Excel: Excel autofilter, excel autofilter, google searches

excel autofilter, google searches, excel view: That is a though one - As far as I can tell, there are no settings within Excel that let you control the size of that arrow. Even if you zoom in Excel (View- Zoom- 200%), the arrows remain the same size; however, the row numbers get bigger and the blue on...

Excel: Excel autofit question, times new roman font, autofit

times new roman font, autofit, size font: Hector, The following lines of code will expand every row and column in each worksheet of your workbook: Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets With Cells .Font.Name = Times New Roman .Font.Size = .Font.Size...

Excel: Excel automated summing, nike running shoes, hierarchy levels

nike running shoes, hierarchy levels, acceptable solution: Matt, I am sure there is a way to do it. Are there any limitations on using additional columns to do preliminary calculations or as you show with your formula for marking the hierarchy levels of the rows. Is a macro also an acceptable solution? ...

Excel: Excel - automatically linked cells, ms 2000, accounting firm

ms 2000, accounting firm, h7: From Sheet1/A3, if you simply press ctrl/[ (that s ctrl+left bracket), it will take you to Sheet8/H7. The double-click now enters the cell for editing, but you can reinstate the functionality of the double click taking you to Sheet8/H7 by Tools/Options/Edit,...

Excel: Excel automation?, interactive tool, best wishes

interactive tool, best wishes, methodology: Kevin, I m not sure that this can be done outside of using VBA code to make it happen. Using VBA code, you would need to use a userform with a listbox. The code would need to fill the list box, and then with If statements (maybe Case), the code would rebuild...

Excel: Excel Backup File, options window, backup file

options window, backup file, trying to find a way: You would have to do it in the Workbook_BeforeSave event. Something like this: (right-click the Excel LOGO near the file menu, enter this... Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Application.EnableEvents = False...

Excel: Excel Books - From Beginners to Experts, learning excel, hi bob

learning excel, hi bob, expert level: I don t have any expertise on which books are the best books to take you from beginner to expert. I d only suggest you browse the books you see in the bookstores. Re 2003 vs 2007, I d say that most businesses will stay with excel 2003 for quite some time -...

Excel: Excel - Break workbook out into smaller workbooks, column headings, sheet names

column headings, sheet names, store numbers: As I recall, I tested this and it worked. I could be wrong as I answer a lot of question and don t recall specifically. In any event, if you want to send me a sample workbook with representative test data, and include the macro in the workbook, I can test...

Excel: Excel - Broken Spreadsheet, usb pen drive, spredsheet

usb pen drive, spredsheet, microsoft error: The solution often recommended is to download and install a free copy of OpenOffice at http://www.openoffice.org and try to open it with that. That software appears to be fairly robust in opening excel files. If you want to send me a copy, I can...

Excel: Excel background image, image bob, excel sheet

image bob, excel sheet, printed paper: I think your best choice would be to actually have an object in each sheet on a new workbook, print this empty sheet (aside from the objects), then using your data print AGAIN on top of this previous printout -- actually printing twice, as if you re printing...

Excel: Excel with bar code scanner, bar code scanner, upcs

bar code scanner, upcs, dollar value: I have no experience of using a bar scanner with Excel. If the scanned data is stored as numbers then simply start the input at say Row 5 and place SUM & SUBTOTAL formulas in the rows above. You could make this more efficient by creating a Named Range to...

Excel: Excel beginner tutorial, david horner, beginner tutorial

david horner, beginner tutorial, hey buddy: Hey Buddy, These tutorials should be a good start. If you have any specific questions, don t hesitate to ask! http://www.usd.edu/trio/tut/excel/ http://www.bcschools.net/staff/ExcelHelp.htm#Intro http://david.horner.faculty.noctrl.edu/Excel_tutorial/home.html...

Excel: Excel blinking cells, colorindex, cell interior

colorindex, cell interior, sheet tab: Change the worksheet calculate to something like this - I ve listed a random-ish set of cells to test & to blink: Private Sub Worksheet_Calculate() Dim TestCell As String, BlinkCell As String For i = 1 To 6 TestCell = Split( B10/D10/E3/E5/C2/D14...

Excel: Excel button VBa code, basicly, yahoo

basicly, yahoo: Need to know a few things. Are the new sheets named? That is, do you know if January s sheet is named January? Or is the last(right-most) sheet the last month s sheet which needs to be copied? What do you mean by the one column ? And where is the ending...

Excel: Excel button, excel sheet

excel sheet: You can add a button using the Forms Menu and by double clicking on the button you can then assign a macro. You can also use the Controls Toolbox. To use this control you must make sure that you are in Design View by clicking the Design View icon - the...

Excel: Excel: Calculating surplus, home budget, fund categories

home budget, fund categories, monthly budget: Dylan, Assuming that your year starts in January, you can get the multiplier by a simple =MONTH(TODAY()) multiply that by the category amount, and you have your budget to-date. Summing the spend to-date is simple, a straight SUM function, but by category,...

Excel: Excel Calculations, cell b1, cell a1

cell b1, cell a1, eligibility period: It is unclear how many rows have to be considered when looking for overlaps. Just the previous row or every row could be an overlap. Can a macro be used for this rather than formulas? If you want me to work on this, then send me a sample workbook...

Excel: Excel Calculations, cell b1, cell a1

cell b1, cell a1, eligibility period: I am not sure I completely understand. How many rows of data starting in 11 pertain to the dates you entered in A1 and B1? It looks like that the dates entered starting in row 11 all pertain to the dates entered in A1 and B1 but I was not sure. The more...

Excel: Excel Calculations, cell b1, cell a1

cell b1, cell a1, eligibility period: Hello Helen Thank you for a very clear and explicit summary of what you are trying to achieve...I wish they were all like yours :) The thing is Im not a formula man, as my profile says I work exclusively with VBA code. If you wish we can rework your...

Excel: Excel - Calender Control and Data Validation, excel tips tricks, data validation

excel tips tricks, data validation, drop down boxes: Q1: I d write code to restore the size of the calendar control in the Workbook_Open event. You can record the process & move it to the open event. Not sure why this is happening. Q2: I d have to see the code to see what s different. You might look at Selection.Resize(1,1)...

Excel: Excel Case Statement, run time error, blank cell

run time error, blank cell, case statement: Jerry, I would assume that it s a version conflict. At the least you need this part of that line: Selection.Find(What:= , After:=ActiveCell, SearchDirection:=xlNext).Select But you could go through and take out each parameter (between commas) and check...

Excel: Excel - Cell color based on data, background color change, conditional formatting

background color change, conditional formatting, background change: Brian you can do the background color change with conditional formatting. go to toolbar/format/conditional formatting/put in the criteria for the format, such as cell value is equal to A/then cick the format that you want by clicking on format bar, etc,...

Excel: Excel Cell color on conditions, value case, inputbox

value case, inputbox, format menu: LOL!! Always difficult to gauge the level of the of the answer when just reading words on a page - for reference, to get the macro to work press Alt F11 which will take you into the Visual Basic editor - the macro can be pasted as is onto the workbook panel...

Excel: Excel Cell Format Issue, double click, notepad

double click, notepad, yup: Scott: Yup, that happens sometimes when importing external data into Excel (or pasting from another program such as Notepad, etc). There is a quick way to get around the problem: 1) Find an empty cell and type the number 1 into it. 2) Copy that cell...

Excel: Excel / Cell Formatting, douglas m smith, dropdown boxes

douglas m smith, dropdown boxes, case colors: Hi Michael, Sorry about the delay. The bad weather took out my internet connection yesterday. Excel can handle this through Conditional Formatting although there is a limitation of three conditions (in your case colors) that can be used. I wish it...

Excel: Excel - Cell formatting not working for one tab of a excel file, one tabs, format cells

one tabs, format cells, indent: SACHIN Sachin Apparently your cells are formatted as left indent. To change this paint the cells that you want to reformat and go to toolbar/format/cells/alignment/right indent and clic okay. This will reformat the cells to be right indented, or moved...

Excel: Excel Centering, dividing by zero, numerical result

dividing by zero, numerical result, text result: Mike I don t know of a way to do it with a formula. but I d bet that it can be done with a Macro. Unfortunately I m not a Macro expert. ck with some of the other allexperts persons and look for one who is a macro expert. Sorry I couldn t be of more...

Excel: Excel - CHOOSE Function, code column, c25

code column, c25, b2: Not sure if this is what you want. Place the formula in C2 and drag down. =IF(B2= A ,CHOOSE(1, Red , blue , Green ),IF(B2= B ,CHOOSE(2, red , blue , Green ),IF(B2= C ,CHOOSE(3, red , blue , Green ), ))) See the Functions article at www.excel-it.com...

Excel: Excel Chart, jan altman, horizontal bar chart

jan altman, horizontal bar chart, questionnaire survey: I m afraid Jan s faith in me is misplaced on this one - I cannot think of an alternative - or rather, I can think of ONE that might work which is to have a horizontal bar chart - you would need to have an extra first column of data, which is set to be equal...

Excel: Excel Chart, douglas m smith, brainbench

douglas m smith, brainbench, mvp: Hi Scott, You can t plot the Yes cells directly. You will need to have a cell containing the total number of Yes cells divided by the total number of cells in the range. The following formula should handle the task: =COUNTIF($A$1:$A$15, YES )/COUNTA($A$1:$A$15)...

Excel: Excel Chart, chart options, graph

chart options, graph, yahoo: I m assuming you don t want to chart the TEXT, but you want the series labelled, as in a legend. Make sure the column (or row) before the data is included in your selection, and once the chart is shown, you can use Chart/Chart options, and show the legend....

Excel: Excel Chart, chart options, time scale

chart options, time scale, ogilvy: Hello Amanda, There could be several thinks going on here, but I will suggest the one I think will correct it. After the chart is created right click on the chart (in a general area of the chart) and select Chart Options. If that isn t a choice, choose...

Excel: Excel Chart Legend, location pattern, chart legend

location pattern, chart legend, ledgend: You are correct - IF the chart has no header row, then Excel makes up the legend for itself (series 1 etc). HOWEVER, if there IS a heading row/column then the ledgend carries the name from this row - so just retype the name on the actual data sheet and you...

Excel: Excel Chart from VBA array(s), ms applications, sers

ms applications, sers, arrays: Play with this... Sub CreateChart() ASSUMES EMBEDDED CHART Chart 1 EXISTS ON THE SHEET Dim sers As String Dim Arr(1 To 5) As Integer For i = 1 To 5 Arr(i) = i Next For i = 1 To 5 sers = sers & Arr(i) & ; ...

Excel: Excel Chart Wizard, chart wizard, syntax problems

chart wizard, syntax problems, external reference: Well, how did I know that? Try using the formula in a cell by itself and see what happens. If you still get an error then either the formula is still wrong or it can t be done. And since I can not see the formula then there is no way I can tell where any...

Excel: Excel Chart, excel charts, table structure

excel charts, table structure, cells: No easy way (that I m aware of) to accomplish that. I m afraid they re linked. However, I was able to create something interesting that may work for you situation. Instead of turning on the data table option of the chart, I just added a textbox and...

Excel: Excel Charting, joe robertson, work efforts

joe robertson, work efforts, catogory: you need to use a combination chart with 2 axes. INitially you ll have to use line-column on 2 axes, but then change the chart type of the line back to a column. This will make about half the series be on the wrong axis, and you ll have to associate each...

Excel: Excel Charts, phillips company, sandy butler

phillips company, sandy butler, chart wizard: 1 - in step 1 of the chart wizard, click on Custom Types tab 2 - select Line-Column on 2 Axes 3 - click finish. This will only work easily if the first 2 columns represent the sales and the last 2 columns are the percentages. If you have sales/%/Sales/%,...

Excel: Excel Charts, excel charts, font sizes

excel charts, font sizes, word documents: I used to spend days in a previous job fighting with embedded charts which consistently failed to behave, and I was never able to find a satisfactory way of fixing it - so although there MAY be an answer I m afraid I don t know it - sorry! I would suggest...

Excel: Excel Charts, column chart, excel charts

column chart, excel charts, different colors: Much easier to show you than explain -- please send a sample wb to me at bobumlas@yahoo.com, I can give the steps to do what you want. (And methinks you re calling a column chart a bar chart, since you said side-by-side, but when I see your data I ll know)....

Excel: Excel Charts, chart wizard, election data

chart wizard, election data, presidential elections: Jean, I think you have your data weird, perhaps? I would have TWO columns: 2000, 2004. Then I d have rows. If you do that, it should do just what you re asking, no? Make sure you include your headings when you use the chart wizard (no blanks, please). If you...

Excel: Excel Charts - grayscale, chart wizard, default colors

chart wizard, default colors, color palette: Rosa: There are a couple of options available: 1) When you create a new chart via the chart wizard, select the Custom Type tab. You will notice several charts here that are called B&W XXXX. They have default colors and textures that are better for...

Excel: Excel Charts, data labels, legend text

data labels, legend text, excel charts: With the chart selected, run this macro: Sub LabelSeries() n = ActiveChart.SeriesCollection(1).Points.Count For Each ser In ActiveChart.SeriesCollection ser.Points(n).ApplyDataLabels AutoText:=True, ShowSeriesName:=True Next End...

Excel: Excel Check Box counting, countif, boxes

countif, boxes, cells: Are your check boxes from the Forms Toolbar? If so, if you right click on them and select Format Control you can assign a linked cell. Do this with them all assigning the link for each to the same column which can be hidden. A simple Countif formula can then...

Excel: Excel Check Box, checkbox control, check boxes

checkbox control, check boxes, option buttons: You will need to use the other radio button from the Control toolbox. These give you much more control and have more flexibility also. Display the properties for each radio button in the first group or set of radio buttons and type the same Group Name...

Excel: Excel CheckBoxes, john shellenberger, target cell

john shellenberger, target cell, control toolbox: John, I think that you may be misunderstanding the checkbox. If you embed a checkbox in Excel using the Control Toolbox toolbar, you need to use code to keep it as clean as possible. For example, if you have a checkbox that needs to function like you state...

Excel: Excel Checkbox Captions, check boxes, vba programming

check boxes, vba programming, properties menu: Rob The validatin option will be better for you I think. The validation option will only allow you to input either A or B and can be found in the data menu (if my memory serves correctly, I haven t used 97 in a while). The macro may be the difficult part...

Excel: Excel Checkbox Processing, check boxes, excel checkbox

check boxes, excel checkbox, checkboxes: What do you mean by processing all of the checkboxes ? And where are the checkboxes (on a worksheet or on a userform) and if on a worksheet then how did you put the checkboxes on the sheet? There are two ways. Remember, I can not see what you see and...

Excel: Excel: Circumventing the IF nesting limit., excel user, banging my head

excel user, banging my head, formulae: =HLOOKUP(A3,I$20:AE$58,MATCH(B3,I28:I58,0)+1) This MATCH() function returns 1 if B3=I28, 2 if B3=I29, 3 if B3=I30, etc etc. Also, look into the CHOOSE() function, which isn t needed in this particular task, but is sometimes useful for situations where...

Excel: Excel: Clearing Validation Boxes on Form, basic fortran, visual basic menu

basic fortran, visual basic menu, data validation: Hi Stephen, If you want to clear the selections from the In-cell Drop-down Validations you can use ClearContents like this for a single range. Sub ClearRange() Range( A1 ).ClearContents End Sub More than likely you have multiple non-contiguous ranges...

Excel: Excel Clipboard, paste operations, software questions

paste operations, software questions, onlinehome: Hi, Carl. I hate the Office clipboard as well. And I get rid of it for good... Please ALWAYS provide the version when asking software questions. In this case, it DOES seem to matter. I hate sending you to a PDF file, but this has ALL versions: http://s134084144.onlinehome.us/gilsmethod/pdfs/HT0005.pdf...

Excel: Excel's CORREL formula, correlation coefficient, math terms

correlation coefficient, math terms, correl: I am not sure if this will help, this is the wikipedia page for what the correlation is: http://en.wikipedia.org/wiki/Correlation It is explained in math terms, I don t know if you are familiar with it. I don t have too much experience with math, but...

Excel: Excel - COUNTIF, excel countif, blank cells

excel countif, blank cells, empty cells: Are you looking for the word any in any cell or just any cell that has text regardless of what that text is? If the latter then simply use the COUNTA function. Other related and perhaps useful functions in this case are COUNTBLANK, which will count all...

Excel: Excel Color Import, color palette, custom colors

color palette, custom colors, color tab: Hi, Steven, Excel s color palette is fixed at 56 colors. But you can modify the palette to be any 56 colors you like. Here s how you can modify the existing palette. (These are the steps for Excel 2003; it may vary slightly on your version.) 1) On...

Excel: Excel Column Limitation, excel worksheet, warm regards

excel worksheet, warm regards, oppurtunity: Dear Mark Huffman, This option is available in 2007 Version. A free download of its beta version is available in microsoft.com. Download and try. If you are specific with your question, please feel free to mail me at dc.sureshsmart@gmail.com. Thanks...

Excel: Excel Columns, james evans, many thanks

james evans, many thanks, a1: Sub reverseSort() Dim rngToSort As Range, rngSortBy As Range, cl As Range Set rngToSort = Range( a1 ) Set rngToSort = Range(rngToSort, rngToSort.End(xlDown)) For Each cl In rngToSort.Offset(0, 1).Cells cl.Value = cl.Row Next...

Excel: Excel Combination 2.0, excel vba macros, game clue

excel vba macros, game clue, time thing: It is easy to do with a macro. Harder to do with formulas. Will the number of items in each category remain constant or do you want some generalized approach (or is this a one time thing). In any event, send me a sample workbook with the data and the...

Excel: Excel Combo Box cascadeing slection, excel combo box, source cells

excel combo box, source cells, choice index: I may be not understanding what you really want, but based on what you said, you can simply have the 2nd sheet s cell reference the dropdown combo box s source. So, for example, if the combobox s source cells are J1:J10, and there s a cell link in J11, then...

Excel: Excel Combo Box, excel combo box, two different ways

excel combo box, two different ways, combobox: There are two different ways a combobox can be put on a worksheet, assuming you are referring to a combobox on a worksheet and not on a userform (a third way). Since you did not say then I can t answer. Remember, I can not see what you see and ALL and...

Excel: Excel Combobox, data validation, source field

data validation, source field, excel combobox: I don t really understand your setup. What list is your combo box based on? -a named Range of a list of names somewhere in your workbook? or -did you type the names as values into the Source field of the Data Validation window ?? Secondly, what do...

Excel: Excel Combobox, control toolbox, email provider

control toolbox, email provider, combo box: If a form means a userform, then you need to use controls from the control toolbox toolbar. I assume you know how to drag a control from the toolbar to the userform and position it, then double click it to get to the event code. You would need to use the...

Excel: Excel Command Button, clock values, microsoft query

clock values, microsoft query, ms query: Mike, 1) Assign this macro to a button on the PT sheet. You may have to modify if the PT is named anything other than PivotTable1 . Turning on the macro recorder and clicking Data Refresh Data will produce a similar macro. Sub Macro1() ActiveSheet.PivotTables(...

Excel: Excel Command button macro, keyboard shortcut, answer mark

keyboard shortcut, answer mark, command button: Mark, Maybe we could use the actual list itself, the one in A6 down. Will there be any data in A1:A5? And when there are additions, will you slot them at the end, or in the position that you would want them to occupy within the current order? Bo...

Excel: Excel Command, cell c5, cell b5

cell c5, cell b5, goto tools: Hi, it a little bit complex but doable. you need to use a circular formula assumptions 1. Cell C5 has the random number via using RAND() 2. you have a free cell B5 that I can use for a formula step 1. Goto Tools - Options - Calculations step...

Excel: Excel Comments, excel sheet, cmt

excel sheet, cmt, ash: Need a macro to do it. Try this: Sub GatherComments() On Error Resume Next Application.DisplayAlerts = False Sheets( Comments ).Delete Set ash = ActiveSheet Set newguy = Worksheets.Add newguy.Name = Comments ash.Activate...

Excel: Excel Compare Compare - Like Values, vb script, data sheet

vb script, data sheet, a1: If the only condition is that the value on column A is the same, you can change this line: If Application.WorksheetFunction.CountIf(Sheets( Sheet1 ).Range( A:A ), cell) = 0 to this line If Application.WorksheetFunction.CountIf(Sheets( Sheet1 ).Range( A:A...

Excel: Excel Conditional Formatting, dd mm yy, excel conditional formatting

dd mm yy, excel conditional formatting, analysis toolpak: Name is from the Irish diminutive of the word FIRE, so I always say that makes me a firelet, firekin, or a bright spark! You can find out more about me at www.aidanheritage.co.uk. However, onto your question, which makes perfect sense! Not sure how accurate...

Excel: Excel - Conditional Formatting Using Formulas, cell d1, current value

cell d1, current value, b1: This can be done with the conditional formatting feature of Excel. Select the cell you want to have the conditional formatting and choose format- conditional formatting. From there you can specify to format the cell on two basic conditions: 1) The current...

Excel: Excel Conditional Formatting, excel conditional formatting, expiration date

excel conditional formatting, expiration date, spreadsheet: Adan You can use conditional formatting to accomplish what you want. Go to toolbar/format/conditional formatting In the conditional formatting window--in the first box choose cell value is ---in the second box choose less than---in the third box put in...

Excel: Excel Conditional formatting, conditional formatting, macro security

conditional formatting, macro security, colorindex: Hi Bob How are you? Please, try 1. type apples in B2 2. type the formula in C2 =IF(AND(B2= other ,F2= ), Insert in col F the same row the Customer , ) or you can use the following VBA program 1. Tools - Macro - security - security level...

Excel: Excel Conditional, conditional formatting, cell a1

conditional formatting, cell a1, cells: IF you are referring to Conditional Formatting when you say ...would like to be able to set up a conditional ... then that feature will not perform an action - it only changes the appearances of cells (basically). You will need a macro to do what you...

Excel: Excel - Consolidating portions of a list, source sheet, blank areas

source sheet, blank areas, sheet tab: Hi Steve, You could try this -- The pivot table can include the blank areas of your data. However, once your pivot table is created, you can hide (turn off the display) of the blank objects in the pivot table. Choose from the row/column/page drop downs...

Excel: Excel Consultant Needed, adjunct faculty, excel user

adjunct faculty, excel user, excel expert: It s a possibility. I m not sure I m the expert for beginners(!) -- I usually handle intermediate to advanced. But I d certainly be willing to talk with you. Currently I m pretty busy with the excel user conference coming up (you attending?) -- http://www.exceluserconference.com...

Excel: Excel Copy Data, cell a2, initial range

cell a2, initial range, speedy answer: Hi May, How are you? By pressing the 3 keys (ctrl +Shift+Enter) you indicate that the function Transpose produces an array of results (not just one result). That is also why you have to select some cells for the array to be outputted. Cheers Adelaide...

Excel: Excel Copy and Paste Function, cell a2, destination cell

cell a2, destination cell, circular references: You are right, that sounded a little cryptic. What I meant with make the formula for today was entering today s date on cell AA1, and the formula in AA2. To test if that works, change the cell AA1 to yesterday, and the value on A2 to something different...

Excel: Excel Copy Range based on Criteria, survey answers, summary tables

survey answers, summary tables, data entry: Sub Copy_A_B() Dim rngDatabase As Range Set rngDatabase = Sheets( Sheet1 ).Range( a1 ) rngDatabase.CurrentRegion.AutoFilter Field:=1, _ Criteria1:= A rngDatabase.CurrentRegion.Copy Sheets( CompanyA ).Paste Sheets( CompanyA...

Excel: Excel Copy, formulae, menu options

formulae, menu options: i suspect that somehow Calculation is set to Manual. Check from the Tools Menu Options Calculation Tab and see if Automatic is checked. If not select Automatic & click OK. You may have run code that has switched it off and failed to return it to Automati...

Excel: Excel Count if two conditions are met, excel count, array formula

excel count, array formula, c120: Nik, I can interpret your request in two ways. 1. You want to know the total number of instances that there are nonblank cells in C2:C120. You want to add to that result the total number of instances that the word COMPLETE appears in J2:J120. If...

Excel: Excel Count formula, excel count, exact requirements

excel count, exact requirements, warm regards: Dear Sachin, Unfortunately, AND function will not work (as per my trials) with COUNTIF. My suggstion is- In additional column use ROUNDDOWN(An) so that numbers round to lower number. So 14.05 becomes 14, 14.7 becomes 14 etc. This means all numbers between...

Excel: Excel Count formula, excel count, array formula

excel count, array formula, value error: The formula as written, based on the information you gave me DOES work - I always test before posting a slightly more complex than normal formula - if you can email me your file (aidan.heritage@virgin.net) I can try to debug it for you - oddly whatever I ve...

Excel: Excel Count Query, excel count, fee payments

excel count, fee payments, alternative solution: Will there always be the same number of rows associated with a Composite Fee? If not, can an auxiliary column be used to make the count. Does the count have to update dynamically - does it have to be a formula. If so, can it be a custom function written...

Excel: Excel Count Query, array formula, excel count

array formula, excel count, fee payments: James: I m not 100% sure I understand the question, so I have provided a spreadsheet with 2 different formulas in it. I hope one of them is the solution you were looking for. http://home.swbell.net/nate-sus/excel/uniquefees.xls NOTE: The second...

Excel: Excel Crashes When Scenario Created, www google co uk, google search

www google co uk, google search, scenario name: A google search reveals you are not alone, but a search in the knowledge base at http://support.microsoft.com reveals nothing - I m GUESSING it s an undocumented bug within Excel, but cannot confirm this - for reference my google search s URL is http://www.google.co.uk/search?hl=en&rls=RNWE%2CRNWE%3A2005-46%2CRNWE%3Aen&q=EventType+%3A+BEX+excel+2003+scenario&btnG=Search&meta...

Excel: Excel Crashes When Scenario Created, scenario name, excel spreadsheet

scenario name, excel spreadsheet, excel 2000: When Excel crashes like this, it could be a corrupted file - I d suggest you create a new file and instead of copying sheets, copy cells from each sheet (all the cells at once) to the new workbook. Then try again. Outside of this suggestion, I might try opening...

Excel: Excel: Cross Folder Links, cell a1, relative reference

cell a1, relative reference, folder structure: If I understand your question correctly, I d have to say that I don t think you can do this. If you change the location of a source file, you need to manually update it in your formulas. I wouldn t be surprised if there is actually a solution to this problem,...

Excel: Excel Currency Formula problems, format cells, custom category

format cells, custom category, pound sign: Format the result. Select the cell, use Format/Cells, click the Number tab, select Custom category, then enter £ General To get the £ symbol, press & hold the Alt key while typing 0163 from the numeric keypad, then let go (obviously it also works in this...

Excel: Excel Custome Views, work sheets, custome

work sheets, custome, naming convention: Hi Mary, Are you familiar with macros? This one should be fairly simple and a good way to get your feet wet. You can create a macro that is essentially just copying your process and keeping it recorded. Then when you move to the next worksheet, you...

Excel: Excel Customization, master template, excel worksheet

master template, excel worksheet, startup folder: Michelle, You said you have a template. Is it saved as an .xla file? In Excel, an .xla file is the same as a .dot template file in Word. Once you have saved your master template as an .xla file using the Save As feature, you then have to install the...

Excel: How to get Excel to calculate a more accurate date, critical entry, time span

critical entry, time span, weekends and holidays: Dan The network days is correct in the above formula, it is 4 days. The reason for this is that each day is counted by excel whether the day is 1 minute before midnight or 1 minute after midnight. The only other way is to use the Entire Process formula...

Excel: Excel cell color, light colors, notebook pc

light colors, notebook pc, notebook computer: Hello Don, Doesn t sound like an Excel-related problem to me. Sometimes the liquid crystal monitor display properties have to be adjusted on notebooks to get the colors to show up. The very light colors sometimes don t seem to appear for instance. ...

Excel: Excel cell color, knowledge base article, accessibility options

knowledge base article, accessibility options, color combinations: There is a knowledge base article about this at http://suppport.microsoft.com - the text is Changes to the fill color and the fill pattern are not displayed in Office programs View products that this article applies to. Article ID : 320531 Last Review...

Excel: Excel cell format, cell reference, digit numbers

cell reference, digit numbers, separator: I have a slight problem, in that I m in the UK so I m not familiar with ZIP codes - however, taking your explanation and working with that you should be able to do it via a blank column (which you can then copy and paste special - values over the original...

Excel: Excel changing cell colours, excel sheet, ogilvy

excel sheet, ogilvy, guru: Unprotect and protect it in your code: Activesheet.Unprotect Password:= ABC Range( G9 ).Select Selection.Locked = False With Selection.Interior .colorIndex = 0 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End With Activesheet.Protect...

Excel: Excel changing the tab names and file names, trial balance, thanks john

trial balance, thanks john, xls: John How do you send the files to your home? If it is in a link make sure you are attaching the files and not typing in the link into the document. The Group also indicates that Excel thinks it is networked to your pc. If the file isn t private...

Excel: Excel chart equation, horizontal cells, linest

horizontal cells, linest, range names: Meghan Well I have to say I don t work with trendlines but you may find the following to be helpful. You might also ask another expert who has experience with this function, try either bob ulmas or aidan heritage In general, here is one way... Select...

Excel: Excel chart to track kids walking to points of interest, vlookup formula, list of names

vlookup formula, list of names, fire station: This can be done a variety of ways; some more complicated than others. For our first shot I ll try a nested IF statement: =IF(AE2 =50, Country Hilltop ,IF(AE2 =40, The Zoo ,IF(AE2 =30, Lake Spot ,IF(AE2 =20, Children s Museum ,IF(AE2 =10, Fire Station...

Excel: Excel chart, tab place, bar graph

tab place, bar graph, excel charts: Simon: You may color each bar individually in Excel by following one of these options: Option #1) Right-click on a bar and choose format data series . On the patterns tab you can change the bar color for all bars in the series. Option #2) The above...

Excel: Excel charting, john peltier, google search

john peltier, google search, edward tufte: http://www.strategiccomm.com/usecharts.html There is one person who I have heard several times and the Guru of using charts effectively. Unfortunately, I don t know his name. I think it is this guy: I believe Edward Tufte has several books on Charts...

Excel: Excel charting, numeric labels, chart wizard

numeric labels, chart wizard, garnishment: Jocelyn, I don t believe there is an easy answer to that. I would think it is understanding your data although, when lazy, I do the same as you. that is so simple, I am not sure why you are concerned. I also go back to the series tab and modify the data...

Excel: Excel charts, secondary axis, column chart

secondary axis, column chart, excel charts: Richard My thought is that all is better than it seems. If you right click the chart and choose Source Data, both series should be listed. Make sure that the scale for both of them is appropriate, and alter the Chart Type as needed. You can right click...

Excel: Excel charts, excel charts, office xp

excel charts, office xp, microsoft office: You cannot do it by taking the information from the sheets alone, BUT you COULD create a data table that picked up the values and use that to create your chart (by data table, I simply mean a block of cells that references the values you want - eg =sheet2!a...

Excel: Excel charts, column graph, excel charts

column graph, excel charts, provisional data: Chris Chris Have a look at this link for combining two charts http://peltiertech.com/Excel/Charts/AlignCharts.html or this one http://www.peltiertech.com/Excel/Charts/ComboCharts.html or the combined charts in excel which aren t that diverse....

Excel: Excel charts, excel charts, info charts

excel charts, info charts, column types: The best sources of useful information for charts are at http://processtrends.com/ http://peltiertech.com/Excel/Charts/index.html http://www.andypope.info/charts.htm http://www.stfx.ca/people/bliengme/ExcelTips.htm http://tushar-mehta.com/excel/charts/...

Excel: Excel charts, column types, excel 2000

column types, excel 2000, graph: I cannot see the example, and I use 2003, but you may try the following: In a graph with two series on bars, select one of the series, right click and in the emergent menu select chart type. Here you can select a different chart type and it will be applied...

Excel: Excel charts, john peltier, column chart

john peltier, column chart, column types: Hello Chris, I don t know what . . . like this; refers to, but if you create a stacked column chart, then after it is created, select the series you want as a single column chart, right click on it and select format series, in the axis tab, choose secondary....

Excel: Excel charts, column types, excel 2000

column types, excel 2000: No chart appeared, assuming you tried to paste something here. You really can t combine two charts per se but you can make EXCEL appear that it has been done. Create both charts and set the chart area to be no color for both. Then simply move one over...

Excel: Excel charts, data columns, excel charts

data columns, excel charts, sheet1: I m not familiar with the functions SERIES or SOLID, so I m a bit stumped (especially as I cannot find them referenced in my help file!) There almost certainly is a way round the problem, but I m not sure what it would be. If you want to mail me a file to...

Excel: Excel and charts., range f1, degree polynomial

range f1, degree polynomial, empty cells: fitting is done for one series, so F1:F100, or G1:G100 -- not sure what you re looking for for F1:G100. Assuming, for example, you want the numbers to best fit a 7th degree polynomial for numbers in F1:F50, say, you first need to select a parallel (empty)...

Excel: Excel - checking time and date entries, generic version, time and date

generic version, time and date, time of day: I would use the validation you already have, but modify it to display an alert (the next tab) and PROBABLY to dissallow times outside the range - if you need specific help with this, can you email me a sample file and I then can then give you the formulas...

Excel: Excel for children, question thanks, library thinkquest

question thanks, library thinkquest, classroom activities: Hi Aideen, Here are a couple of websites that I think may be helpful for you: http://www.forsyth.k12.ga.us/kadkins/abc.htm http://www.forsyth.k12.ga.us/kadkins/spreadsheet.htm http://library.thinkquest.org/J0110054/Classroom_Activities.html?tqskip1=1...

Excel: Excel circular formulas, circular reference, circular references

circular reference, circular references, formula calculations: Hi Nancy, This message is Excel s way of warning you that you have a circular reference . A circular reference means that you have a formula that depends on the value that the formula itself yields. The simplest example of a circular reference would be...

Excel: Excel code protection, networked location, excel code

networked location, excel code, excel 97: Doesn t SOUND like anything fundamentally wrong, although this problem does exist with files shared on networks - for no apparent reason they start being saved like this. Solution is to saveAS to a non networked location, then copy that file over the corrupted...

Excel: Excel colum search., autofilter, column c

autofilter, column c, colum: in C2 put in the formula =if(countif(A:A,B2) 0, Copy , Leave ) then drag fill down the column. Select column C and do Data= Filter= Autofilter and in the resulting dropdown, select Copy . Select column B again and do Edit= copy, go to the new location...

Excel: Excel column matching, exact layout, team mates

exact layout, team mates, web environment: Sadie for #2 you will need to upgrade to Office 2007 and Windows live which will enable you to do what you want. That is the only way I know of having live changes through multiple users. for #1 I would need to know the exact layout, is it possible...

Excel: Excel combinations, brainbench, increments

brainbench, increments, combinations: Drew, You are right in noting that 1296 is 36x36. The right character is divided by 36^0 so that it increments on every row. The middle character is divided by 36^1 so that it increments every 36 rows and the left character is divided by 36^2 so that it...

Excel: Excel combo Box, excel combo box, data validation

excel combo box, data validation, dropdown menu: Hi venkatesan, I m not quite sure what you mean when you refer to a combo box (is this the same thing as a dropdown menu). My suggestions would be to format the cell where the combo box is, or to format the validation list. If I am way off on the definition...

Excel: Excel combo box, excel combo box, spreadsheet cells

excel combo box, spreadsheet cells, input range: Glen, You can do this using VBA. In my sample sheet, I have a list of data from C2 to C20. I insert a combo box from the forms menu ( View Toolbars Forms) in the vicinity of cell E2. I right click on the combo box and select Format Control. I give...

Excel: Excel from the command line, macro in excel, excel macro

macro in excel, excel macro, google: 1. That depends on WHAT program you are referring to. You can have an auto-executing_ macro in EXCEL that will run itself when you open that EXCEL file. So, if the program in question can launch EXCEL then yes. 2. GOOGLE for Workbook_Open event and...

Excel: Excel from the command line, myfolder, file excel

myfolder, file excel, excel exe: Mihai, the is a workbook_open event that will fire when a workbook is opened. You would need to put code in there to perform the actions you require. http://www.cpearson.com/excel/Events.aspx Describes what events are available to you. So you...

Excel: Excel if command, cell b2, search portion

cell b2, search portion, cell c2: Hi David, Here is another approach if you have some cells that may contain buy as part of the cell, like strong buy Here is your formula (to be placed in cell C2) assuming strong buy is in cell B2 and D@ contains the value to change: =IF(ISNUMBER(SEARCH(...

Excel: Excel comments, pivot tables, menu tools

pivot tables, menu tools, comments section: I am not able to replicate the error, and I don t know what may cause it, but in fact I rarely show the comments in the spreadsheet. You may try to hide the comments and show only the indicator (from menu Tools- Options- View Tab- Comments section- Comment...

Excel: Excel- compare multiple files.., vlookup, missing records

vlookup, missing records, multiple files: It doesn t quite make sense to me I m afraid no - you can compare cell with cell by using =a1=b1 which would give true or false (and obviously could be extended to compare different cells in different workbooks). You can compare using vlookup which...

Excel: Excel computing, stupid thanks, circular references

stupid thanks, circular references, number combination: Hector, The question seems simple but the answer is much more complicated than I expected at first but here goes. 1. The first thing to realize here is that you need to use circular references as you want to dynamically change the numbers till the average...

Excel: Excel - concantenate, douglas m smith, double arrows

douglas m smith, double arrows, parents names: Hi, The command you want instead of Paste is Paste Special , located on the Edit menu. It might not be initially visible on the menu but there are several ways to make it show up: Click on the Edit menu and wait several seconds for all the menu items...

Excel: Excel conditional formating, conditional formatting, formating

conditional formatting, formating, b1: Hi benil How are you? Please do the following 1. select A1:A10 2. Format / Conditional formatting 3. Select Formula is on the leftmost text box 4. Type A1 B1 on the right text box 5. Press Format and choose the format you want 6. Ok Cheers Adelaid...

Excel: Excel conditional formatting, blank cells, t zero

blank cells, t zero, dmax: If you look at the conditional formatting on the original, you will note there are TWO equals signs, as you are comparing two statements - so =small($c$5:$h$10,countif($c$5:$h$10,0)+1)=c5 would compare C5 agains the smallest value not equal to zero,...

Excel: Excel conditional formatting, excel conditional formatting, dependent cells

excel conditional formatting, dependent cells, menu point: As far as I know you are not going to be able to do this, not with conditional formatting at any rate. I would SUGGEST that the best way to do what you want is:- Display the relationships between formulas and cells You can display both precedent cells...

Excel: Excel consolidation of 26 worksheets, correct formulas, c7

correct formulas, c7, attaching files: It s much easier than you think - you probably know that you can do =sum(c1:c7) to add all cells in c1:c7 on the current worksheet - but you probably DIDN T know that you can do =SUM( Pay Period 1:Pay Period 21 !C7) to add ALL the C7s on all the sheets...

Excel: Excel consolidation of 26 worksheets, correct formulas, c7

correct formulas, c7, attaching files: Lisa Tha answwer is easier than you might think. Yes when you copy the template formula over to another workbook it will reference the origninal workbook. To eliminate this turn the formula in the template workbook into text by deleting the = sign in...

Excel: Excel: convert to binary code, excel spreadsheets, macros

excel spreadsheets, macros, suspicion: Sorry, question doesn t make sense as written - password protect the workbook so it cannot be opened without a password? Create an archive using a password? Hide the macros (with password)? Protect the worksheet such that only areas they are supposed to...

Excel: Excel - convert date to Text, pivot table, yahoo

pivot table, yahoo: Again, I think I need more details - how is it showing up? How did you copy the year over? You can t insert a column into a pivot table. If you re copying the number 2007 into a date-formatted column, are you seeing something like 6/29/1905? If so, all you...

Excel: In Excel, convert names to email addresses from Outlook?, global address book, csv file

global address book, csv file, excel user: My expertise is in Excel, not outlook, but to the best of my knowledge, you can export the address book in Outlook as a CSV file, then you could open it in Excel and delete information you don t want. Outlook can also be manipulated with VBA code using...

Excel: Excel copy formulas/Links/Fill, cell a2 type, cell b3

cell a2 type, cell b3, cell b2: For that I would use an additional column, and change the ROW() part to a reference to that column. For example, we want the range starting at row 7 of sheet1, and going for other 20 odd rows. On sheet2, we can fill the cell B2 with the number 7, and cell...

Excel: Excel copy mass data, copy mode, mass data

copy mode, mass data, menu bar: Hello, May, Follow these steps to change the orientation of ( transpose ) data in Excel: 1) Select the cells to be transposed. 2) Copy them to the clipboard. 3) Click in a different location. (You can t transpose to the same location.) 4) On...

Excel: Excel copy mass data, cell b1, cell a2

cell b1, cell a2, index function: It may be easier to send me a sample file so that I can explain it to you with actual data (my email is aidan.heritage@virgin.net) BUT possible solutions are (1) to use a pivot table to generate the values- this table would need refreshing to reflect the...

Excel: Excel copy mass data, mass data, ogilvy

mass data, ogilvy, previous question: If I understand what you want to do, in your example you change B1 to 15, then you would want A3 to change to 15 as well. If this is correct, then this really isn t supported with copy and paste. You can t both paste as Link and transpose. What you could...

Excel: Excel copy mass data, cell a2, horizontal cells

cell a2, horizontal cells, vertical data: If your horizontal is A1:D1 on sheet1, enter this on sheet2, A1: Sheet1!r1c1 (no = ) use the fill handle down to A4, so A4 would have Sheet1!r1c4 (no = ) Now use tools/options/General tab, and select R1C1 checkbox Now select A1:A4 and use edit/replace,...

Excel: Excel copy mass data, mass data, special feature

mass data, special feature, paint: May To go from horizontal to vertical or vice versa you can use the paste special feature. Paint the area you want to copy, Go to toolbar/edit and clic copy then highlight the cell you want the data to begin copying to then go to toolbar/edit and...

Excel: Excel copy1 paste10, cell b10, simple solution

cell b10, simple solution, a1: Not sure I understand. Why not have this in B: =A1 =A1 =A1 (ten times all the way to cell B10) =A2 =A2 =A2 (ten times, you re now in cell B20 =A3 (ten times down to cell B30) Now select the 30 sells and copy them down. They *should* repeat, tho...

Excel: Excel-copying formulas and conditional formatting, conditional formatting, cell references

conditional formatting, cell references, c4: Raj 1 You can lock the cell references you want by placing a $ sign in them ie your formula =B6+C4 becomes =B6+$C4$ will lock the c4 reference. 2 Remove the $ sign from the conditional formatting and it will move down as requested when you copy and paste...

Excel: Excel corruption error, pc memory, rare cases

pc memory, rare cases, memory stick: In rare cases it happens. I faced similar problems long back. I think it is better to backup your data on that file. Do not copy the entire sheet. do not move sheets from one workbook to another. Simply copy the content(only used nothing more than...

Excel: Excel coumn header changed, douglas m smith, letter column

douglas m smith, letter column, brainbench: Hi Les, That s a tough one to find if you don t know about it. Select Options from the Tools menu and click on the General tab. Uncheck the R1C1 reference style option and click OK. The numbers will change back to letters. Douglas M. Smith ...

Excel: Excel counter, share folder, server share

share folder, server share, server server: I would do it in a slightly different way. If you want the book to be read only then it is complicated to write something on the book and saving it, so it may be more effective to write something outside of the book everytime the book is opened, preferabily...

Excel: Excel counter, range f1, number thanks

range f1, number thanks, thanks for your help: Something like this can work (The A s are arbitrary -- you can keep them or give them some other more meaningful characters). Right-click the Excel LOGO near the file menu, select View Code, enter this: Private Sub Workbook_Open() newnumber = GetSetting(...

Excel: Excel countif function, excel countif function, b1

excel countif function, b1, databases: Yes, the COUNTIF can be used for this. For a basic Yes/No flag, you can use something like: =IF(COUNTIF(A:A,B1), Yes , No ) If you just want the number of times the number appear, you don t need the IF part: =COUNTIF(A:A,B1) If you use the conditional,...

Excel: Excel-create a hyperlink to network, xls extension, c drive

xls extension, c drive, excel workbook: That s because the file named specifically # 5078763 does not exist in that folder or the folder does not exist. Is # 5078763 an EXCEL file or a WORD doc or what? If # 5078763 is an EXCEL file then you need to add the .xls extension to the formula: =HYPERLINK(...

Excel: Excel, creating drop down menus, creating drop down menus, drop down menus

creating drop down menus, drop down menus, info thanks: Yes EXCEL will do what you want. You don t say where your original drop down is and/or how you put it there. Again, you don t give me enough info to give you a useful answer. Remember, I can not see what you see and ALL I know about your project is ONLY...

Excel: Excel customized settings file(s), pip files, asap utilities

pip files, asap utilities, documents and settings: I m sorry about the delay, Joe. A business conference kept me away a little longer than I expected. First of all, you should know that I m not using XP. But even if our machines are different from each other, I m sure that this information will help you...

Excel: Excel customized settings file, knowledge base articles, asap utilities

knowledge base articles, asap utilities, outlook problem: I m afraid I cannot find this information in the knowledge base, and haven t yet installed Office 2003 on my computers! HOWEVER, it MAY be worth your while taking a look at http://support.microsoft.com/search/default.aspx?spid=2520&query=cannot+send+attachments&catalog=LCID%3D2057&pwt=false&title=false&kt=ALL&mdt=0&comm=1&ast=1&ast=2&ast=3&mode=a&x=17&y=12...

Excel: Excel Dashboards, excel dashboards, real option

excel dashboards, real option, free templates: Gautum See if ths link helps http://blogs.msdn.com/teams_wit_tools/archive/2007/09/06/Dashboard-Creator-_2D00_-Part-I.aspx http://users.skynet.be/dashboard/envind/manual.htm The only other real option is to go for one of the downloadable pdf books...

Excel: Excel Data Entry, kb id, free forum

kb id, free forum, data entry: This should get you on your way, Christopher. You ll likely need to alter it a bit, so you might want to join that free forum and ask there how to alter it. :) http://vbaexpress.com/kb/getarticle.php?kb_id=546 I don t do VBA myself. I created that site...

Excel: Excel Data Entry, digits number, cell a1

digits number, cell a1, 6 digits: There is no easy way to acomplish the task, because Excel will understand any number that you introduce as a number. Formating as a date won t help, because it will expect the / or - symbols to be entered. One solution can be using an additional cell with...

Excel: Excel Data Sampling, data sampling, time column

data sampling, time column, milliseconds: Since you want ~1/3 of your records, enter this in an unused column, row 2 (say it s col H): In H2 enter =RAND() .333333333 (leave H1 blank) You will see FALSE or TRUE. Select your 9000 rows of data (or click one cell in your data) and use Data/Filter/Advanced...

Excel: Excel Data Sorting, microsoft office 2000, using microsoft office 2000

microsoft office 2000, using microsoft office 2000, using microsoft office: The size being referred to is misleading - it s not the row height, column width etc - it s the fact that some cells are merged and some aren t - so select all the data, then format the cells and keep clicking the merge cells checkbox until it is unchecked...

Excel: Excel Data, vlookup, data query

vlookup, data query, e8: Hi Dan How are you? Please do the folowing 1. Type your data in, e.g., A1:C10 2. Sort the data ascendingly by the first column 3. Type in D8 apple in E8 =VLOOKUP($D$8,A1:$C$10,2,0) in F8 =VLOOKUP($D$8,A1:$C$10,3,0) Copy down E8:F8 till you...

Excel: Excel Database Searching with VBA, rcl, number 1

rcl, number 1, cells: Use he VBA Find function. Place this code in a Standard Module - see where to place the code here http://www.excel-it.com/Forum/viewtopic.php?t=11 Option Explicit Sub findData() Dim rData As Range Dim rCl As Range Dim sFind As...

Excel: Excel Database's, dave yates, getsetting

dave yates, getsetting, time ie: In order to send you a file I need your email address. This sub will ask if you want the # updated. Private Sub Workbook_Open() assumes the quote # is in cell D3 - change accordingly Dim NewNumb As Integer NewNumb = GetSetting( Yates , Yates...

Excel: Excel Database scripting, address phone number, cell index

address phone number, cell index, sheet1: If sheet2 has the name from column A in its column A and you want to bring in the corresponding data from that same row, here s the formula in B1 (for address) which you can fill right to get the phone#, etc. =INDEX(Sheet1!B:B,MATCH($A1,Sheet1!$A:$A,0))...

Excel: Excel Date, abbreviated format, philosophical question

abbreviated format, philosophical question, simple solution: I s pose we could just wait a couple weeks and that problem would just solve itself. hehehe There isn t any setting in Excel to automatically move the date ahead a year. I guess you could create a little macro or something to temporarily change the system...

Excel: Excel Date, best wishes, assumption

best wishes, assumption: Jeff, Excel makes the assumption that if you don t specify a year, it just adds the current year. So you can change the date on your computer, or enter the year code as well. You can use Edit/Replace to change them all afterward if you don t like those ideas....

Excel: Excel Date of Birth Formula, format cells, mmddyy format

format cells, mmddyy format, autofill: Tiffany, the answer is yes, though it s probably a bit complicated. I say probably because if the date you see isn t recognized as a date by Excel, then we have several extra steps to take - see below. If Excel sees those dates as dates, not just values...

Excel: Excel Date Formula, hi aaron, date function

hi aaron, date function, cell address: Hi Aaron, I Believe the MaxYearNumber is a named range on your worksheet. To find out go to the Excel menu and select Insert then Name then Define and look at MaxYearNumber cell address. Or simply click on the namebox which is directly above...

Excel: Excel Date Problem, weird behavior, cell references

weird behavior, cell references, email: So...are you going to email it? I don t care about the links. Just give me (in the email) a few of the sheet/cell references where you get this weird behavior. Also, whether it occurs in new files or not. I m leaving this PC for now. I won t be back at...

Excel: Excel Date / Time calculation, format cells, datediff function

format cells, datediff function, cell c1: use the same formula in cell c1 =B1-A1 and select the cell C1 Goto Format - Cells Select Number tab. and choose custom in category and enter the text [h]:mm:ss;@ in Type text box. I hope this will solve the problem. do let me...

Excel: Excel - Date and Time - Macro, time macro, current date

time macro, current date, excel 2000: Hi Cathy, How are you? Please see the following Procedures: Sub currenttime() t = Time() d = Date MsgBox Porto, + Str(d) + at + Str(t) End Sub or Sub currenttime1() t = Time() d = Date Set Displaytime = Sheets(1).Range( a1 ) Displaytime.Cells(1,...

Excel: Excel Date, windows control panel, cheers

windows control panel, cheers: Hi Jeff, How are you? This has to do with your system date. The current year is 2004, so if youdo not mention the year it assumes 2004. Change the date in Windows (Control Panel) to 2005 and you will see that 1/20 becomes 20/1/2005. You can define...

Excel: Excel Dates - grouping by month/year, blank cells, menu group

blank cells, menu group, pivot table: Hi Ashley, I m not sure which grouping function you are using, so hopefully this is different than what you are talking about. I m assuming your Date is in the row area of the pivot table? Right-click on the grey Date box and it gives you a pop-up...

Excel: Excel Dialog Boxes, dialog boxes, dialog box

dialog boxes, dialog box, quality survey: Hi Casey,how are you? Maybe the following can help you: Assuming that in sheet 1 you have the results, sheet2 and sheet3 have the Questions answered by Smith and Rogers respectively. If you want to sum up the answers to Q1 in A1 of Sheet1: 1. Type in...

Excel: About Excel Dialogs, dialog example, hth

dialog example, hth: Hi, you could trap the error with an if statement (the preferred way) or if you know exactly why the error is happening, you can use: Application.DisplayAlerts = False Don t forget to turn it back on at the end! Application.DisplayAlerts = True...

Excel: Excel Dictionaries, free medical dictionary, dictionary button

free medical dictionary, dictionary button, custom dictionaries: I did some more research, and as far as I can tell, it is required to add it to Word first. If I disable the Medical dictionary in Word, then it will no longer appear in Excel. As such, you will need to do step #3 from the previous answer:I opened Microsoft...

Excel: Excel Dilema, master spreadsheet, cell c3

master spreadsheet, cell c3, cell c2: Make the copy to sheet name be Summary This is one interpretation of what you said. It worked for me. Test it on a copy of your workbook so if it doesn t do as you expect, it doesn t harm you data. Sub copyData() Dim sh As Worksheet, sh1 As Worksheet...

Excel: Excel Dilema, master spreadsheet, master cells

master spreadsheet, master cells, spreadsheet data: Sub Combine() Dim Master As Worksheet If MsgBox( Is the active sheet the master sheet? , vbYesNo) = vbNo Then Exit Sub Set Master = ActiveSheet n = 0 Application.ScreenUpdating = False For Each x In Sheets If x.Name = Master.Name...

Excel: Excel Document set up, data validation, excel spreadsheet

data validation, excel spreadsheet, z10: Type the items you want to appear in the list in an out of the way place, like Z1:Z10 for example. Then select the cell(s) where you want the drop down to appear. The select Data, Validation from the menu. Choose List in the Allow drop down and type Z1:Z10...

Excel: Excel Drop-Downs - Loosing Fomatting, font colors, drop down list

font colors, drop down list, formatting: Sorry, this cannot be done with a drop-down field. You can use VBA to code the cell after you have selected the item from the list, that is not exactly what you describe here, but it may help. For some examples of VBA code relating to colors, that even if...

Excel: Excel Drop-Downs: Loosing Formatting, font colors, student names

font colors, student names, drop down list: No, regardless of all the different ways you can create a drop down list (you did not say HOW you have created the drop down list though in this case I did not need to know). I suggest you create a separate column next to where the names appear and flag...

Excel: Excel-Drop Downs, bear cat, cat index

bear cat, cat index, arguements: Check out these functions: =CHOOSE() =INDEX() Suppose these are your companies: Apple Bear Cat Daisy Eagle =CHOOSE(3, Apple , Bear , Cat , Daisy , Eagle ) The above would return Cat =INDEX({ Apple , Bear , Cat , Daisy , Eagle },3) The...

Excel: Excel Drop-Down List, excel drop down list, drop down boxes

excel drop down list, drop down boxes, drop down list: Richelle: I generated a quick spreadsheet to demonstrate how to create multiple/linked drop-down boxes. The more boxes you have linked to previous boxes the more complicated and difficult to follow it becomes; however, as long as you keep it organized,...

Excel: Excel Drop Down List, excel drop down list, data validation

excel drop down list, data validation, drop down menus: Yes, it s possible - I ve had to do it using three columns - the first has the full list of values, the second an IF formula that returns the value to the left IF it hasn t been used or a blank if it HAS, the third a formula using the SMALL function with an...

Excel: Excel: Drop-down List Disable, excel drop down list, vba userform

excel drop down list, vba userform, asistance: Need to know if you re referring to a VBA USerForm or stuff you ve put on a worksheet. On a UserForm your VBA could make the other dropdowns disabled by something like Me.Combobox1.Enabled = False but if it s stuff on a worksheet you d have to have each combobox...

Excel: Excel: Drop-Down List label, data validation in microsoft excel, excel drop down list

data validation in microsoft excel, excel drop down list, combo box: 1. a dropdown is NOT a combo box. 2. I don t think a combo box has a label like that. BUT If you really are NOT using a combo box, but are using the usual method (see http://www.officearticles.com/excel/drop-down_using_data_validation_in_microsoft_excel.htm),...

Excel: Excel Drop Down List, excel drop down list, combo box

excel drop down list, combo box, drop down list: Steve, I m not sure what you mean. Excel has a Combo Box that only allows one selection at a time. There is also a List Box that allows the user to select more than one selection from the list. These functions are replicated in VBA via forms. Which...

Excel: Excel Drop Down Menus, data validation, drop down menus

data validation, drop down menus, must be a way: It is possible, you need to use Excel names. To do so, select the range with the data on page #1, go to menu Insert- Name- Define, and type a name there (no spaces or strange characters). Click Ok to add it, go to page #2, select the cell where you want...

Excel: Excel Dropdown, excel dropdown, mail system

excel dropdown, mail system, age of time: I m sorry, but this is not clear. Please send a sample workbook to me at BobUmlas@yahoo.com. ... ...and fill in her percentages: B2 is 20%, B3 is 25%, B4 is 0, B5 is 45%, and B6 is 10%.... I assume the user types in these values. ...user goes back...

Excel: Excel DSUM, douglas m smith, selective data

douglas m smith, selective data, brainbench: Here s the first answer I sent. I think my followup erased it: Hi Bob, It s been a while since I ve used DSUM, but I remember that issue. I was to get around it in your case by expanding the criteria range look so: Code Code fz =g You might...

Excel: Excel being Dynamic, input cells, input sheet

input cells, input sheet, different day: Dan, Let s say you have three input cells on Source in A1, B1, and C1. The macro below will cut and paste that data to the end of column A, B, and C of Data. Modify as necessary. Make sure there are values already in A1, B1, C2, A2, B2, and C2 before...

Excel: Excel data check, random entries, data entries

random entries, data entries, dataset: Tileng The best way to check the data entry would be to use some method of tallying the original data, and then use the same method of tallying the new data and compare the two. for instance if the data consisted of numbers you can total the numbers and...

Excel: Excel data - copy to another source, current sheet, vba

current sheet, vba, a3: Susan, There is a way to read information from a closed file, but to the best of my knowledge there is no way to write to a closed file. In VBA, you could turn screenupdating off, open the file write the information, close the file and turn screenupdating...

Excel: Excel data lookup, table wizard, pivot table

table wizard, pivot table, pivot tables: SW Chong You found the right program. I would say you have at least 2 options to make this happen. The one I will not discuss at this time is a VBA solution. Using VBA for a project like this would take a consultant. What you can do however, is get Excel...

Excel: Excel, data validation, excel data validation, cell d2

excel data validation, cell d2, blank sheet: On a blank sheet, set up this simple example. In range A1:A4, enter IBM, IBM, FedEx, FedEx. In range B1:B4, enter Apple, Compaq, DHL, UPS. So cols A/B are now like a table, showing that IBM s competitors are Apple and Compaq, while FedEx s competitors are...

Excel: Excel data validation and copy/paste, excel data validation, validation rules

excel data validation, validation rules, security requirement: Nope, this does not work as I had thought it MIGHT I doubt that you really need a range name anyhow to do this. Try using ONLY this, untested: Private Sub Worksheet_Change(ByVal Target As Range) Does the cell have validation? If HasValidation(Target)...

Excel: Excel data validation, excel data validation, blank entry

excel data validation, blank entry, dollar signs: Hi Diane, You would select cells B10:B25 and while holding the Ctrl key also select B200:B400. Then go to the Excel menu and select Data then Validation... then select Custom from the drop down list and then input the formula. =SUM($B$10:$B$25,$B$200:$B$400)...

Excel: Excel getting data from a web page, weather web, a11

weather web, a11, wind speed: Russell, the code could be set to find the word Temperature or however it reads, then access the cell beneath it (same for wind speed). If you know what row the label is in, that simplifies the search, and prevents the find from getting the wrong cell - one...

Excel: Excel database to outlook mail, outlook mail, file xls

outlook mail, file xls, outlook field: Hi, Not sure if I met your deadline (was it AM or PM?). But I only check the allexperts.com emails every few hours. Sorry if I missed it. But yes, you can create a database in excel and import it into outlook. These are the steps you would follow: ...

Excel: Excel database, surname message, 1000 names

surname message, 1000 names, search procedure: Hi Tyson, How are you? Please try the following 1. Write yor records in A1:F15 2. Tools-macro-VBE 3. Insert module 4. Copy Sub FindingSurname() Dim A As Range Set A = Range( A1:F15 ) X = InputBox( Surname ) Message = Not found i = 1: found...

Excel: Excel - date format, quirks, january 1

quirks, january 1, craig: Hi Amy, Unfortunately, excel has quirks for reading dates. It will assume that your 82507 is the number of days from January 1, 1900 and give you a value of 11/22/2125. It will default to the current year if you typed 8/25 Hope that helps some, ...

Excel: Excel date formatting, csv format, cell a1

csv format, cell a1: Since Excel doesn t recognize 20060301 as a valid date, it will display ##### when formatting the cell as a date. Presuming the date is in cell A1, you can use the following formula to convert it to a valid date: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))...

Excel: Excel date formula, chip pearson, xl2000

chip pearson, xl2000, service time: Hello Mike Assume the start date (6/16/86) is in cell F7 then =DATEDIF(F7,TODAY(), y ) Returns 19 (years) Datedif is only documented in xl2000 and it offers a lot of different options. The best place to look is Chip Pearson s site http://www.cpearson.com/excel/datedif.htm...

Excel: Excel date formula, cell a1, cell b1

cell a1, cell b1, benefit eligibility: Kim If you put the hire date in cell A1 and in cell B1 you put the formula +A1+30, the result in cell B1 will be a date that is 30 days from the hire date. For example if cell A1 is 2/15/07 the result in cell B1 will be 3/17/07. Hope this helps Richar...

Excel: Excel date formula, douglas m smith, brainbench

douglas m smith, brainbench, time values: Hi Mike, You can do math with dates like regular numbers, because they really are regular numbers. Today (4/28/2006) is actually 38,835. Select a date and change it s number format to General to see it s decimal quivalent. If your dates are in cells...