General

Adding new folders for "Look In:" when selecting File -> Open
How do I add new "places" in the File -> Open panel specifically the "Look In:" pre-selected locations? Thanks! ... 2 Feb 2010 17:28

Purchasing Excel for a PC to share files with Mac version 2008?
Which version for a PC 2003 or 2007 would be best for sharing files between that and a Mac using Excel 2008? ... 2 Feb 2010 17:28

SUMPRODUCT help with filter
I'm currently using the formula =SUMPRODUCT((F2:I1475>=1)*(F2:I1475<=9999)) This gives me the number in the full range but I need this to update when I put differnet filters on. I've tried different things with SUBTOTAL but can't get it to work Any help is greatly appreciated Sam.D ... 2 Feb 2010 17:28

Vlookup help pls??
Hi - I am trying to put the following formula into a cell E12 but failing =sum of [Col D] where ([Col B] is equel to "this text") many thanks for any help ... 2 Feb 2010 17:28

Preventing Spreadsheets from Email
Is it possible to prevent a spreadsheet which is saved on a shared drive from being downloaded, saved, then emailed; or simply just emailed from within Excel? ... 2 Feb 2010 17:28

How do I change an Excel report title that shows in top left corn.
There is an unknown company name and report title in the top left corner of a report I am working on. How do I change it? ... 2 Feb 2010 17:28

Prevent cells from re-sizing when using pivot drop down option
I know how to keep a chart from being re-sized when for instance i select the filter option from a Pivot table ( my chart uses data from the pivot) But when using the filter option in pivot tables often the column width changes for the new data. I want to know if and how to stop that from happening (like i ca... 2 Feb 2010 17:27

Open WB, copy each sh. & paste into other WB, regardless of tab na
I have this code so far, which opens a WB, copies a sheet & pastes into my WB's appropriate sheet. Sub Get49Data() Workbooks.Open Filename:= _ "C:\Receiving Inspection\SHIPPING\Supplier49 shipping doc.xls" Cells.Select Selection.Copy Windows("Supplier Report.xls").Activate Sheet... 2 Feb 2010 17:27

Counting the number of different entries in a column
Right! column A contains area codes (two digit numbers, eg. 30), column B customer numbers (eg 999999) The lists then go down listing orders. I want to count how many different customers have placed an order per area (not counting duplicates) Thanks for any help ... 2 Feb 2010 17:27

Open/Import MS Money OFX file into Excel?
Downloading data from an online banking website. Besides Quicken files (WebConnect and QIF), the only other file format is MS Money OFX. That is an ASCII format with HTML-like syntax. I am currently writing a macro to parse it. But I wonder.... Is there any way to directly input an MS Money OFX file into E... 2 Feb 2010 17:28