entered

I have a workbook where in the 1st sheet I have a spot to enter a value and then I want to click a button and it will print the next corresponding sheets in the work book. For example if 5 is entered it will print the next 5 sheets in the workbook

Hi all. I want to validate a textbox to confirm email has been entered correctly. I remember this being an issue in the past and it seems it still is. I have been using the code bellow and was feeling that, I don't want the OK message if the email is okay but rather want a user message asking...

Hi all. I have a spread sheet which is completed using production data. my issue is that when a machine runs more than 1 product only the info. for the one product is collected. What I want to do is enter a figure in column "E", its either going to be 1 or 2. If "2" is entered then I want to...

Hi please forgive my lack of experience I’m a newbie. How can I have a blank cell if no data entered I’ve tried stuff I’ve found on the internet but no luck. Thanks =IF(DATEDIF(C2, TODAY(),"y")=0,"",DATEDIF(C2, TODAY(),"y")&" years, ")& IF(DATEDIF(C2, TODAY(),"ym")=0,"",DATEDIF(C2...

Hi everyone!!:) Down below I have a list and the problem is this: I want to generate items from the list when a precise value like: 875 X 1150 or 1478 X 3620 is entered in a cell . Let say, someone has entered : 875 X 1150 or 1478 X 3620 in (column A) and I want in (column B) the rounded...

Is it possible to have the data validation in a cell NOT permit any entry at all unless there is a valid date in another cell? I tried this... =if(H9,0,0) ...but it still allows data to be entered in the cell I am trying to validate. Cheers!

I have an activex text box that I need to expand down as more text is entered. It is set to a width of 540 and when text reaches the edge, I want it to go to a new line and for the text box to grow one line larger. If it is deleted, I need it to shrink the text box to fit. It must stay at the...

I just need help correlating the cells from excel into the highlighted fields in word, like the picture below. I copied the cell from excel and pasted it into word and it transferred the information when it was entered, but it left a space before and after the new input in word. Can you figure...

I am using a dropdown list from G16:G2006. Within this list is the option of ‘Cancelled’if this is selected I want anything entered in the corresponding cells in columns ‘N’ & ‘O’ to be automatically deleted and the cells then left blank. I considered having the formula placed in cells...

Hello, I am trying to create a worksheet with a timetable and some time slot needs some action and the detail of the actions needed to be entered. Can i create a form that takes input and store it as a comment and when the cell is selected the pop-up/window can displays the comment in a...

Hi All. I have the VBA code below whereby when data is entered into a cell in column C for example, the date that the info is entered is automatically entered into the cell in column B. I would like to replicate this for columns C:V. I have changed the code to C:V instead of C:C but it enters...

Hi all, same kind of issue as a few days ago.. NewIndate = Format(DateValue(InDate.Caption), "dd/mm/yyyy")NewOutdate = Format(DateValue(OutDate.Caption), "dd/mm/yyyy") If NewIndate = "" And NewOutdate = "" Then MsgBox "Please ensure you have entered a date or date range in the Control...

I am trying to create a printable golf scorecard. I would like to have the cells for holes where the hole handicap, row 2, are equal to or less than the players handicap, column c, to be yellow with a diagonal border, from lower left to upper right, so that the gross and net scores can be...

I have a project plan that works fine. I'd like to add a column for dependency and the date would be updated based on the finish date of the row id that is entered. Any suggestions on if this is possible?

Hi I have a formula that runs in column K of a sheet that pulls a value from a pivot table. This is compared to a value that will be entered in column A. The data in the pivot table that column K pulls from changes regularly but I want to be able to enter a value into column A and when entered...

I need a formula to return the word (first, second or third) based on the time of day information is entered in another cell. So for example if cell AT6 were to change at 13:45:00 i want the word first to show up in cell BA6 First: 6:01-14:00 Second: 14:01-22:00 Third: 22:01-6:00

Hi, I have a workbook where the first sheet is a template set up as I want it to look. I then have separate monthly sheets where I want all the details from the template and then subsequently figures will be entered. I have entered the following formula into cell A1 of the monthly sheet ='Taps...

Hi Everyone, I have a problem, I tried creating a new Define Name but the name I'm gonna use look like this... SBC(D255) but when I create, it says an error The name you entered is not valid. Is there a way for me to use these ( ).? Thanks for your help

I have the following code that puts an automatic timestamp in Column B when a value is entered into the same row in Column A. HOWEVER, what I need is this: When a value is entered in a cell in Column A, the automatic timestamp is created in the corresponding row of Column B AND Column E. Is...

hi. data in the range i3:i8000 is there away to force the data alredy in the above range to lowercase ?(i have put some code in so future any data entered will do this)... is there a way to do this without having to change each line manually? MTIA