Hi- need to find out how (if possible) to use data validation but include an option to select multiple choices in validation list (ie. checkboxes similar to...

Hi, How do I integrate a keystroke on my recorded macro.. For instance... I would like to create a macro which when you run, it automatically enters the...

I wanted to draw attention to positve and negative trends through the use of color. I used conditional formatting for the number ... but also wanted a...

I'm trying to do a Vlookup where if it can't find the information in the specified array, it returns a predetermined value...is there a way to do...

Dear ladies and gents, please help me figure out how to build a formula for a column of 150 cells, where I need to obtain the average excluding the cells...

I am creating a simple find loop to find all the "smith" entries in column A. I copy & pasted this code from Ozgrid and modified slightly. Sub...

I have an excel sheet that has information pulled directly from another software program. In the other software program there are sometimes asteriks in...

I am using Excel 2003 and I am using a simple logical function =If(I8=J8,"PASS",'"FAIL"). This works fine, however, I am trying to figure out how to have...

I have a user who has the above issue with a Ricoh Aficio 3235C. He can change the properties to colour, print preview shows in colour, the B&W printing is...

is there a way to have two different subtotals? One for the sum of cells, and another for the count of cells? Thank You

hello Is there a way to change the SS# in the following format from an existing table of SS#? 99-999-9999 change to xx-xxx-9999 Thanks

Hi - I'm doing an average that pulls from 31 different sheets in the same book. I can do the average for 30 sheets ok but when i add sheet 31, I get a...

I would like to know if there is a way I can export cells from one execel file to another excel file in a bulk update. And be able to assign each cell on the...

I have a list numbers with set values. For instance: 0 = 123 1 = 456 2 = 789 If I enter a 0 into cell A1, I want 123 to automatically be entered into B1; If...

I have a calculation sheet, where i want to make sure that users dont accidentally delete the formulas necessary to complete the calculations. - i've tried...

Can we create forms in excel that would populate the corrensponding fields in excel sheet? Also if we could create forms, can we make certain fields to be...

i would like to be able to turn worksheet protection on and off over several tabs at one time in a workbook. i have the same range of protected cells on each...

I asked a question earlier with two parts. I figured out the date format. But I am still having trouble adding 10 years to the date and having a column show...

Is there a way to insert a footnote into an Excel 2003 spreadsheet?

Hi, in case I use the following formula: =INDEX(A1:A9;MATCH(1;("L-1234"=B1:B9)*("Homer"=C1:C9);0)) Is it possible to find the match with 'Homer OR Janssen',...