I would like to know how to stop excel from adjusting references automatically when inserting a new row. Example: A1=SUM(A4:A8) If I insert a new row on A4...

I'm working with one workbook - two or more worksheets - one cell on each worksheet. I would like to edit the cell on any one of the worksheets and the...

I have a two page workbook. Page 1 is instructions for the information expected on page two. Page 2 is called Customer Info. I would like to have a button on...

I want to know how to convert a cell to a number When I do my expenses column N36 calculates the sum of the claim eg £1246.78 in cell D40 I have to write...

Suppose I have a listbox, name it listbox1, containing 4 elements : A, B, C, and D. There is another listbox, name it listbox2, whose value will be subset of...

How can I construct a formula that will relate TODAY to the 1st Tuesday of each month. For example as today is 01/12/07, my formula should return...

have a "database" of names and addresses completely in uppercase letters and need to format it with the PROPER function so I can use it to print address...

Greetings to All! I have a workbook with say 8 to 9 worksheets each containing multiple columns not arranged the sequencially. For Eg Sheet 1 has the...

I would like to be able to have a window open to select the Range for Range("A10:B10").Select and then have the other susequent ranges follow this choice. Any...

I want to be able to get a vale from another Excel file where the value of "E3" will change depending on the day of the month. Below was what I tried, but it...

i have a workbook containing 3 sheets sheet one is my main one the other two are for reference , on sheet two i have a data entry of "2N" in cell C76. i want...

I need to clean the periods from the first column and the first 6 characters of the new data. In otherwords, I need column B to come from column ...

I have a nested if formula, where I am looking for the total of the values in a range of cells which match 4 ranges of criteria. Total number in cells...

How do I count the number of cells in column A that contain a certain string but only if the same row in column B contains a certain string eg A ...

I am trying to get a formula that will look in column c8:c250 and will only give me the number of occurances between two numbers. I have used the...

Could any one show me how to write a number in words. Which formular can be used? Ex: In A1 : 565 A2 : =(????,A1) = five hundred and sixty-five

An equation... =SUM(IF($B9='Lineup Worksheet'!$B$2:$B$83,'Lineup Worksheet'!$C$2:$C$83,0)) produces the correct answer of 1:04:21. But I want the answer to...

For every occurrence of a string in B9 in the current worksheet, I want to count the number of cells that contain the letter W in Lineup Worksheet F2:F83,...

Say I have a hyperlink in Cell B2 I want to make a copy of that cell in B10 How would I do this.. If I just use the formula of =B2 in cell B10 it just...

****al, I have data like Farmer _ID Name_1 Name_2 Link Path 100003 Kamadinni Shasappa...