Hi, I've never used Macros in Excel before and need to start now. Basically every so often I receive a list of patients from GP practices in Excel documents. ...

I'm creating a high school directory using Excel 2002. Once in a while I will get typing a little too fast and turn off Num Lock and then I end up in the wrong...

I want to create two excel sheets. One to print OT the other to print NT. How do I program a variable to give me a 5 by 5 print out of 27 or 39 names (books of...

I select a value (1st number), then I need to find a second value located 5, 10 and 15 readings previous. The information is 90 rows long and 5 columns wide....

I have scanned a company invoice form to an Excel spreadsheet. The automatic format is a picture and I have made it transparent. I'm having trouble lining it...

I have a very long address list, with more than 50 different zip codes. I would like for excel to count how many times each zip code appears. Is there a way to...

i know that at Excel 2003 have a key call "data analysis" which can get all the info about a set of date. i am looking for it at 2000 professional version. But...

Does anyone know of a excel on the web that you can put your monthly business expenses into and keep track of your expenseeach month. I would like to...

For some reason when I click on an Excel file in Explorer File Browser, Excel is opening as is PERSONAL.XLS. The actual spreadsheet is not? What would of...

i have a column of numbers that I am pasting into a worksheet and they are 13 digits. i just need they listed as they are no funtion to them(mathematical). ...

How do I have a drop down list in a cell of a bunch of items and when you select on of the items in the drop down it will fill in the whole row and columns for...

I am having the following code: OSHEET.CELLS(2,3).SELECT MSGBOX OSHEET.CELLS(2,3).VALUE MSGBOX ACTIVECELL.VALUE The cell is having value, but still, its...

Can you use a OR function in an IF function. I'm trying to check a cell on sheet 1 for certain text such as "HS-C" "HS-U" "HS-D" "HS-R" "HS-L" "HS" "ST-C"

I'm learning Excel by myself and I've run into something I can't figure out. I have a button at the end of a row that takes 4 seperate cells from that row and...

Is there any function which can return the number of rows present in the specified sheet. I remember I have seen one function for this befor somewhere. But...

Dear All, I want my out put to be as follows can any one help me on this it should check the condition A,B,C & out put in D as follows A ...

Hi guys and girls, Want to learn excel, but find the best way for myself to learn is to develp an actual app for someone to use with all bells and etc...

How do I do this??? Thanks

I am a newbie to Excel. I have a spreadsheet for a class in which I am required to find the most sales by using IF and MAX. Also, I must find the least sales...

I have an excel spreadsheet that has 2 columns of numbers side by side. I want a formula that counts the number of times the number in column one are larger...