How can I avoid retyping the number more than one time withen acolumn. I need a message "This no. already exist" to appear when I enter the same number...

hi, i have set up a new workbook containing various text boxes, all of which appear fine on my pc, and on of most of my colleagues' pc's. but on some of my...

I'm not convinced by these answers. I have a similar issue, which I will explain. One of our web apps (intranet) creates a csv file and parses it to excel....

I have a spreadsheet with data that I have protected. The data is entered via another worksheet then sent over via a macro. I have some else using this...

How do I write a macro which loops this...

The excel cursor appears almost invisible inside cells with filled colors (ex. dark grey). I spend alot of time changing values inside filled cells. It's...

Hi All, I have a values as follows B C D f1cagprp.p #N/A yfrcpent.p f1caiq.p ...

I am working with a spreedsheet incorporating invoice numbers. How do I create a warning when i repeat an invoice number

Hi guys, Lets take this scenario: Brian 20 Michael 30 Ivan 40 Brian 30 Ivan 60 Michael 70

I need to copy the formula "=IF(MAX(Sheet2!B5:B200)(TODAY()-21),"not due","due") in sheet1 from cell b2 to all the cells between b3 and b200. Each cell should...

How do I print my adresslist on labelsheets? In Excel i looks like this: Cell 1 Cell 2 Cell 3 Cell 4 Name Adress City Citycode

Why does (not equal to)not work in the formula in Validation EX D81.5 D81.5 does work

I have a list of data as follows: A1.0.0, A1.01 A2.0.0, A2.0.4,A1.0.0 Now i want to put all the values into one cell and at the same time make sure there are...

I'm working with four columns. the cells in my 4th column are going to be the averages of the other three columns. If I copy my average formulay down the whole...

I only want to send one worksheet from excel not all the worksheets that I created at one time, is this possible?

Hi How can I return the full path of a template using VBA and login name of windows XP using VBA? Thanks

Hi, I need to zip a file that I am working on, then email automatically. I can do the emailing bit, but can't do the zip The OS is XP professional, with Office...

How do I convert text case in the same colum or row. At the moment I use UPPER, but have to create a new column/row.

I'm looking for a formula similar to the following, but one that works. =average(if((A1:A4="Jones")+(C1:C4"0"),C1:C4)) Column A represent sales rep column,...

I have the cost of the product, the percentage of the commission I am paid on the product and the dollar amount that I want to make in commission. Is there a...