How 2 sort an autosum total list after adding items 2 autosum item Utf 0 169
Am using detail dollar amount list to insert new transactions in the middle of a the detail list, and they in turn get included in the 'autosum' tot...

Sort problem Utf 1 164
I have the months of the year in one column. I need Excel to sort the months, but according to calendar. I need January, February, March and so on. ...

Find and Replace error Utf 3 128
Hi. I have a worksheet where I want to show only some of the formulas used in it. That is why, instead of using the option "Show formulas" from t...

Excel 2007 - Copy Picture Resolution Utf 1 323
When I select cells to copy as a picture in Excel 2007, the resolution is terrible. Text and objects with shadow's are very blotchy when pasting th...

Filtering or Formatting DataValidation List Utf 6 82
In ColumnG I have the following formula array from row2 all the way down to row100 =IF(ROW(FilteredMonday)-ROW(E2)+1>COUNT(F2:F100),"", INDEX(...

HELP needed to remove 2nd spreadsheet within a workbook Utf 3 139
I have a large workbook containing 10 worksheets. It's quite large. Somehow - and I don't know how, I created a copy of my workbook that open behind...

how to find duplicate entry in one sheet and in workbook Utf 1 279
how to find duplicate entry in one sheet and in workbook ...

Pivot table magic bill_ball 1 114
i want to see NA in all cells where data is empty in pivot table. Is possible without vba? thanks in advance -- bill_ball ...

insert an Excel spreadsheet as an appendix in a Word Document Utf 1 493
I am creating a Word Document, in which, I need to insert an Excel spreadsheet with calulations on it into the Word Document. How do I do that? ...

extracting data from one format to a different format... Utf 2 127
I have a large database of company contacts that is formatted/entered as follows: ABC Company, Inc. John Doe 123 Main Street NE Des Moines, IA...