Hi, I'm experiencing an extrange behaviour when trying to define a new data connection to a Foxpro table (Dbase III) from my Excel 2003. It takes more than...

Our accounting group is divided into the payables and receivables. I am in the receivables group and have gathered the inventory totals and have to set up a...

Can someone tell me where i could find a template for dupont formulas?

Hi I want to write a macro code to retrieve the value in a Cell in Range( B1 : B20) if the corresponding Value in C1:C20 is " Open". The Value should be...

Can I change the number sequence? I would like to combine 3 rows and have Excel only number it once but not to wrap so each cell is individual.

How do I control printing headings on some pages and not on others when printing multiple pages? Thanks in advance Danimal

Hello. I am setting up a worksheet that i need to allow others to access. I have to be able to guarantee that the data they add is saved. I want to create...

I have created a pivot table from a master excel sheet with several different "Users" listed with their accompanying Turnover information. I now need to send...

How do you apply strikethroughs to a row where some cells contains characters and other cells contains spaces?

why is the date on workbooks changing when I open it. Workbook dates used to change only when changes were made. -- REM

Is there a way to change the Print Quality for all tabs in a workbook without going to each individual tab and changing the setting there? I have a 70 tab...

I like to use the worksheet functions like "offset"....yet i am so careless in inserting columns and rows and cells on the spreadsheet. I am always...

I recently reinstalled Windows XP (including SP-2 update), and am reconfiguring Excel 2000. Some questions: 1. Before reinstalling XP, I had a template...

Where do you have to go to change the Font used for Column and Row headings in Excel 2003. Is it done through Excel or through Windows. I'm using Windows XP...

From my previous post yesterday "DYNAMIC NAME"(worksheet function forum), I had just been fed by Gary's Student - single handedly- how to define a dynamic...

HI All, I am working on a worksheet which has a range N11: N33 and has a Numeric Value, I want to send a email directly from EXCEL if any cell in this range...

Hello all I would like to hightlight a row based on a value in a cell. I know it is possible. I just don't know how to go about doing. i'd like to use vba if...

Hi!! I need to write a macro to send a automated email with a text message to a email address through EXCEL macro. it should not give the Alert to click YES...

Hi When entering a formula in Excel 2003 each cell reference is given a different colour. Assuming I can, how do I switch this off and have the cell...