I have my excel worksheet protected except for the cells that will be used for data entry. In an older version of excel, when I pressed the tab or enter key,...

Nothing wrong as far as your VLOOKUP set-up is concerned. Take it that the VLOOKUP cells are formatted as percentages. Kanga...

I hope that someone can help me with this: I am setting up a 20,000 item spreadsheet, where my staff will put an "X" in an adjacent column when they are...

I am referencing data in an Excel inventory spreadsheet with over 20, 300 lines. I have written a macro that will reference information from a cell in...

Hello from Steved =HLOOKUP(A1:B1,C4:AT125,3) would like it to be =HLOOKUP(A1:A2,C4:AT125,3) The above formula works fine on A1 I want to change B1 in the...

If you just want the last value in the column, regardless of whether or not you have any blanks in your data, then the following will both do...

I need sum cells with time. I have this case: A1=15:17 and A2=23:04 When I sum A1+A2 the result is incorrect: =Sum(A1:A2) = 14:21 Why???? Thank you.

Is there not a way to use this as a User Defined Function? ------------------------------------------------ ~~ Message posted from...

I am trying to combine data between many worksheets in 1 book. I want to select specific cells in each sheet and have them calculate on another sheet. I have...

=INDIRECT("F"&C1) Rgds, Andy

Example: A B C 1 3-Mar-03 7-Mar-03 4 2 4-Mar-03 -37684 3 8-Mar-03 37688 4 5-Mar-03 2-Mar-03 -3 The formula...

I am filling a column with a simple formula: =A13*D13 =A14*D14 How can I fix it so the zeros do not show when the there is no quantity in A columns? Thank you...

I keep getting this fault and tells me to contact vendor. I created the sheet and its been working fine, now all the sudden I get this fault. Any...

Please help - it is driving me crazy. I have a column of "total points" it is a simple sum of cells across the row from a-al and the formula is copies in all...

What I have is 5 columns of data A=Part number B=Cost C=Qty D=Quoted E=Comments 123 1.00 1 History 456 .50 7 ...

Hi,.. I have a drop-list on A1 and it contains (jan, feb, mar, apr,..etc..) and i want to change the color of $B$1, $B$2 when i select one of ...

Is it possible to use VLookup to lookup an external sheet in a macro?

I have a column with this formula for a columd of data: IF ($I164$J164,2,0) and I need to insert a column between H and I so the formula changes to compare...

I'm pulling in names and addresses from a seperate workbook. I have 2 address lines. If the second address line is blank in my source data, is there a way to...