Hi I get the following error message "Can't Find Project or Library" when I run the following code: Application.ScreenUpdating =...

How to extend the Excel sheet from sheet 1 ( i.e. IV 256) to other sheet(e.g. sheet 2)? E.g. I want to input data 512 point into the column, but Excel only got...

Hope someone can help here! Code Year Jan Feb Mar Apr......

I am looking for help with nested functions. I found one on the site that works well for part of what I want to do. It...

I have four checkbox per a single row...I want to be able to click one one and have the other three remain unchecked...that way I know only one can be selected...

I'm not sure if this is a VLOOKUP or IF/COUNTIF. How can I count the number of occurrences of a value in column D that match column E and will put the values...

I have a column of data (Excel 2000) which I would like to sort alphabetically. Some entries have a double asterisk preceeding the first word (**word). I...

Is there a way to add indicators such as an arrow on a line chart? For example, say I have a cell that contains, "N" and the date next to it (the date is my...

How can I automatically paste hyperlinks from one cell to another ? Ex: I have the names of movies in column A and the URL in column B. I want simply that...

Having data below in an excel spreadsheet how can I make a unique formula in column D that gives in lines where the text in Column B begins with "Cap" the sum...

Hi Im using the if function, If example A1=B1 insert C1. A1 (text field) has this formula in it =IF((I38=3),MID(H38,1,1)," ") B1 (text field) =3 C1 (text...

I use Excel on a daily basis. One of the biggest gripes I have is that when I'm dragging a forumula from one row to another is that I almost...

Hi I was hoping sombody could look at my formual and tell me were im going wrong. I have a number in I38 and depending on the value (1,2 or 3) it splits the...

Hello, I am using Example 1 on the following website: http://www.rondebruin.nl/sendmail.htm. The problem is that Outlook is blocking the attachment stating...

I want the sum of a cell from a range of worksheets. What is the formula?

For several years I have used a spreadsheet to balance my checkbook and provide YTD totals by category for a span of the previous 5 years. Each year is a...

I'm calculating retail prices at various gross profit percentages. I do this by dividing the cost by the reciprocal of the desired GP%. I want the results to...

Hi All, Is there a formula to join the following characters to create the example shown below. B2 C2 D2 (End Result) JORDAN ...

What is the shortcut to navigate back and forth from worksheet-to-worksheet in the same workbook?

In March of 2004, someone asked how to make all text characters in cells uppercase. While personally this is something I would not want to do, someone in my...