inputted

Without using Macros and VBA, is there a way for the date to automatically come out when a cell already has something inside it? For example: Let's say I want A2 to show today's date if some information is inputted in cell A1. =if(not(isblank(A1)),today(),"") will not work because it will...

Hey guys i have this code in data valididation. this basically does not allow a user to enter any data in Range R11:R30 if column O and P does not have data =COUNTBLANK($O11:$P11)=0 So for example : If O11 has data in it. P11 does not have any data in it. Now if i try to type any data in R11 ...

I have a table that has a range of cells in it <tbody> a b c d e f g h i j k l m n o p q r s t u v w x y 1 12 18 47 2 72 67 67 3 70 45 45 56 4 34 56 5 56 67 6 total...

This can't be complicated... I have a huge amount of cells with figures already inputted into them. I would like to simply add a percentage to those cells. Thanks a bunch L

So I am trying to do this code at the end of the "Button click". If the QTY.value is > 1 then I need it to copy the data that has already been inputted in the spreadsheet = to the X QTY. If possible I would like the Dimension# stay put and no changes to it. https://goo.gl/HWRn9T Per the...

Hi, I have a userform with 2 inputs (ID and Name) When a submit button is pressed I'm wanting this data to be inserted at the last row of column A in CSV file. So ID in A, Name in B However if ID inputted already exists it should throw an error and not add it. Appreciate any help

Using " For I = 1 to Nb " and created Comboboxes on userform (Nb being the number inputted by the user to create the Comboboxes to input peoples names in e.g. 4 people need to have there names inputted into a sheet.) I have happily got the code to input the values into columns. What I am trying...

I need a formula that will search the column headers for a user inputted text and then search that column for another user inputted text then it will give the result as name in another column

Sorry I meant sheet not workbook Hi I have 1 workbook, example, I have 1 sheet named 'Calls', in cell C4 a value will be entered for example '1 day' I have another sheet on the bottom 'Collection' I want it to log/copy '1 day', from A1. But I still want this info to remain on 'Collection'...