I am trying to use this code to hide all empty rows in column A when printing
I would like to start in row 6 an end in row 2000 so my header will print. It
doesn't work can you tell why?
Sub Hide_Print_Unhide()

)What formulas to use (for O/T) on a weekly time sheet that contains multiple
overtime rates:
Ord Time X 7 MON-FRI   8th hr X 1.5    9hr+ X 2
Saturdays - Ord Time X 5 -   6th hr X 1.5   -    7th+ hrs X 2    

I'm not sure how to do this.
    A           B    
34-f-r        33    
34-f-r        56    

Is it possible to access an address stored in another cell?  For example:
G100 = "test"
A100 = +G100
Now, can I get any information about the address stored in A100, which is

I have dates in A, numbers in B, start dates in C and a finish dates in D.
How do I get the sum of the numbers between the start and finish date?  I
have tried...
=SUMIF(A2:A24,"<=C3",B2:B24)-SUMIF(A2:A24,"<D3",B2:B24) and

I am trying to create a formula that will count multiple values in
cell.  For example if I have a spreadsheet that look something lik
this:
Cell A4 = B _____Cell B4 = B_____Cell C4 = A, B_____Cell D4 = A

i am trying to create a column in an excel sheet using multiple IF statements
IF the value in sheet5 column B = X, then go to sheet1
IF the value in sheet5 column B = N, then go to sheet2  etc
Then

I've highlighted rows in Excel that stand out only because of the color of
the font.  Can excel sort by the font color, so I will have all red items
grouped together?
Dog    puppy

Want the column index number to pull from 3 different cells and show the
three numbers?

I am trying to take a net sales number and break it down by % amounts in a
stepped manner.   For example:
$2500.00 in sales.
The first $1000 or less would be paid at 45%    ($450.00)

I need to return a value from another column based on another value I'm using
to filter the results. I can use index and match to do this.
=INDEX(D10:D100,MATCH("New",L10:L100,0))
This returns the value from column D that corresponds with the first

In Excel, how do I setup sequential numbering on an invoice?

I have a large data table that is set up like this:
GOUL05C260.00    34.8
GGDL05C320.00    9.3
YVCM08P310.00    64.8

I have a drop down list that contains clinic name/address/city/st/zip/phone#
in a merged cell.  Is there anyway to format the spacing so that it will look
like a proper ship-to address?
Thank you

I've "inherited" someone else's office. The Excel on that computer is such if
I type an equals and a formula, it puts an apostrophe at the beginning and
converts it to text. I can highlight and change back to an equals and it will
calculate, but I shouldn't have to do this. If ...