I want some cell contents of my worksheet not to be printed. I have resolved my problem by running a small macro before printing but I think it would be much...

Hi I'm a new user to this site. I've used it to get this far, but now I'm stuck. D11:D50 has quantity values, which can alter I11:I50 have a pull down menu...

Is there any way to have a conditional text box? When I click on a text box the conditional formatting option is greyed out. Is there a way around this? In...

Scenario: A1 + A2 = A3 so in A3 i have "=A1+A2" So if i want to copy that formula in lets say B3 then it would adapt the reference so it would ready...

Hi all I wonder if this is possible, in cell A1 e.g. i have =today() Is it possible in cell A2 to get it to calculate and show what week number this...

I have an Excel 2007 workbook that includes data validation set on a number of cells. When using a data form to enter data and I enter an invalid value on...

Hi. I'm hoping someone will give this a try. I'd like to enter a function into each cell in column D so that the total hours worked for the previous week...

Cells U2:AC2 have 1000-9000 lbs. Cells S3:S14 have Compartments B thru M Cells U3:AC3 have the following figures corresponding the weights above. 7.3 for 1000...

Column AZ contains cells that are either zero or are blank (meaning no value has been entered in the cell). The formula below is referencing the blank cells...

Hi All, I am using Windows’ Excel 2003. If possible, I would like a single and flexible formula to provide the results of the scenario listed...

Column AZ contains zeroes as well as blank cells (meaning no value has been entered in the cell). In my formula below, I want to reference only the cells...

In using this function, I'm entering values as decimals (ie, I'm looking for a random number between 1.35 and 1.65. When I do this I get a result of 2....

I need a formula to 1) look in colunm a, gather any numbers present in that colunm, even though most wil be empty 2) then i want them to take that list, get...

Hi, I have given Function =IF(G931,G93+14,IF(G931," ")) in Column G,H,I & J what happen is, if the date is there in the column F then everything is ok,...

I would like a formula to randumly pick numbers between 1 and 45 but once a number is picked the number won't be picked again. Is that possible? -- Carolan

This should be simple, but I'm lost. To greatly simplify my...

I have strings of text which are file locations within a worksheet e.g "\Clinical_Audit\Projects\Project Monitoring\Audit\0910\CAMHS\02 Improving access to...

Hi Please could some one tell me how I can make a cell only select certain info depending on what is put in the previous cell. For e.g Cell 1 has various...

Looking to return an error message in a column of data if the same value has been typed in previously

I have an excel sheet with command buttons. If i try to save this excel as a html file, the command buttons with macros does not work. Is there a way that i...