Hi, I wish to email just a single sheet, or even better a selected / specified area of that single sheet, automatically when the user presses a button,...

Hi, I have a user who has received a spreadsheet from Ireland, and it contains formulas that I haven't seen before. Either the formulas are wrong or they are...

Question #1: FIND is normally the first step of a two-step process: 1. FIND locates a cell with the specific text or numbers contained in the "Find What"...

Hi! I need a simple formula that will tell me what percentage of a column has, for instance, '1' as the value, values range from 1 - 4, sounds simple but I'm...

hi, i have a query on advanced filters. i downloaded some xl files from debra's site in order to learn more about them. in almost all of the examples, the...

Can someone tell me how you align numbers around the decimal point in a column using the Microsoft Excel program? Thank you in advance.

Hello together, i have a strange problem: I wrote a VB6 application that works like this: - create an Excel.Application object - open a workbook from an...

Hi A new website is now available for information on validating Excel spreadsheets and ensuring compliance with regulations in the Pharmaceutical and other...

How can I use SUBTOTALS to get BOTH column totals AND item- counts? For example: Part Nbr Amount 39495 100.00 39495 15400.00 39495 ...

If I open Excel 2003 it opens Book1 (that is normal), then if I make no changes to Book1 and close Excel it asks if I want to save Book1. Normally if you...

Hi, Am working with data inported from Access for the first time, and it's not allowing me to drag formula's across, any ideas why? Cheers!

I am using excel as a data base. I have set up sheet #2 to extract data to use in a Word mail merge document. My question is "How do I tell Word that my data...

How can I determine where the data source is for a series in a pivot table? I'm trying to figure out a spreadsheet that I've been given, but am not very sharp...

After several successful cut n paste actions I receive and error msg "can not empty the clipboard". When I access the office clipboard underneath Edit it's...

Can anyone think of a formula for footy scores, ie 5 points for correct score. 3 points for right result but incorrect score. & 0 for incorrect result.

Does anyone here know how to make a Excel Document display properly on a web page. When I try it, all I get is a little box, with a X in it. I would...

Does anyone know how to convert julian date to calendar date in excel?

Hi, I am not familiar with Excel 2003's XML capabilities and looking for more information. Is there a book or website somewhere that will provide some...

I am having trouble saving an excel document to an external USB 2.0 hard drive. The temporary file stays in the target directory but the fiel is not saved. I...

Hi... I was sent a large excel file (about 50 mb) with a .csv extentsion which I am having problems loading into Excel. Whenever I try to load the file - I...