I'm trying to run the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then Range("C65536").End(xlUp).Offset(1,...

How can i display an error message if the sum of values exceeds a certain number, or not to allow sellecting a number from a list if the total values exceeds...

Hi, I need to find a formula which gives me a total in the cell of all cells which are formatted in a certain colour. This is for a banking spreadsheet with...

Would really appreciate someone telling me how to display a name (from 10-12 possibles), based on multiple options in a range. In the column A (range), there...

i need help making a wooksheet that right to left each column increases by 12.00 and each row going top to bottom with increase by 8.00 so i can go to line...

I have a couple of charts that need a line drawn at a certain number on the value axis. Is there a way to place a line on the chart? Any help is...

please look at the following and advise that y i am not getting the accurate values, this formula provide results but not correct, value are ok uptill 4 rows...

I have several working worksheets with data. I made an summary sheet for all working worksheets. The formula I used is...

I am trying to get a count of rows where the date column has a specific date and a second column is marked with an "X". Example: Col F is a column of...

I designed a Pivot table to look at various data, with 2 fields in the column section. The information is perfectly accurate, but because of the quantity of...

Hi... I've wasted a full day today trying to do vlookup with zipcodes. Some zipcodes start with zeros. I want to import county from one worksheet with zip...

Is there any way to lookup multiple answers to a lookup formula. Normally, Excel will stop at the first match it finds and return that as the answer when, in...

The first sheet in my workbook is a rollup of all the sheets in the workbook. I have a conditional format that if cell A1 in sheet1 is greater than 44 to...

What type of formula can I use to calculate a percentage range? I want to figure a certain percentage range for a commission. 80% - 89% = 1.25% paid out 90% -...

i want to convert date into normal american style. i am importing date from text file where date is coming in this format(in three different column...

I am trying to use the Microsoft.com Excel instructions on how to look up a value and return multiple values...

Colors do not show up on my screen but show up in print preview - How can I get them to show up on the screen -- Thanks

NAME COMPATIBLE MAIL MERGE SYSTEM FOR EXCEL SPREAD SHEET

I am running Excel 2002. I have a Workbook with 4 worksheets. I created a Control Option Button (OptBtn01) on Sheet1. I have a Control Check Box (ChkBx01)...

how do I widen a drop down box in a spreadsheet so I can read the contents, without increasing the column width -- Mick