How can I enter text in one cell and have it copy to another cell automatically, not using copy/paste feature. Such as type in date in cell A3 and it...

I'm not even close to a programmer but here is what I need to do. I have a table of multiplication factors that look like this: 0-300 .15 301-500...

Allow for the worksheet tabs to be displayed on the vertical axis to allow more tabs to be visiable at one time. Worksheets should be able to be organized...

I have an excel sheet for vacation plan It has last working day, last vacation day, and the month from Jan to Dec, each month divided into 4 parts (weeks). I...

I am looking to input mulitple cells into a email. Maybe as a hyperLink. Is this possible?

How so I set up a spreadsheet or databse to recognize the text, weekly as 7 days monthly 30 and annual as 365 and then apply that to a current date to see a...

Hey all. Here is my dilemma. On sheet 1 column B i currently have 64 numerical entries to which i am adding 1 entry each day. On sheet 2 i am trying to do...

When I edit external links within excel, I end up with the link showing up as text in the cell instead of it actually pulling information from the linked cell....

I created the following array in Excel 2007 and it works fine. I then save the spreadsheet to be compatable with 2003 and when I open the file the data is...

I created the following array in Excel 2007 and it works great. =IF(ISERROR(INDEX('Roll Cleaning Data'!C:D,SMALL(IF(cleaning_status="...

unable to change cell shading color in excel. can change font color,size, etc.., but when trying to change shading it seems to "ignor" whatever color is...

Can you help me out with this? if works fine if the external source is open but returns a #value if its closed. is there anyway of correcting this? -- ghynes

hello.. im looking for formula which will give me an output related to the date. heres what i am looking for. i have a list of work shifts in column A, and...

I have a column with the Middle Initial and Lastname(L Doe). How do I copy the middle initial and lastname, to seperate columns? I was going to get the...

I have column A and Column B with currency values in them. I want to compare A1 to B1 and if they do not equal each other put NOT EQUAL in C1. How would I...

I have a column with a middle initial in some of the cells. I would like to add a period after the initial and the cells without an initial, leave empty. ...

I have a column with a middle initial or a middle namr or it is blank. What I need to do is add a period to the middle initial only. If it a missle name or...

I don't understand why this formula does not work Cell D 10 is =IF(B10=1,$G$72,(IF(AND(D11=0,D9=$G$72),$G$71,0))) Cell D 11 is...

I need a formula for when a workbook is opened it will default to a specific tab.

After two hours of figuring out how to get one of those cute option buttons...I don't know how to add a value to the buttons. Example I need one button to...