Say I have a workbook with 12 sheets, is it possible to create a
dropdown box in sheet 1, or any other sheet, that would quickly allow
me to select any of the 12 sheets?
or, a drop down box that would pull the info from one of the sheets

Is it possible to have a cell default to a value from a function but allowed
to be overwritten?
I want a cell to default to the current date but allow the user to overwrite
it with a different date.

I need to sort a list by column "A" to take out blank rows and/or rows that
are populated with garbage that tagged along when I imported it as text.
Here is the problem (simplified for easier explanation):
Cell A1 is a part number.

I have 3 columns of data in a spreadsheet, and I need to create a report
Example-
Airline    DelayCode    Time
ABC      -   DEL       -   2.00

microsoft excell won't  print when hit the print button comes up with a save
button then wont still print .

I've built a spreadsheet of employees in rows and attributes about them
in columns.
I've recorded macros to sort on the columns (sometimes by one, two or
three columns per sort).

I'm attempting a VLOOKUP.
The lookup value is a field that has the little green triangle in the upper
left corner of the cell (like when you put an apostrophe before a number) ie
10054

Hello -
I'm pretty new at this.
I need to email an excel file. I have used VLOOKUP (which references another
file not in the same workbook). If I send this file:

My Excel 2003 worked fine until yesterday afternoon when I did the current
release of Microsoft security updates. Since that time I can not do a Save As
in Excel. When I do, the program hansgs. I have uninstalled and reinstalled
Office 2003 three times with all updates and it ...

I'm new to this. I need to drop a value into a cell where there is nothing.
The 'target' cell should not have a formula because some days I would need
to place a one time value there , doing so would wipe out the formula.
Example:

This is an extension of my previous post on Name of Procedure. I also posted
it on OzGrid without any positive answers. I hope this is not considered an
'illegal' cross-post
To reiterate,  my problem is to find a [simple] way to get the name of the

Hello All,  I have a column with hundreds of entries consisting o
approx twenty different number values ( very random locations ) ie. 00
or 343 or 552 etc - how can I produce a column that will list only on
of each of the values but in an ascending order? any help would b

I'm brand new to using VB.
I have been playing around with setting up required fields in Excel. I
was lucky to find a post with the following code:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As

I have four cells with the following texts
A1= abcdef
A2= abcdef
A3= xyzdef

I am having trouble trying to make a formula work.
what I am trying to do is this.  I have text in one cell ie Townsville,
Sydney, Brisbane.  If I have Brisbane in the cell then I need the worksheet
to take the value from an adjacent cell and *0.44%*50/25.  If the value of