When nested subtotals are created for sorted groups, the inside subtotal appears before the external subtotal as expected until the inside group only has one...

When I assign a macro to convert & sent PDF file it seem to work when I record the macro but when I run it it attached an xls file instead of a pdf file.

I have a cell with a training date. I would like to format the cell to change color when actual date exceeds training date by one year.

I'm working on a formula for Split Shift (SS), Having different hourly rates and different hours worked. For example, Rate 1: @ $8.25/hr if the employee (EE)...

Hi, need a bit of help on this one. I need to be able to count weeks. (Mon-Fri). I also have to be able to count part weeks (Thur-Fri) Now i am guessing that...

How do I create a hyperlink from one place to another within a worksheet so that when the worksheet is copied, the hyperlink references to the copied worksheet...

I want to remove protection from a number(about 200) of similar worksheets in a workbook simultaineoulsy. They all have the same password.

Greetings all I'm using excel 2003 and have a line chart with over 2000 points how can I zoom into just a section on the line chart graph? Is...

I've downloaded a csv file from bank. The date needs to be in MM/DD/YYYY. I type in in as text 01/01/2007 but when I save it it reverts back to date format.

I hope someone can give a direction with this problem, even though it may be rather simple I just can't get my mind around it. I want to create a IF Statement...

I am better at VBA than worksheet formulas. :shrug: I have this formula in a cell: '====== =MID(D6,4,FIND("-",D6)-4) '====== What I want to do is append "& "...

It seems, at least for me, that formatting cells to "General" is nearly impossible to maintain. I set a cell (or thousands of cells) to "General" format for...

Why do hyperlinks change folder locations and maintain the file name when I copy/paste workbook to workbook? I have tens of thousands of hyperlinks in a...

Is there a way to use conditional formatting to highlight any cells on a worksheet that contain a formula? -- Thanks, Rick S.

I help a school install new equipment when they get it. Yesterday I went in and installed a new computer that has MS Office 2003 installed on it. The old PC...

I help a school install new equipment when they get it. Yesterday I went in and installed a new computer that has MS Office 2003 installed on it. The old PC...

I'm trying to do a COUNTIF with a cell reference -- specifically, COUNTIF(EV2:EV6000,"1"). However, I want the one to be a cell reference so the user can...

Another way could be to use Data Validation, with a Custom formula =EXACT(A1,UPPER(A1)) which will prevent any lowercase entry. Well, except for a...

I have a colume, say "F" with some time stamps in it. The rows are sequential times as it is derived from a imported .csv file from a nother device. Therefore...

I have a spread sheet with colum "A" contaning 145 rows of data. In this range there are 12 different products in order of when they were purchased. In column...