I am trying to force data entry on specific cells within a worksheet before the user can leave the cell. I was working on this and got my code to this ...

I have 3 worksheets (different resources) which all contain 2 to 4 columns listing the grade level that each of that households child attends. Example...

I have 3 columns. I need to take the value in column 1 and locate the matching value in column 2 and then write the corresponding value in column 3 to a new...

I have 4 columns in a sheet. First column contains Ac/No of client. Second contains conference calling line, weather unlimited or limited typed as U or L....

I want to count text/numbers in a range of cells based on a certain criteria only the informaiton in another column (same row) meets specific criteria.

I need a formula to tell me which reports had a notification associated with them. The spreadsheet is set up like such: A B 1 4 300456 2 3 ...

I have scatter charts that will change as new data is added but I can't seem to get my macro that adds the data labels to work with defined names. Does...

I'm trying to conditionally format an entire table so that the rows highlight rew when a date is passed. However, when I copy the format the reference for...

I have tried Jon Peltier's example on linking table to sort data for charting by using the LARGE function, to no avail. My data is set up different than...

I have one column with time values in 24hr clock format (1742,812,1314,etc) without colons. I can convert the times to a 12 hour clock and add the colon but...

I am trying to create a user friendly input form in Excel. I am using the control toolbox for this. I would like the user to choose one or more items from a...

I need to count the values that are between and equal to 200 and 224 in the data range of C173:E187. I've tried eveything I could think of and can't get it...

The excel 2003 SP2 "help" for the percentile function says that percentile does not support more than 8191 data points. It says that it will return #NUM! if...

I need to sum budget from month 1 to month "N", where "N" is a variable that changes each month, but I don't want to change the sum formula, only the...

How to use =INDIRECT(A1 & "!B7") if B7 is in another worksheet on another workbook? For example: workbook name=List worksheet name=n1

How can I add same words/data into multiple non-blank cells at the same time? Thanks!

Hi, I am trying to make a sample of 25 from 100 employees using Excel 2003. But everytime i do a sample, there are two or three employees that are duplicated....

I am new to povit tables, I have just actually discoverd how handy they can be. I am wondering if the filters can be either linked or controled by a...

I like to be able to keep changes I made to pivot chart even when I refresh data or change the cell reference for underlying the pivot table

I have a spreadsheet with roughly 2000 rows and 18 columns. As part of a macro, I sub total columns 7 and 17. I use a macro to copy select cells into a...