help with mail merge (word doc and excel spreadsheet). when i select the excel spreadsheet, i get a box that has table 1, table 2, and table 3. they are...

I have two columns of data and there are dublicate entries which I need to group together: Data: A1 B1 Dog ...

feature of XL 02 moved or removed in 07 ?

I use this formula when I want total number from another worksheet to a target...

After pasting some figures, the borders around my cell disappear, how do I return the borders back to normal? Thank you

How do I re - build border of my cell, that have been removed by pasting of data? Thank you

I need to add on to my question from the other night. Here is the example A B C Count Size Type 2 4x8 EPS 0 ...

My name says it all!! In Excel 2003 I am trying to get a third result from 2 other Y/N results. What I need is: Cell W4 needs to be R if: I4 and J4 =...

In a column I have Vlookup formulas. Some have an error "#N/A" if it can't find the data it is looking for. Is it possible to show a blank instead of "#N/A"...

Ron de Bruin Can you help with your code please I cannot lock any of the worksheets that have @ in Cell B1, because if I do the whole sheet becomes...

How do I put a French accent over a letter in a name in this program.

I have a workbook that works on every version of office including 2007 except for 1 person. My question is simple. Is there a setting in Excel or windows...

I have certain rows with data validation drop boxes in them with locked rows in-between. Is there a way to get the cursor to move to the next row with a...

I need a formula that says something to the effect of: IF the value in A1=2 THEN transfer A1:A10 to next available row in sheet 2 IF the value in A1=3 THEN...

I have a SQL table (30+k rows) downloaded via a query and need to insert a row preceding every change in the MeasID field in Col A. I need to fill in the...

Hi everyone, I am managing an excel spreadsheet at work that is strictly text data, the issue is that more often than not there are paragraphs of text in...

In a tracking sheet, I differentiate between uninstalled equipment (in bold) and installed equipment (non-bold). Many cells in the same range are unassigned...

How do I change the button face to a picture of my own choice once I have put a macro button on the quick access tool bar. I dont want one of the Microsoft...

I use workspaces frequently but suddenly I started getting an alert (101586) indicating 'This extension cannot be used with the selected file type. Change...

I have one workbook with 14 sheets and each sheet represents different regions in the country. On the first sheet I have a master list of contacts. I want to...