General

File name is followed by a colon then a number, what does that mea
I use Excel 2007 and save/use files in the older format and some files when opened display the file name with a colon followed by a number at the end. For example, Sales.xls:1 and Sales.xls:2. Both files will open together and appear to be mirror images of each other. When data is changed in one I can go to ... 2 Jul 2008 17:03

counting alpha data
I am trying to count how many times a name appears in a list. Is there a formula? ... 2 Jul 2008 17:03

Document title in Microsoft Excel 2007?
I am working with a document in Microsoft Excel 2007. In previous versions there was never any doubt which document was on top. Now I do not see the title of my document at the top or bottom (or side or any place) on the screen? I find this VERY inconvenient especially when having more than one document open... 2 Jul 2008 16:01

Find & Replace in Excel 2007
I am using Excel 2007. I have a spreadsheet with numbers (values) and text. When I use the Find and Replace feature to fing a specific value in my spreadsheet the find feature is not finding it. I also tried finding text and I am having the same problem. Any idea if there is a bug in that feature in the 20... 2 Jul 2008 20:09

Soft Returns
Within a cell I often force the text to wrap with what I call a "soft return" which I do with an ALT-Enter to make the text wrap within the cell. However when I copy the text in several column headings to another location with the transpose command, it shows up with a square character where the solft return wa... 2 Jul 2008 17:03

Referencing Help
At my job a spreadsheet needs to be filled out every single morning documenting all of the items we've produced from the previous day. In addition to the item number, the item's weight and size needs to be filled in. There are numerous products that we sell on a daily basis, so you can imagine how this might ge... 3 Jul 2008 04:18

opening a file in Excel starts application but dose not open file
What has changed? When opening an Excel file from a short cut on the desk top or from the tree. The application starts but the file is unopened, you can then go to "file" and Open the file with no problem. Which setting has changed? ... 2 Jul 2008 14:59

Simple VB for Excel Question
I want to create a macro that will check a cell (E5) which is a formula =IF(ABS(SUM(J70:BD70))>1,"Not Balanced","Balanced") and if it has "Balanced" , then I want to put "Processed" in cell G6 and put a time stamp in cell F6, if "Not Balanced" , then zero out cell G6 and F6? Here is what I have so far that is t... 2 Jul 2008 14:59

How to find all folder and/or files in a specific location
I want to make a macro that reads folder names in a particular path. I am saving files to path F:\Documents\School- FL\CBT Tracker VB project . If user inputs year as 2008 a new folder is made at that location and the workbook is save under the new folder with the teachers. When the user comes back to the pro... 2 Jul 2008 13:57

Counting Formula
On a worksheet name sales this is what I have I need in Column J for the forluma to look at a worksheet name Parts whic looks like this C D E F 2 H-1 0 0 Yes 3 C-55 350 12 4 H-1 0 ... 2 Jul 2008 18:05