Been racking my brain on this one and I don't know why it hasn't worked. I'm using the Find method in my VBA query to find cells that contain the value...

I have a list of email address that are separated by the symbol. I want to separte each address to its own row

Hi, We've got a batch programme that created a few hundred reports (person specific numbers in same layout). All it does is take numbers from a table and...

My worksheet that was created by someone not here anymore has over 2500 pages. At the end of the worksheet in a cell is a little blue symbol in the bottom...

Hi. Similar to a poster earlier today, I'm creating a Pivot Table based on data in an Access database. When I link to my database, in the Select Table...

I have a worksheet in Excel there is a column titled Grade, and and another column titled car allowance, I want to give the employee with grade D only BD 100,...

Using office 2003. I have created a pivot table from data in excel with many columns. The data in the comments column cuts off after 254 characters (with...

Hi Frank, Thanks for input. I've used this Formula referencing the cells with the A1-Style and works ok. Can you explain the use of =1 in this...

I have two worksheets that list, among other information, product codes. These product codes are all 10 characters long, but some are entirely numeric (i.e....

I receive data daily with dates in the following formats: dd/mm/yyyy, d/m/yyyy,d/mm/yyyyy, or dd/m/yyyy... The values actually are text vs. numbers. ...

I'm getting #DIV/0! with the following formula, the cell is format as a percent. Thanks =(E34-D34)/E34 E34 = 0 D34 = 0 Result should be 0%

Hi, I'm really struggling with what I thought should be easy. A B C D branch salesperson ...

I am using this CF to find my duplicates =COUNTIF(A1:A$10000,A1)1. The next part I need is to count the number of duplicates (gray shaded & strikethough). I...

Is there any reason my mouse won't scroll in Excel? How do I fix this?

I am trying to save a file and I keep getting the error message "You don't have permission to save in this location. Contact administrator to obtain...

Hello: The client has a dual monitor. And, we have a 3rd-party Excel Add-In that "pushes" data into our accounting system from this excel spreadsheet with a...

Using Excel 2000, is is possible to copy and paste a range which has merged cells such that the pasted data displays only values. When using paste special and...

OK, so I started the experiment and soon got pulled up. I'm saving my .xls file as a binary .xlsb, and the darned thing wants to put an underscore in front...

Hello, Does anyone know why the "$" command will not work in formulas when running VISTA? Does anyone have a solution? A simple version of my problem...

I have created an Excel pivot table from a SQL Server data source. The pivot has columns showing "Actual" against "Forecast" numbers for each department....