I want to put a formula in cell I150 that says look up the code in cell G150 and go find that code in the List tab in column A, then return the text in...

Why can’t I just use the “%� button on the Formatting toolbar? Why when I click on that button it gives me red bolded number but not the percentage...

I have a spreadsheet with 2 tabs and I need the values from the first sheet to automatically fill in on the 2nd sheet. what is the formula to share cell...

Excel 2007 I have a file with a date picker in Excel, that all of a sudden stopped working. It is an xlsm file.

I have one file for commissions / sales for each of our 30 sales reps. Each rep has their own tab with their information in it. Every month I go through...

I need to change the names in the drop down list that appears when clicking an arrow next to the name Burdett, but I cannot figure out where that list is...

Hi I'm re-posting this in hopes that there is still someone who can answer this for me: Received a new work laptop with Office 2007 and I am attempting to...

I have a spreadsheet that runs sls results by month (column) by Cust (Row). I set up a data bar to reflect activity based on average of the 3 most recent...

At present to search for a date within my workbook I use the following code, Sub myfind() Dim Message, Title, Default, SearchString Message = "Enter date as...

I am trying to help a colleague who is a small problem with Find/Replace. Her worksheet has cells with text in them like: Health and Wealth She wants to...

I am trying to write what should be a fairly simple thing.... I need the user to be able to select a report thorugh drop down menus, then an example of this...

When double-clicking an excel file in Window Explorer, Excel normally opens up the file automatically. This is working fine on my PC usually. However, if I...

Running Excel 2003. I have developed a workbook based on a previous workbook. My workbook has a link to another sheet. When i open the workbook it also tries...

I am tasked with creating a macro that will automatically go through a sheet filled with various records and delete any "extra characters" that may be...

I'm using Excel to generate some reports in background which could take long time. The problem is that a lot of copy/paste is used in the template for...

Hi, How can I make a cell on a worksheet always accept input from a certain cell on any new copy of another worksheet? In Excel 2003 I have made a workbook...

Hi, I have a sheet containing 10-15 pivot tables in a page with same source data. When I change the data and do a refresh on pivot. I get Error saying that "A...

Using Excel 2007 I have a spreadsheet in which I enter report data. Each row added is a new line of data. In order to validate data entry I am attempting to...

Dear all, Please help How do i Import Contacts from Outlook into excel sheet regards

How can I convert from number to text? for example I need 10 converted to (ten), 2 converted to (two).