I have an excel template that has 20 worksheets. I want to have a drop down menu that will show on any worksheet and allow me to select any other workshhet....

Hi--I have a column of numbers for A1:A40 that I simply need to invert. Any suggestions? Wayne

i want it to automatically increase everyday without inputing the dates everyday. then i mind as well change it myself. i will not know when the last day is...

I'm new to this, and I have no idea where to start. I was given an assignment that I just really do not know what I'm doing. I need to list information on a...

Hi!! I just had been installed MS Excel 2000 and when i begin to add information, each character i type, appear an Error Message saying something like...

I'm having a problem with a function in a worksheet that pulls information from another worksheet based on 2 columns. The formula I'm using...

i have a cell on my spreadsheet that i want to have a numerical value increase daily automatically starting from the day that it is inputed. from example in a...

When using a list for data validation, is there a way to populate the selected cell with a default value from the list? If the cell is selected and the default...

Consider my following excel sheet A |B |C |D ---------------------------------------------- 1 |Student ...

Hi, Is it possible to Display Progress bar which runs on its own with a Macro?? Actually i have seen in one of the sites that it is possible but our program...

This is done with the Group and Outline feature. Search Help for Outline. HTH -Dave "kami" wrote in...

I want to put a condition in my if statement that asked for a check of any data in a particular cell that is like a certain string of text or contains a...

This works in Me why not in XP Workbooks.Open Filename:="C:\My Documents\One\" & _ ActiveWorkbook.Worksheets("sheet4").Range("A1").Value _ & ".xls" Thank...

How do I create a three-way datable.

I have a spreadsheet with 1600 rows of information. I am trying to cut and past information from another spreadsheet into it. The cut and past function...

After blocking text I can use Ctrl+C to copy but the copy command under the edit menu is always greyed out. Cut and paste are fully functional.

How can I (most easily) do this: Type in item specific information such as a part number into a Excel spreadsheet cell (spreadsheet is already...

I would like to reference a remote cell within a function argument, that would return not only the remote cell value, but also the remote cell format. ...

I am actually working on a spreadsheet that I would like to use them for but I am having troubling understanding how I can use the statements to my advantage. ...

I am new to VB, coming from C. Perhaps had I stated with VB, I would be catching on sooner. I am trying to fill an array of a user-defined data types, which...