Is there a way to use 3-D reference in the vlookup function? I'm trying to have the vlookup function look in multiple sheets for a specific data. I would...

When deleting rows from large worksheets, the horizontal scollbar still takes you to the bottom of the worksheet when you drag it to the bottom, whether there...

I am doing a spreadsheet and I want to be able to type the work RENTAL in one colum and have a value of $10.83 appear in the next colum. thank you.

Have a form with a combo box whose source is a worksheet column of specific dates which are in the format 11/05/03. When you click on the combo box on the...

Hello peeps, i need to figure out how to count the number of items in a list that are different.. say i have a list of number 99 lines long..but there are...

We have Word and Excel templates that were developed specifically for our company. The templates can be quite massive and are heavily linked. One of the...

I would like to be able to have data from a number of workbooks entered automatically into another workbook that has several worksheets. The data from other...

We have a population of 70,000 and need a formula that would show a growth of 2% over the next 10 years. Can you help me with the formula, please? We are...

I have 10 workbooks (w/ 1 sheet in each) that I need to save as a .csv file type. I also need to close each one so that the newly created file can be imported...

This sounds like a perfect use for Access, where a "row" is a "record".. "Penny" wrote in...

Hi All, I would like in column A to display names of all my worksheets. In this workbook I insert a new worksheet each working day (5 or more days a week)....

I have 4 columns of data. The column headings are Mild, Moderate, Severe, Maximal. The data is specifying a 'reaction'. For instance, Row 2 (client 2) had 2...

Use the function called PROPER ie PROPER(A1) turns BILL SMITH to Bill Smith "Rob Coombs" wrote in...

I have several macros I have created and I would like to have high security, or at least medium, but I don't like excel asking me each time I start about the...

Hi, I posted this note yesterday however my job related email address will not allow attachments and suspect that I may have received some replies that I...

When you enter a function such as median or average which refers to a range of cells that have one or two #N/A's, it does not return a value but returns #N/A. ...

Can someone please help? Having created over 50 forms for multiple users to access, it is very cumbersome without a table of contents and index, but I am lost...

I have a worksheet with several pivot tables, is there a way to update the data on all pivot tables? The 'update data' button on the Pivot table toolbar...

How can I navagate down a sheet "x" rows, make that cell active, where "x" is the value in a cell.

I have excel 97, and the average function does not work? I tried reinstalling it, but still not working. I am on a LAN and I suspect it has something to do...