Someone told me that there was a formula/function that would allow you to sum cells with a specified background and/or text color. Does anyone know either how...

I don't have a clue to using VBA. How do you begin to enter code to perform tasks? Please Help Anita --- Message posted from http://www.ExcelForum.com/

Lets say I have 50 sheets, one for each state. I also have a sheet that has a years worth of data. So the data sheet has something like this...

Hi, I was using excel97 but I've just changed to 2000 and I've got problems using a sheet I've been using on 97 for months. I have the formula: ...

I want to be able to "Copy and Paste" one Sheet to another using the Excel Com component for version 2000. At the moment I have written something like the...

Sorry to post this here and on Developer page, but hopefully one of you VB experts out there can help clarify something for me. I want to learn VB and can get...

Cannot use the shortcut 'ctrl+shift' when selecting within existing table- but am able when create new.

Does anyone know of any way to format the output of an if statement? I'm looking to do a very simple if statement and then based on the output I want the text...

I'm trying to get the following formula to work. I16 is a data validation list (drop down list) and I keep getting the circular reference error message, can...

I have columns A and B filled with information. The information in A1 refers to B1, A2 to B2 etc..... In some of my cells, there is duplicate information, and...

Hi I have a list of names and addresses which are all listed in column on vertically but I need to change it to horizontally without having to retype all the...

Hi all I'm trying to create a spreadsheet that returns data from another shared worksheet used by a number of colleagues. Is it possible to have a formula...

Greetings, I am having difficulty looking up an item using two-column lookup formulas as suggested. Following are the parameters of my situation 2 Different...

Excel 2003: I need to search a value in worksheet (2) that exists in worksheet (1), confirm if it status, in the same row but another column, is "ok" or "not...

newbie question.. I have 5 cells (A2:E2) which have different percentages the headers of these cells (A1:E1) have year-end date eg. 12/31/2004, 12/31/2005,...

Hi, I'm trying to create a slideshow with one excel table rolling across several slides. The data will change and needs updating monthly; I want to be able...

Ok, that was easy for you guys but..... I have now another problem totally related to this matter. I have 3 columns of data, NAME, DATE,TEXT NAME Date ...

I have protected my workbook and can't remember the password. Is there any way to recall, or override the protection?

I know how to look up data and text using vlookup and hlookup, what I'd like to know is whether there is a way of looking up data based on more than 1 search...

Hi, I find this very puzzling. I have 2 cells with the following values. -2.53948423496706E+64 (say =t) -4.04686094372251E+96 (say = m) Now I have 2 other...