I have a spreadsheet with various invoice numbers in column A:
For example:
FC110107-002
PB110107-001

I have a worksheet where cell "B1" automatically generates a unique
number (i.e. like an invoice number). I would like to have a command
button (as well using the File|Print) to print the worksheet as well as
saving the worksheet to a unique filename which includes whatever is in ...

Is there a limit to the number of records that will display with the
"autofilter".  I have a worksheet with about 50,000 rows and when I turn on
"autofilter" on one column the data that I'm looking for does not display
even though I know it is there.  I can find it with the ...

I am working with a large data set and I am interested in calculating
standard deviation of over 100 samples, but I want to ignore any zero
values and only utilize the non-zero values in the calculation. Does
anyone know an easy way to do this. Thanks for the help.

Can someone take a look at this post:
http://groups.google.com/group/microsoft.public.excel.worksheetfunctions/browse_
frm/thread/8c6541d562c3db71/66953084d4a98d93?hl=en#66953084d4a98d93
The group isn't very active today and I need help as soon as
possible...

I am trying to create a macro that will delete a cell content and
related tab by picking the cell.  i.e. We have bunch of names in column
A starting at A2 in tab "Roster".  Each name in "Roster" has
its own respected Tab.  The macro or Code once activated will have the

Sub Button1_Click()
Dim xVar(1 To 4, 1 To 3)
For k = 1 To 4
   ax = k + 1: bx = k + 2: cx = k + 5

The following function works fine, however, if there are no dates
populated into my spreadsheet, the resultant cells in column H show the:
#VALUE! error.
=+IF(AND($B$1-G3<-24,$B$1-G3>-31),"D",IF($B$1-G3<0,"C",IF($B$1-G3>=0,"E"

A question that may be complicated to read!
I have set up a spreadsheet to do the following:
1.  Data is captured in columns A through H.  These columns and 5 rows have
been set up as a list

I'm having problems at programming a piece to add a printer to a
list...
The first printers (31 of them) are allready filled. They are given an
ID represented by

I would like to be able to temporarily disable one of the _Change events in
my form because I don't want it to fire during,  for example, the initialize
sub.  I've tried several things including using the .enabled=false, and
.locked=false, and even Application.EnableEvents = ...

Hello from Steved
I have no I'dea as to what I've not done.
The below will filter City but it will not copy into City - Panmure Sheet
Please explain to me what is reqiured for this to function Thankyou.

If I have a range in excel that has angles in degrees in one column and
lengths in the next.
ANGLE  LENGTH
90        5

I have protected and shared workbook. The data is in columns "A to J".
Column "D" is locked.
Is there a solution to copy paste rows? I don't need to c/p entire rows,
just columns A to J, skipping the D column.

Is there is a function that I could use , where if a cell is equal to
Day1, it would show me an already created chart and if B1 is not "Day1"
it would hide that chart?
Any help is appreciated!