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: ...

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...

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/

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...

Really simple question, haven't been at this for to long, and all I want to do is have my column headings show on each page when I print. (not the labels - I...

I cannot view on screen cell formats I've made (like colored shading, patterns, or fonts). I know how to format a cell and my print-outs show the formats...

I have had the same problem in both Excel 1997 and Excel 2000. I always use the Accounting format which gives a dash for a 0. However, every once in while I...

Hi, I do not arrive to create this personalized format who is responding to these 3 conditions (number is displayed in percentage). 1) if 0 the colour...

Hi, I've done a couple of searches through excelforum.com, but I can't puzzle out what I need. All I need is to fill one column with alternating rows of dates...

Using 2003 home 2000 work Searched NG's with Google-search and 2003 Power Programming for a list of formula cell types. In short, what does the 23 and/or 16...

I have problem with INDEX and MATCH I have 3 columns of data, NAME, DATE,TEXT NAME Date Text Carlos 1/1/4 Hello Carlos 2/1/4 Good Carlos 5/6/4...

I am trying to average a range that meets certain conditions. Here is the example: worksheet1 A B ----------------- jan 1 dec 1 ...

i want to search in a data base excell, but is usual a dont remenber the whole reference but just a part, is it possible to search for half words only? Ex:...

Hello :). I am trying to import a table from a web-page where some of the values are written for example as 7 -35. I am making a querry for importing the...

This may be something simple, but does any one now how to remove leading characters from a cell that was imported from another system. The first 8 characters...

I have a long list of numbers, such as: 106-89-8 141-43-5 197-77-81 50-00-0 When I sort the cells, the 50-00-0 comes either first or last. I want Excel to...

I have a module that moves a query from Access to Excel. Works great except that the one field which is a memo field containing records with a Carriage Return...

Is it possible to adjust the scroll speed used when clicking and dragging to cells beyond the edge of the screen? I find that more often than not, excel...

Hi, I've searched the online help and elsewhere on the internet for a solution to my problem, but have had no luck so far. I'm creating a report that is to...

Hello I probably have and easy problem, What I need is to add to a formula that if the answer to the formula is zero (0) to make the cell blank. I curently...