On a Windows 2000 workstation (with all updates applied), an user's excel application now closes any current file that is opened, when she opens up another...

I'm trying to get a spread sheet to do the following: Enter $243,323 (for example) Now i want the first $100,000 to be multiplied by 5% and the next $100,000...

I need to somehow exceed Excel's limit of 3 conditions to format a cell. One possibility would be to specify that a cell is equal to a range. For instance, I...

Hi, I am trying to sort a worksheet on the basis of the Lot#. The lot# has values like 1 2 1s 3 2s 4s 4f

I currently have a formula in a cell which gives me a value based on data in various columns. What I would like is for this value to change automatically when...

Is there a smooth way of copying pdf tables into excel without destroying the structure of the table? Otherwise is there any function like FIND that can start...

I want to create a macro in Excel that pertain to the current cell. For instance; I have several cell that need to be sorted while others cells does not so I...

='Raw'!A1 should do it, if the cell is empty you always get a zero, if not you get what's in the cell -- Regards, Peo Sjoblom

Dear Friends, Does anybody hv a softcopy of the VBA Developers Handbook, 2nd Edition (Ken Getz & Mike XXXX) for download? V donot hv the book (2nd edition) or...

Is it possible to calculate number of months in a formula, such as "Sep03 to Dec03 would be 3 months"? I currently break it down using days, but the varying...

Hi I have a spreadsheet that I want to put on another computer. this other pc uses an older version so I save as Microsoft excel 5.0/95 workbook. However...

I have a dell inspiron 4000 and am printing to an HP deskjet 932C - I am working with Microsoft Excel 2000. I have a one page spreadsheet that I can't print. ...

I had a paste button which provided the possibility of choosing the paste option (such as values or format) thus saving me from the need to access the...

Wondering if there is a way for me to do like a group by with a count. For example I would like to do a group by the age and a sum of the qnty. I have no...

I cannot figure out how to calculate the date for the "next friday" from the current date. specifically, I have a spreadsheet where I want to count the number...

I HAVE FORMATED TWO COLUMNS USING THE DATE FORMAT FUNCTION. I WANT THE DATE ENTERED ("COPY FROM"),TO DISPLAY IN A DIFFERENT CELL ON THE SAME ROW IN A DIFFERENT...

Hi. I am trying to do the following... I have a column list with 1 column that lists 4 Product Groups ( Group1, Group2, Group3, Group4). Call this List...

I created a worksheet form, saved it as a template, and protected the form. This makes the cursor hop from one unprotected cell to the next, in sequence, as I...

How do I paste range names and their addresses from one worksheet to the next?

I have 6 worksheets in my workbook Sheets 1-5 is the time sheet that looks like this In out In out Ttl 8:00 12:00 11:00 5:00 8...