OK. Here's what I'd like to do. 1) Have a particular set of cells only allow 2 digit numeric data. 2) After the 2nd digit is entered, auto-magically tab to...

I have 4 relavent fields in my spreadsheet. Columns A and C represent some time frame (ie 1,3, or 6 months). B and D contain profit expected during that time...

hi, i would like know how to return a row number or cell number thru a macro. i read some other posts that had this issue, but i could not understand much....

I have a worksheet was setup to allow users to edit certain ranges when worksheet is protected. I deleted one of the ranges which users should not edit it...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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