Hi All, I have a file which has the tool|options "save external link values" checked. however, each time I reopen the file and choose "NO" to the prompt which...

I'm able to list all file on my drive with ... Sub MyFiles() With Application.FileSearch .LookIn = "C:\" .FileType = msoFileTypeAllFiles .SearchSubFolders =...

I have an Excel file with a list of deals transacted that contains data with say ten column labels. On each row, only one column; commission income, is meant...

I remembered I seen somewhere before that we can combine two cells data and text into another new cells using "&" (eg. 345&A1 where A1 is 1000 - the new cell...

If you truly have ten different conditions, then only a macro can accomplish what you want. If, however, you have one or more conditions that when true get...

i am trying to do a shortcut where i drag the formula down the column. in the A column i have my percents (10,20,30, ect), in c1 i have 200, in order to have...

Hi I think this can't be done fully automatically. I'm pretty sure that you have streetnames not ending with 'street', 'avenue', 'drive' but with a random...

Is it possible to display a file's date stamp (modified date) in a cell in Excel? I would like to say something like "File last modified:" and then either in...

I need to know how to show what is in a cell from another worksheet. The catch is that the cell on the other worksheet is constantly changing. Example:...

Unless i'm missing something the way to do it is to use a custom filter. You can get to the filter by cliking data (make sure the cell with your heading is...

is it possible to assign an input mask to a cell in excel (i do this in forms in access). Example: entering phone # The cell before data entry would display...

I have 3 spreadsheet files 2 are look up tables. Basically they contain catalog information from 2 different companies. On the main spreadsheet if comany A...

Hi group, I am using the Office 2000 package. I am trying to find out if there is a way (without using VB at this point) to create a formula that will allow...

Does anyone know of a way to use a combo box in Excel XP (2002) to link between pages. I know how to create a combo box and get the list in it. But what I...

I have a workbook that has 4 worksheets in it. I want to be able to add a row of information in worksheet 1 and have it update worksheets 2, 3 and 4.

Carol, You have to write the formula like =IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...)) -- Cordially, Chip Pearson

If you just want them to see the data, do the following: use Ctrl+A to select the entire page in each sheet tab. Then Ctrl+C to copy it, and Ctrl+V to paste it...

A question about using the countif function. The example below from office help shows criteria as a text string ("55"). =COUNTIF(B2:B5,"55") I wish to use...

I want to change number amounts to letters. Whe 1=P, 2=A, 3=T, 4=H, 5=F ect. Example: In cell A:1 = $1.45 In cell B:1 = PHF

Hi I am new to using Excel 97. I have a speardsheet that has 19000 rows. Column A contains a list of numbers. Some of these numbers are duplicates. Is there a...