Sorry I have already asked this but the answer has been lost somewhere, or i can't find it now. I have a list of data which i want to match the words then...

I get this message everytime I copy something to the Clipboard. It pastes fine. I've just never seen this message before. What does it mean? Do I need to...

I'm trying to count the number of cells that meet criteria in multiple columns: Column AI contains a job number Column AJ contains "blank", "0", or...

I have two sheets in a workbook that have the following columns Sheet1 Col1 Col2 01/01/2008 01/03/2008 02/09/2008 Sheet2 Col1 ...

I have saved a template and when I enter data it merges into the next column. Is there a way to locke the cells where only x amount of info can be entered...

needing to know how to take pieces of data from other fields and auto fill into a 3rd field. For example, field one is First Name, Field Two is Last Name,...

Am trying to create a formula that will tell me: if the range of cells has the single letter "R" or the single letter "T" in the individuals cells, it will...

HI, I am trying to make a cormula that calculates what someone would be on time to achieve, based on their current number and then project what they would...

Hi... I am learning about writing macros. I always stuck up at one point. I need to do various activies on columns based on their headings. e.g. I have to...

I have a large workbook with several different woksheets in it. Each worksheet refers to a different individual. Is there a way that I can set up this...

I have text data - when a customer no longer wants to be contacted I would like the rows associated with it to cut and paste into a sepearte worksheet...

Hi. i have a workbook with multiple worksheets and some of them contain matching data. say, i have worksheet A where i have numbers in column 1, and i have...

How do I set up my worksheet to use the IF Command. I have Columns C D E G in a Row C can only have a value of 1 to 5. If this value is filled...

Hi , I have given pwd protection to my worksheet and now i forgot the pwd of the worksheet. Kindly tell me "how to Break the Password of a protechted...

I have produced a simple questionaire in excel i.e. 20 questions, with a reponse predefined as YES or NO. In another sheet "Report-calcs" it will list the...

I am creating a series of spreadsheets which are used by multiple users on different computers. When we create the links we use a "global" reference...

I have an excel file with 5 different sheets. I want to check sheets 1..4 against there is a match for my data in sheet 5. How do I do this ? What happens if...

I have made the following formula in a spreadsheet im working on to find the amount of packs in a delivery as a percentage ((J48/SUM($J$48:$J$50)*100) and...

Hi.. I have created a macro. One variable is defined there as: dim var1_d as integer var1_d=200 Then on the userform, I have a textbox (var1) and a checkbox...

i'm trying to split data which is seperated by line breaks into seperate columns. line breaks are not in the standard delimiter list and i cant find a way or...