Hi I wrote a vba function that should return data to the excel spreadsheet after querying the Oracle database. I have installed and created a Microsoft ODBC...

I have a sheet with inventory, col (A) material Col (B) description and Col (C) Part Number. I also have a sheet that does a Bill Of Materials. It gives...

I'm pretty new to this game, so here goes..... If I enter a date in cell A1, say 24/11/03.... I then want B1 to tell me what month that is (i.e...

I am new to excel and I am trying to learn how to create a scorecard. For example, I want the end user to be able to simply type a "1" in a cell but I want it...

When trying to link a worksheet to a Word document, Excel only gives me 10 of the 15 rows in the worksheet. I'm using the insert, object commands in Word. (Or...

In Windows 98, I could search within "all files" and AUTOLISP files would be included in a search for text content in a folder. But now, in Windows XP pro, it...

Hi, I've got a column with a list of times and want to calculate the number of instances in the list that fall within 12 hours. ie. In the table below C6...

Is there any way to "tone down" the code that Excel 2002 creates when saving a worksheet as a web page? We converted to Excel 2002 this past year at work and...

Ok here's one that's been killing me This version works fine B10 to 40 are numbered 1thru 31 C10 thru 40 represent the days of the month with C3 thru 9...

I'm using Office XP and am putting text I typed in tables from Word into an Excel spreadsheet due to the columns expanding way beyond 11x17, Word's maximum...

Does anyone out there know how to link a cell to a stock quote and automatically update the quote whenever the sheet is opened?

Hello, Months ago I had origionally changed this option, but for some reason it has defaulted back and I can't remember how I had changed it. How do I change...

Hi all, I'm kinda doing a personal project for myself. I want to create excel worksheet tables for all the necessities in daily life. It will range from...

Is there any way to have excel read all the parts of a nested if statement before returning a value? My formula is...

:confused: I need help. I read and re-read the instructions on this on the help on Excel 2000 and I am very confused. Why do they make it so hard? I just...

I have a range of dated in a column and want to arrange them in assending order. My problem is if that this range of data is linked to another data input sheet...

Hello, Is it possible to count a specific Conditional Format? For example: Any missing data in a column range due to certain criteria I highlight the cell in...

Hello all, I am looking for a way of counting the amount of times "PASS" appears in column B wether or not column A is filtered. I have...

Just tring to write a macro to copy one row to another with some columns changed. Can't figure how to mouse pick the second row, don't want to key in. I can...

Hello, I'm new to this group, so any help would be greatly appreciated. I have protected several columns in excel and I have found that the cells that are not...